Moving Around in a Workbook: MS Excel
When you begin a new workbook, the "active cell" is located at the top-left corner of the worksheet (in Cell A1). To create your worksheet or make changes to it, you must move around in it.
Getting around in a worksheet quickly is the mark of an experienced Excel user. You want to learn the quickest way to get from place to place so you can use your time more efficiently.
Keyboard Shortcuts for Moving Around in a Worksheet
You can move around in the worksheet by pressing the arrow keys and other direction keys on the keyboard. When you use the keyboard to move around in the worksheet, you move the location of the active cell. You then begin adding or editing the contents of the active cell.
- Left arrow: One cell to the left
- Right arrow: One cell to the right
- Up arrow: Up one row
- Down arrow: Down one row
- Home: The cell in column A of the current row
- Page Up: Up one screen Page Down Down one screen
- Ctrl+Home: Cell A1
- Ctrl+End: The cell at the intersection of the right-most column and the bottom-most used row (the lower-right corner of your work area)
- Ctrl+arrow key: Jump to the end of a series of blank or nonblank cells in a given direction
Use the Scroll Bar
You can also use the mouse to click or drag the scroll bars to view different parts of a worksheet. If your mouse has a wheel button, you can also use it to scroll through the document. Rotate away from you to scroll up; rotate toward you to scroll down.
The difference between using the keyboard and the scroll bars is that when you use the keyboard, you are moving the active cell. On the other hand, using the mouse to scroll up or down in the worksheet merely changes the view. You must click the mouse in the worksheet to move the active cell.
Moving to a Specific Cell
To jump directly to a specific cell, click the Name box on the left side of the formula bar, and type the cell address (that is, its column letter and row number, such as A1 or B6) and press Enter.
As soon as you press Enter, the Excel screen displays that cell (and the ones near it) and makes it the active cell.
Moving to Other Worksheets
Workbooks typically contain three worksheets (although you can easily add or delete sheets which I'll cover in another article). To use or view a different worksheet, click the tab on the bottom of the worksheet. The tabs are labeled Sheet1, Sheet2, and Sheet3 until you rename them.
When you click on a worksheet's tab, the sheet is displayed so you can work on it.
Visit Carol's web site to learn more tips like this one!
Free guide: Windows 8 Cheat Sheet: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. Share and enjoy! Click here to download this guide now! Note: this guide is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.