![]() ![]() Page Down Moves the viewable rows down one screen.Īlt+Page Up Moves the viewable columns one screen to the left. Page Up Moves the viewable rows up one screen. In the page preview it moves to the next print page. In the page preview it moves to the previous print page.Ĭtrl+Page Down Moves one sheet to the right. If the row below the cell that contains the cursor is empty Ctrl+Shft+Arrow Selects all cells containing data from the current cell to the end of the continuous range of data cells Ctrl+ Page Up Moves one sheet to the left. If the row above the cell that contains the cursor is empty Ctrl+Down Arrow Moves the cursor to the bottom edge of the current data range. ![]() If the column to the right of the cell that contains the cursor is empty Ctrl+Up Arrow Moves the cursor to the top edge of the current data range. ![]() What is the keyboard shortcut for 'repeat last action' in Excel on a Mac? What is the equivalent of Excel on a Mac? Excel Shortcut: F4-Repeat Previous Action. If the column to the left of the cell that contains the cursor is empty Ctrl+Right Arrow Moves the cursor to the right edge of the current data range. Ctrl+Left Arrow Moves the cursor to the left edge of the current data range. End Moves the cursor to the last cell of the current row in a column containing data. Home Moves the cursor to the first cell of the current row. Ctrl+End Moves the cursor to the last cell on the sheet that contains data. List of navigation and selection shortcut keys Shortcut Command Ctrl+Home Moves the cursor to the first cell in the sheet (A1). Below are some additional shortcut keys that are useful in Calc.įunction Excel Shortcut Calc Shortcut Rearranges the relative or absolute references (for example, A1, $A$1, $A1, A$1) in the input field F4 Shift+F4 Edit cell comment (known as “notes” in Calc) Shift+F2 Control+F1 Fill right or Fill down Control+R or Control+D No equivalent Go to specific cell F5 F5 (shows Navigator) Insert Function No standard equivalent Control+F2 Enter into all currently selected cells Control+Enter Alt+Enter Alt+Shift+Enter (also applies the cell format) In both cases cells must be contiguous. Here are some selected Excel and Calc default keyboard shortcuts – and the difference in accessing the related functions. A great deal of people using spreadsheets love using keyboard shortcuts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |