Moving Around In Excel (beginner)
If you're like me, you get tired of tapping the arrow keys to move around inside Windows applications and getting around in Excel is no exception. So I've posted a quick review of the various shortcuts for moving around in Excel and they are especially handy when you need to move long distances within a worksheet. Included is a list of my favorite keyboard commands, sure to get cheers from those proficient at typing. So here are some excellent ways to cut corners, jump fences, and even teleport to your desired locations quickly and easily.
Moving around with the mouse: To select an individual cell with the mouse, simply click on the desired cell. Use the scroll bar arrows on the right side and bottom of the workbook to view more of the worksheet before clicking on the desired cell. The selected cell's contents are shown in the formula bar at the top of the screen.
To move to another worksheet with in the workbook, simply click on the desired tab at the bottom of the screen.
Moving around with the keyboard: You might prefer using some of these handy keyboard commands for speedy movement around your worksheets.
Ctrl-Arrow key--To the beginning of the next range of data in the direction of the arrow
Enter--Down one cell
Shift-Enter--Up one Cell
PgUp--One screen up
PgDn--One screen down
Home--To the first cell of the current row
Ctrl-Home--To cell A1
Ctr-End--To the last used cell in the worksheet
Note: Remember to turn Num Lock Off to use these keys.
Moving with Goto: You can make large jumps around the worksheet using the Goto command in the Edit menu. Just select Edit-Goto, then enter the desired cell reference in the space provided. When you click OK, you will be moved directly to the specified cell. Excel remembers the last few jumps you make and presents them for your easy selection in the Goto dialog box. Just double-click on the one you want to repeat the jump.
Moving with Find: A final way to move to a specific location in an Excel worksheet is to have Excel find specific information. Just choose the Edit-Find command and type the information you want Excel to locate. This information should be data inside the spreadsheet, not cell references.
Moving around with the mouse: To select an individual cell with the mouse, simply click on the desired cell. Use the scroll bar arrows on the right side and bottom of the workbook to view more of the worksheet before clicking on the desired cell. The selected cell's contents are shown in the formula bar at the top of the screen.
To move to another worksheet with in the workbook, simply click on the desired tab at the bottom of the screen.
Moving around with the keyboard: You might prefer using some of these handy keyboard commands for speedy movement around your worksheets.
Ctrl-Arrow key--To the beginning of the next range of data in the direction of the arrow
Enter--Down one cell
Shift-Enter--Up one Cell
PgUp--One screen up
PgDn--One screen down
Home--To the first cell of the current row
Ctrl-Home--To cell A1
Ctr-End--To the last used cell in the worksheet
Note: Remember to turn Num Lock Off to use these keys.
Moving with Goto: You can make large jumps around the worksheet using the Goto command in the Edit menu. Just select Edit-Goto, then enter the desired cell reference in the space provided. When you click OK, you will be moved directly to the specified cell. Excel remembers the last few jumps you make and presents them for your easy selection in the Goto dialog box. Just double-click on the one you want to repeat the jump.
Moving with Find: A final way to move to a specific location in an Excel worksheet is to have Excel find specific information. Just choose the Edit-Find command and type the information you want Excel to locate. This information should be data inside the spreadsheet, not cell references.
posted by vanburen at
9:35 AM
0 Comments:
Post a Comment
<< Home