Navigate through your selected range by changing the active cell (Excel 2000/2002/2003/2004/2007)
You may already know about a few handy shortcut keys that take you to the beginning and end of your worksheet’s data. Pressing [Ctrl][Home] takes you to cell A1 and pressing [Ctrl][End] takes you to the end of your worksheet’s data. However, what if you select a large range spanning more than one screen, and you’d like to navigate through it? It may not necessarily include the beginning or end of your data, so the shortcut keys we mentioned earlier aren’t efficient.
Fortunately, you can navigate through a selected range by changing the active cell (the cell where you started the selected range). Since Excel takes you to the active cell, you can use this to move quickly through a selected range of data. To change the active cell, select a range of cells and then press [Ctrl][+][.]. Excel jumps to the next clockwise corner of your selected range. Press the same key combination to cycleThrough each corner of your selected range.
You can also use a [Shift][arrow key] combination to expand or contract the selected range from the range’s origin (which is also the active cell). It’s navigation with an extra perk.
Four ways to quickly access_the Go To dialog box (Word 2000/2002/2003/2004/2007)
The Go To dialog box allows you to immediately move to any page, section, line, bookmark, comment, footnote, endnote, field_, table, graphic, equation, object, or heading in your document. You can use any of the following four methods to access_this dialog box:
Menu bar. Select Edit | Go To from the menu bar. (In Word 2007, display the Home tab and click the arrow next to Find, located in the Editing area, and then select Go To.)
- Keyboard shortcut. There’s even a handy keyboard shortcut you can use to access_this dialog box: [Ctrl]G ([command]G in 2004).
- Select BrowseObject. Click the Select BrowseObject button SELECTBROWSE (located at the bottom of Word’s vertical scroll bar) and select Go To.
- Status bar. Double-click in the left side of the status bar at the bottom of your document.
Thanks & Regards
============================
Mohammed Rahman Mecheri
System Analyst – Network & Infrastructure
Kamal Osman Jamjoom Group LLC.
Unit #422, Sultan Business Centre
P.O Box 27844, Dubai, UAE
Tel: +971 (4) 3355232 Extn: 1339
Fax: +971 (4) 3355231
Mobile: +971 (50) 9774048
Email: mrahman.koj@gmail.com
Web : https://about.me/mrahman
============================
Comments
Post a Comment
Please write your comment