Most people are not aware of the Data Analysis ToolPak in Excel. This feature is
disabled by default. To use the Data Analysis ToolPak you need to be familiar
with Engineering and Statistical terminology. To enable it:
 |
Click the File tab (2010) or Office Button (2007) |
|
|
Click the Options button at the bottom of the menu |
|
|
Click Add-Ins in the left pane |
|
|
Click Go |
|
|
Select Analysis ToolPak |
|
|
Click OK |
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:
|
|
Unlocked the cells that can be changed and
|
|
|
Protected the worksheet
|
