By Neil Shorney, Director, Naturally Sales Ltd.
When you've created a formula, don't use the mouse to select another cell - depending on how you've created it, that can alter the formula you've just made. Instead, press Enter to move to the cell below, or Tab to move to the cell on the right. To move in the opposite direction, use Shift+Tab or Shift+Enter.
We look at this in more detail in Introduction to Microsoft Excel.
No comments:
Post a Comment