SARTAINĭ14 has no data, but it’s formatted for a date therefore, the matrix range is extended through G14. If, however, you’ve formatted your cells outside of the original matrix or have anything (even a space or a comma) in any cell outside the matrix range, Ctrl+End will move to the cell at the end of the last column and row that contains any data or formatting. Regardless of the current cursor position, when you press Ctrl+End, the cursor moves to the last, bottom, right cell of the matrix-in this case, G11. (Note: End-Down Arrow is a combination keystroke executed in sequence, not a simultaneous keystroke like Ctrl+End).Ĭonsider a grid of data that occupies cells A1 thru G11.
#MAC EXCEL FIND AND REPLACE SHORTCUT FULL#
The same rule applies horizontally: If an entire row is full of blank cells, your cursor is located at A1, and you select End-Right Arrow, the cursor moves to column XFD, row 1.
For example, if the cursor is in A1 and the entire column contains empty cells, End-Down Arrow moves the cursor to the bottom of the entire workbook.
#MAC EXCEL FIND AND REPLACE SHORTCUT PLUS#
Shift-End+Down Arrow extends the highlight to the next line, and you can keep pressing Down Arrow to extend the highlight line by line. Shift-Home+Up Arrow does the same in reverse, going to the beginning of the line and up.Įnd plus any arrow key moves the cursor to the last occupied cell in a column or row of data just before a blank, empty cell. In Word, Shift-End highlights from the cursor position to the end of the line, and Shift-Home highlights to the beginning of the line. (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. 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. 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)
