Excel 2010: Tips, Tricks, and Shortcuts

Get quick, bite-sized answers that tell you exactly what you want to know about working with Microsoft Excel.

Introduction

• Get answers to common Excel questions

1. Data Entry Tips

• Fill in a series of data
• Quickly insert multiple rows and columns
• Insert links
• Create and manage dropdown lists
• Summing rows
• Fill in contents with Flash Fill
• Quickly insert a total
• Extract part of a cell's contents

2. Working with Data

• Select specific rows or columns
• Find named ranges
• Change sort order
• Filter data
• Remove duplicate entries
• Convert formula values to plain numbers
• Transpose data from vertical to horizontal

3. Formatting Tips

• Text wrap
• Rotate and align cell data
• Apply international currency formats
• Apply cell styles
• Page options
• Adjust row height and column width
• Add headers and footers
• Align cells
• Add a watermark
• Conditional formatting by cell contents
• Copy and paste cell formatting
• Merge cells

4. Viewing Options

• Change magnification
• Freeze panes
• Hide and unhide columns and rows
• Show and hide grouped data

5. Collaborating on Spreadsheets

• Insert and respond to comments
• Collaborate on an Excel file
• Highlight portions of a spreadsheet
• Draw and mark up spreadsheets

6. Working with Files

• Encrypt a workbook with a password
• Restrict editing
• Save as PDF or CSV
• Inspect a spreadsheet
• Check for compatibility issues
• Add and reference worksheets
• Lock cells