(Note: End-Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like Ctrl+Arrow).
Ctrl+Page Up and Ctrl+Page Down move through the tabs (additional inserted worksheets) one at a time: Page Up for left-to-right, and Page Down for right-to-left. In Excel, Ctrl+Arrow key performs the same function as the End-Arrow keys. Ctrl+Page Down and Ctrl+Page Up move the cursor up and down one page at a time. Ctrl+Up Arrow does the same from bottom to top. Ctrl+Down Arrow moves the cursor down one carriage return/line break at a time. Ctrl+Left Arrow does the same from right to left. In Word, Ctrl+Right Arrow moves the cursor across the document one word and/or punctuation mark at a time. It also moves the cursor to the beginning of a line or formula inside a cell while in Edit Mode. Ctrl+Home moves the cursor to cell A1. In Excel, Home moves the cursor at the current cell address (e.g., K19) to the beginning of that line or row. For example, if your cursor is on the ninth word of the third line, Home moves the cursor to the beginning of that line. Ctrl+Home moves the cursor to the Home position-that is, the beginning of the document. In Word, Home moves the cursor to the beginning of the line or row of your cursor’s current location.
#Keystrokes to undo full#
The GoTo feature can take you to a specific cell address or specific page. Click to view full image. For the Ribbon commands, it’s Alt+H-F-D-G (Home, Find, GoTo). It’s Ctrl+G or F5, followed by a dialog box that opens for additional input-the same dialog boxes as the Ribbon shortcuts. The only Navigation command on the Ribbon menu is the GoTo feature, which means go to a specific cell address (formula, object, region, etc.) or go to a specific page (section, line, graphic, etc.). These keyboard shortcuts make it easier to get where you need to go. The bigger your document or spreadsheet is, the harder it is to move within it.
#Keystrokes to undo plus#
You save constantly (or you should), which is why you’ll want to use these ribbon shortcuts for Save and Save As, plus Print and Print Preview. The Ribbon version is Alt+F-P for both File, Print and Print Preview, because when you select Print, the Preview displays as well. For Print, it’s Ctrl+P or Ctrl+Shift-F12. Print is simple, but many users go straight to Print Preview as a final sanity check on margins and layout.
0 kommentar(er)
