This chapter gives you quick answers about how to perform common and essential tasks in Excel. You’ll find information on tasks that are new to you, and you’ll save time on tasks you already know. The tasks are divided into the following categories:
Working with files
Moving around in a workbook or worksheet
Manipulating workbooks and worksheets
Manipulating rows, columns, and cells
Entering and editing data
Working with hyperlinks
Working with headers and footers
Using named ranges
Defining alternative data sets
Controlling how data is displayed
Protecting all or part of a workbook
Spelling and other tools
Working with the Web
Summarizing data with charts
Analyzing data with PivotTables and PivotCharts
Use the following answers to help you create, find, save, preview, and set the properties of Excel files.
How do I…
Right-click any blank space in a folder or desktop and select New → Microsoft Excel Worksheet.
Press Ctrl-N or click Office Button → New, then double-click Blank Workbook under the “Blank and Recent” section.
Click Office Button → New; in the Templates pane, click the category of template you want to display, and then double-click the template on which you want to base your workbook.
Click Office Button → Open or press Ctrl-O; navigate to the file you ...