Automatically Tab from Cell to Cell In Excel 2007/2010 If you have a spreadsheet with several data input cells and would like to automatically jump from cell to cell using your tab key, you can use the Protect feature to accomplish this. In a previous tip we explain how to Protect Cells in Excel 2007/2010. After you have: bullet Unlocked the cells that can be changed and bullet Protected the worksheet You can simply use your tab key to automatically move from cell to cell. This can greatly simplify some types of data input and you'll learn about worksheet protection in the process!

Welcome to Mahe's home page!

When creating Microsoft Excel worksheets formula results are shown in the worksheet NOT the formula. There may be times when it would be helpful if you could SEE the formula in the worksheet.

To display formulas in Excel 2007:

1. Click the Office button
2. Click the Excel Options button
3. In the Excel Options dialog box, click Advanced
4. Scroll down to the Display options for this worksheet section
5. Click to select the option Show formulas in cells instead of their calculated values

To resume seeing the results of the formula, just repeat the above steps.  Or you can use the shortcut keys for toggling formula viewing on and off: Ctrl+` (accent key below the tilde ~).  This shortcut works in earlier versions of Excel as well.
 

Microsoft Excel 2007 Online Tutorials

If you’re trying to learn Microsoft Excel 2007 there are excellent online resources available. I recommend checking these out:

	Microsoft Office Online offers several Excel 2007 Courses
	Excel 2007 Tutorial developed by Florida Gulf Coast University

Worksheet Selection in Excel

If you have several worksheets in an Excel workbook, it can be time consuming to select the one you want to view. This shortcut can help you speed up the process.

Right click on the sheet tab navigation arrows

	A menu of worksheet tabs pops up
	Left click the worksheet you want to view

This tip works in Excel 2007 as well as earlier versions.