Home Up Bookstore Site Map Site Search

Spreadsheet Files
Excel Function Keys ] Excel Shortcut Keys ] New Excel Tips ] Working with Excel ] [ Spreadsheet Files ] Entering and Editing Data ] Selecting Data ] Formatting Worksheets ] Worksheet Functions ] Working with Charts ] Working with Graphics ] Special Features ] Printing ]


Working with Files

 

AutoSaving Your Workbook

 

Closing All Open Files

 

Closing a Workbook Window

 

Closing Multiple Workbook Files (Posted 09/23/2000)

 

Copying a Worksheet

 

Cycling through Open Workbook Files

 

Finding External Links

 

Opening Files and Workspaces at Start

 

Opening a File at Startup

 

Performing File Maintenance from the Open Dialog Box (Posted 12/23/2000)

 

Protecting a Workbook from Accidental Changes

 

Protecting a Worksheet

 

Protecting Charts and Drawing Objects

 

Refreshing a Workbook

 

Saving a Workspace

 

Setting a Read-Only Recommendation

 

Setting a Password to Open a Workbook (Excel 2000)

 

Using the Keyboard to Manage Your Workbook Window

Navigating

 

Finding the Last Entry in a Column or Row

 

Jumping to an Empty Cell

 

Jumping to the Last Used Column (Posted 09/23/2000)

 

Navigating a Worksheet: Using Tab and Enter

 

Navigating Unconnected Cells and Ranges

 

Using the Name Box to Jump to a Cell

 

Using the Scroll Bars

 

Using Scroll Lock

 

Using the TAB Key to Navigate a Protected Worksheet (Posted 11/26/2000)

 

Using the Tab Scroll Buttons I: Scrolling Worksheet Tabs (Posted 09/23/2000)

 

Using the Tab Scroll Buttons II: Activating a Worksheet (Posted 09/23/2000)

 

Zooming to Fit a Selection

Moving between Worksheet Panes, Worksheets, and Workbooks

 

Displaying Different Worksheets Side by Side (Posted 09/23/2000)

 

Switching between Worksheets and Workbooks

Other

 

Changing the Standard Color Palette

 

Displaying Formulas

JavaScript courtesy The JavaScript Source

Go Back to the Top of the Page


Home ] Excel Function Keys ] Excel Shortcut Keys ] New Excel Tips ] Working with Excel ] [ Spreadsheet Files ] Entering and Editing Data ] Selecting Data ] Formatting Worksheets ] Worksheet Functions ] Working with Charts ] Working with Graphics ] Special Features ] Printing ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA