Microsoft Excel 2010
Microsoft Excel 2010 Help Resources
This page contains step-by-step instructional guides for various tasks in Microsoft Excel 2010 (most apply to Excel 2007 as well). At the bottom of this page, you'll also find other resources such as online training courses and videos.
Step-By-Step Instruction Guides
The following are links to Excel instructional guides from Microsoft's website. They are grouped by topic -- just click the topic name to expand the section and view the links.
Can't find what you're looking for? Check out Microsoft's Excel Help site and use the search to look it up.
Getting Started
Getting Started with Microsoft Excel 2010
Microsoft Excel is a spreadsheet software which is part of the Microsoft Office suite.
This software can be used for many purposes, including databases, calendars, accounting, budgeting, time sheets, grade books, and more.
For a more detailed overview of the program, check out the following link:
Quick Start: Basic Tasks in Excel
Microsoft Excel is a spreadsheet software which is part of the Microsoft Office suite.
This software can be used for many purposes, including databases, calendars, accounting, budgeting, time sheets, grade books, and more.
For a more detailed overview of the program, check out the following link:
Quick Start: Basic Tasks in Excel
Interface
Workbooks and Worksheets
Workbooks
A workbook is a single Excel file; a collection of worksheets.
Create a new workbook
Worksheets
A worksheet is an individual spreadsheet within a workbook; the workable area where data is entered.
Insert or delete a worksheet
Rename a worksheet
Move or copy a worksheet
A workbook is a single Excel file; a collection of worksheets.
Create a new workbook
Worksheets
A worksheet is an individual spreadsheet within a workbook; the workable area where data is entered.
Insert or delete a worksheet
Rename a worksheet
Move or copy a worksheet
Saving
Saving your Excel Workbooks
Save a workbook
Save a workbook
Printing
Printing your Excel Worksheets & Workbooks
Print a worksheet or workbook
Preview worksheet pages before printing
Printing Options
Set a print area on a worksheet
Set page margins before printing a worksheet
Print a worksheet in landscape or portrait orientation
Print gridlines in a worksheet
Use headers and footers in worksheet printouts
Save as PDF
Print a PivotTable report
Print a worksheet or workbook
Preview worksheet pages before printing
Printing Options
Set a print area on a worksheet
Set page margins before printing a worksheet
Print a worksheet in landscape or portrait orientation
Print gridlines in a worksheet
Use headers and footers in worksheet printouts
Save as PDF
Print a PivotTable report
Select, Edit, and Enter Data
Selecting Cells & Ranges
Select cells, ranges, rows, or columns
Select all cells on a worksheet
Select specific cells or ranges
Editing and Entering Data
Edit and enter data in a worksheet
Edit data manually in worksheet cells
Fill data automatically in worksheet cells
Copying and Moving Data
Move or copy cells and cell content
Copy cell values, not formulas
Copy specific cell contents or attributes
Select cells, ranges, rows, or columns
Select all cells on a worksheet
Select specific cells or ranges
Editing and Entering Data
Edit and enter data in a worksheet
Edit data manually in worksheet cells
Fill data automatically in worksheet cells
Copying and Moving Data
Move or copy cells and cell content
Copy cell values, not formulas
Copy specific cell contents or attributes
Formatting Cells and Worksheets
Formatting Cells
Merge and unmerge cells
Wrap text in a cell
Insert bullets in a cell
Rotate or reposition data in a cell
Apply or remove cell shading
Apply shading to alternate rows in a worksheet
Apply, create, or remove a cell style
Change the color of text
Change the font or font size in Excel
Formatting Numbers
Format numbers in a worksheet
Format numbers as text
Convert numbers stored as text to numbers
Automatically number rows
Formatting Worksheets
Format a worksheet
Insert or delete cells, rows, and columns
Change the column width and height
Apply or remove cell borders on a worksheet
Insert and remove page numbers on worksheets (header/footer)
Merge and unmerge cells
Wrap text in a cell
Insert bullets in a cell
Rotate or reposition data in a cell
Apply or remove cell shading
Apply shading to alternate rows in a worksheet
Apply, create, or remove a cell style
Change the color of text
Change the font or font size in Excel
Formatting Numbers
Format numbers in a worksheet
Format numbers as text
Convert numbers stored as text to numbers
Automatically number rows
Formatting Worksheets
Format a worksheet
Insert or delete cells, rows, and columns
Change the column width and height
Apply or remove cell borders on a worksheet
Insert and remove page numbers on worksheets (header/footer)
Sorting and Filtering Data
Sorting Data
Sort data in a worksheet
Sort data in a range or table
Filtering Data
Filter data by using an AutoFilter
Filter data in a range or table
Filter for unique values or remove duplicate values
Show/Hide Data
Show or hide columns and rows
Freezing Rows and Columns
Freeze or lock rows and columns
Sort data in a worksheet
Sort data in a range or table
Filtering Data
Filter data by using an AutoFilter
Filter data in a range or table
Filter for unique values or remove duplicate values
Show/Hide Data
Show or hide columns and rows
Freezing Rows and Columns
Freeze or lock rows and columns
Formulas and Functions
Getting Started
Overview of formulas
Create a formula
Create or delete a formula
Delete or remove a formula
Excel functions (by category)
Function reference
Use a function in a formula
Use Formula AutoComplete
Examples of Formulas and Functions
Examples of commonly used formulas
Insert the current date and time
Calculate the average of a group of numbers
Calculate percentages
Count how often a value occurs
Calculate a running balance
Calculate the median of a group of numbers
Calculate the smallest or largest numbers in a range
Convert measurements
Combine two or more columns by using a function
Split text among columns by using functions
Change the case of text by using a function
More Information
Define and use names in formulas
Display the relationship between formulas and cells
Create or change a cell reference
Switch between relative, absolute, and mixed references
Calculation operators and precedence
Error Checking and Troubleshooting
Find and correct errors in formulas
Use error checking to correct common errors in formulas
Correct a #DIV/0! error
Correct a #N/A error
Correct a #NAME? error
Correct a #NUM! error
Correct a #REF! error
Correct a #VALUE! error
Overview of formulas
Create a formula
Create or delete a formula
Delete or remove a formula
Excel functions (by category)
Function reference
Use a function in a formula
Use Formula AutoComplete
Examples of Formulas and Functions
Examples of commonly used formulas
Insert the current date and time
Calculate the average of a group of numbers
Calculate percentages
Count how often a value occurs
Calculate a running balance
Calculate the median of a group of numbers
Calculate the smallest or largest numbers in a range
Convert measurements
Combine two or more columns by using a function
Split text among columns by using functions
Change the case of text by using a function
More Information
Define and use names in formulas
Display the relationship between formulas and cells
Create or change a cell reference
Switch between relative, absolute, and mixed references
Calculation operators and precedence
Error Checking and Troubleshooting
Find and correct errors in formulas
Use error checking to correct common errors in formulas
Correct a #DIV/0! error
Correct a #N/A error
Correct a #NAME? error
Correct a #NUM! error
Correct a #REF! error
Correct a #VALUE! error
Miscellaneous
Tables
Create or delete an Excel table
PivotTables
Overview of PivotTable and PivotChart reports
Create or delete a PivotTable or PivotChart report
Hyperlinks
Create, select, edit, or delete a hyperlink
Create or delete an Excel table
PivotTables
Overview of PivotTable and PivotChart reports
Create or delete a PivotTable or PivotChart report
Hyperlinks
Create, select, edit, or delete a hyperlink
Templates
Other Excel Resources
- Know where the command was in Excel 2003? Find it quickly in Excel 2007 and 2010!
- Videos and Training
