Force Byte - Moving around the Excel
worksheet with keyboard

0 Photo

You must select a cell or a group of cells before you can work with them in Excel. When you select a single cell, it becomes active. Although only one cell can be active at one time, you can often speed up operations by selecting groups of cells called ranges. You can move among the cells in a selected range but not those outside the range without first changing your range selection.

You may think that it is impossible to move around the Excel worksheet without a mouse. Not quite. You can move around very easily by using the keyboard to select cells.

To select a single cell, use the arrow keys. For example, if cell A1 is currently selected, press the <> key once to select cell A2. Or press the <> or <> key to select the cell on either side of the active cell.

You can also use the and keys alone and in conjunction with other keys to make selections and move around a worksheet. The following table shows you what they include and can achieve:

Press	To
<Home>	Move to the first cell in the current row
<End>	Activate the End mode. Then use the arrow keys to move between edges of cell regions, which are ranges of cell entries bounded by blank cells or column and row headings. To turn off the End mode, press <End> again
<Ctrl>+<Home>	Move to cell A1
<Ctrl>+<End>	Move to the last cell in the last column in the active area, which is a rectangle encompassing all the rows and columns in a worksheet that contain entries
<Scroll Lock>+<Home>	Move to the first complete cell (i.e. full cell in appearance) in the current window, which is the area of the worksheet currently displayed on the screen
<Scroll Lock>+<End>	Move to the last complete cell in the current window

I will talk about how to use the "Go To" command in Excel next time. It is a very useful function for moving around the worksheet. See you soon!

"Sharing IT as it applies to your daily life"