Excel 2007 Tips
Videos 1-10 of 17
 

Hiding and Showing Cells

Hide and show cells

Inserting Rows and Columns

Insert entire rows and columns

Copy and Paste Charts into Word/PowerPoint

Copy and paste charts from Excel into Word and PowerPoint

Change Chart Type

After you've created a chart, you can change its type to any other chart type

Define Name for Cell Ranges

Apply a name to a range of cells

Watching Cells

Easily watch selected cells no matter what you're currently looking at

Auto Calculate

Use that auto calculate section in the Excel window to avoid creating formulas manually.

Entering Data in Cell Range

Select a cell range which will allow you to easily enter in data without using the mouse

Omit Cells in Formulas

Omit cells in formulas

Paste Options

Look at your various paste options

Selecting Multiple Cells with Keyboard

Learn how to select multiple cells with just the keyboard in Excel 2007.

Conditional Formatting

Apply conditional formatting to cells

Customize Quick Access Toolbar

Add and remove hundreds of different icons in the Quick Access Toolbar

Print Select Part of Spreadsheet

Just print a selected part of your spreadsheet

Custom Views

Learn how to use custom views and why they're helpful

View Side by Side

View workbooks side by side

1 2 3 4