Jiehao.net

Skip From Cell to Cell Using the Tab Button

"You may have a spreadsheet set up with a number of data input cells.

Wouldn't it be nice if the user could just press the Tab key to jump to the next input cell?

This type of thing is fairly easy to set up.

The key is to unlock the input cells, and then protect the worksheet.

Here's how to do it:

1. Select all of the input cells on your worksheet. (To select non-adjacent cells, hold down Ctrl while you select the cells.)

2. Select Format Cells to display the Format Cells dialog box.

3. Click the Protection tab and remove the check mark from the Locked check box.

4. Click OK." "When the sheet is protected, you'll find pressing Tab moves the heavy-bordered active cell indicator to the next unlocked cell.

Be aware that this does not prevent the user from selecting unlocked cells using the cursor keys--unless you're using Excel 2002 and you removed the check mark from 'Select locked cells' as described above."

http://pcworld.about.com/news/Oct112002id105312.htm

  1) Enter the characters "m2" into the cell.

2) Select the numeral "2" by itself.

3) On the menu bar, go to Format/Cells.

An abbreviated version of the dialog box shows up, with only the Font tab.

4) Under Effects, turn on Superscript. Click OK.

5) Press Enter to place the entry in the cell.

 Inserting Formulas Without the Zeros

=IF(SUM(A4:A4)>=1,SUM(A4:A4)

Comments (0)

Subscribe to this comment's feed

Name

Email

Website

Title

Comment

Add Comment