Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 53
15 February 2004

Start each week with a free tip

To subscribe, please type your email address in the box below:

Quickly add to the end of cell contents (Microsoft Excel)

You can, as you probably know, edit a cell entry by selecting the entry and simply typing the new information. Alternatively, you can edit the text in the formula bar. However,

Did you know ...

You can quickly edit cells in Excel without using your mouse.

Here's how:

  1. Select the cell that contains the text or formula you want to edit. (If you use your arrow keys you don't even have to use your mouse for this step.)
  2. Press F2. Edit mode is activated and the insertion point appears to the right of the last character.
  3. Edit the cell contents and press either [ENTER] or one of the [ARROW] keys to enter the change.

This tip is particularly useful when editing hyperlinks in Excel. If you use your mouse to click on a cell with a hyperlink it automatically opens your web browser. Using your keyboard, however, lets you edit hyperlinks with ease.

Until next week.

Email this page to a friend

Enter recipient's email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
February 2004