Hints and Tips

Excel Data Entry

When you finish typing a formula, it is usual to press the Enter key. This causes the active cell to move to the cell below. You can change this permanently by choosing Tools, Options, Edit, Move selection after Enter. You can also change this 'on the fly'. Try Ctrl+Enter to stay where you are or Shift+Enter to move up one cell. You can even use Alt+Enter to start a new line in the same cell for text entries (turning on text wrap in the process).

If you need to type a lot of data into a rectangular block of cells, you can highlight the block first. Now the Enter key will always stay within the block, moving up to the top of the next column after it reaches the bottom of the selection. You can also use Tab to move to the right first and then down (or Shift+Tab to go left and then up).

Contact Us   |    Privacy   |    Access and Equity   |    Links