Suppose you're working in one corner of your Excel worksheet -- such as cell Q50 -- and you decide to see how things are going in another corner, like cell IV65536. Once you get all the way to that distant cell, you decide that everything looks okay, you don't want to change a thing, and you'd rather just go back where you came from. Guess that means lots of scrolling, right? Wrong. As long as you didn't click anything in the area you visited, you can return to your previous location with one keystroke:

Excel directs you back to the last cell you selected.

If you have a workbook with lots and lots of sheets in it, you may very well wish you could be as nimble as Jack in the "Jack be Nimble" rhyme. You don't have time to scroll through tab after tab; you've got places to be, and things to do! No matter how many worksheets there are in your workbook, jump nimbly and quickly to the worksheet of your choice by doing the following:

- Right-click on the Worksheet Tab Scroll Buttons

Note: The Scroll Buttons are the Arrow Buttons to the left of your Tabs -- in the lower left corner of the Excel Screen -- right above the word "Ready."

That Borders Button on the Formatting Toolbar sure is handy. Just click on the appropriate button and -- presto -- you've got borders around cells, just the way you want them. It's hard to imagine how this feature could be better. But imagine how much easier the button would be to use if you could move it right next to the ranges you're working on and not have to click on it every time you change border arrangements. Well, you don't have to imagine:

Now you can select the border patterns directly from the palette as you work. When you want to put the palette away, click on the white button in its top right corner.

You can enter mixed numbers and fractions into any Excel cell the same way you'd type them on a piece of paper.

If you don't type the zero first, Excel thinks you're typing a date, and automatically applies the date format -- so that 1/16 is converted to 16-Jan.

Excel formats your number as a fraction or as a mixed number. It actually calculates the decimal equivalent for you, as you can see by looking in the formula bar when the cell is active.

In Excel Version 2002, you can color-code sheet tabs for easier identification or grouping of related sheets. Here's how: