Ctrl + R: Fills the selected cells with the contents of the cell to the left. 14. Ctrl + S: Saves the active workbook.
Ctrl+D in Excel and Google Sheets
To fill the entire column with the contents of the upper cell, press Ctrl + Shift + Down to select all cells below, and then press Ctrl + D . Using the Ctrl + R shortcut will fill a row cell(s) instead of a column.
Ctrl+Alt+R or Alt+Ctrl+R is a keyboard shortcut to open the drop-down filter menu in Google Sheets.
Ctrl + Alt + F5
The Ctrl + Alt + F5 key opens the Refresh Data dialog box. This shortcut is useful when you need to refresh data from an external data source.
Just press Ctrl + Z keyboard shortcut once if you want to undo one last step only or press multiple times up to how many steps you want to reverse.
Ctrl+E is a keyboard shortcut that centers the contents of a selected cell. This shortcut is particularly useful when you're working with large amounts of data and need to quickly format cells to make them more readable.
Excel – Use CTRL-D to duplicate the data from the cell above you have selected. You can highlight multiple cells to fill them all too!
After years of refusing to support this specific Ctrl + Shift + V shortcut, Microsoft is finally allowing users to paste text without the source formatting by pressing those keys simultaneously on Windows (Cmd + Shift + V on macOS).
5. Ctrl + G - This shortcut will open the Go To dialog box. This can be used to quickly find and select specific data in your worksheet. For example, if you know the cell address of the data that you want to find, you can use this shortcut to go directly to that cell.
Ctrl+K Insert a hyperlink. Ctrl+L Aligns the line or selected text to the left of the screen. Ctrl+M Indent the paragraph. Ctrl+N Opens new, blank document window.
In Microsoft Excel and other spreadsheet programs, pressing Ctrl + V will paste anything stored in the clipboard into the currently-selected cell. If you've copied more than one cell, Ctrl + V will paste them starting from your current position.
The F1 through F12 FUNCTION keys have special alternate commands. These keys are called enhanced function keys. Enhanced function keys provide quick access to frequently used commands that can increase your productivity. These commands are typically printed above or on the keys.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. Ctrl+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.
Press the Alt key and the = (equals sign) key on your keyboard simultaneously. This will add the SUM function to the selected cell, and automatically select the adjacent cells to use in the sum function.
Ctrl+N. Opens a new tab. Ctrl+T. Opens a new window in incognito mode.
Ctrl + P. Print a picture. Ctrl + R. Show or hide the ruler.
In all major Internet browsers (e.g., Chrome, Edge, Firefox), pressing Ctrl + Shift + B toggles the bookmarks bar between hidden and shown. With the Opera browser, this shortcut opens bookmarks.