Workbook Shortcut Keys

  • To create a new workbook. Ctrl + N.
  • To open an existing workbook. Ctrl + O.
  • To save a workbook/spreadsheet. Ctrl + S.
  • To close the current workbook. Ctrl + W.
  • To close Excel. Ctrl + F4.
  • To move to the next sheet. Ctrl + PageDown.
  • To move to the previous sheet. Ctrl + PageUp.
  • To go to the Data tab. Alt + A.

What are the 20 shortcut keys?

Basic Windows keyboard shortcuts

  • Ctrl+W: Close.
  • Ctrl+A: Select all.
  • Alt+Tab: Switch apps.
  • Alt+F4: Close apps.
  • Win+D: Show or hide the desktop.
  • Win+left arrow or Win+right arrow: Snap windows.
  • Win+Tab: Open the Task view.
  • Tab and Shift+Tab: Move backward and forward through options.

What is the function of CTRL A to Z in Excel?

Ctrl + A → Select all content. Ctrl + Z → Undo an action. Ctrl + Y → Redo an action.

How many shortcut keys are there in Excel?

222 Excel shortcuts for Windows and Mac.

What are the 25 shortcut keys?

They are key in moving through your work quickly and easily.

  • Ctrl+Z : Undo. ...
  • Ctrl + A : Select All. ...
  • Ctrl + C : Copy. ...
  • Ctrl + V : Paste. ...
  • Ctrl + X : Cut. ...
  • Alt + Tab : Switch Screen/Tabs. ...
  • Ctrl + Alt + Del : Start Task Manager. ...
  • Alt + F4 : Close App.

Excel Shortcut Keys | Full Guide

What are the 100 shortcut keys?

File Explorer Shortcuts

  • Alt + D – Select the address bar.
  • Ctrl + E – Select the search bar.
  • Ctrl + N – Open new window.
  • Ctrl + W – Close selected window.
  • Ctrl + Mouse Scroll Wheel – Change size and look of file and folder icons/thumbnails.
  • Ctrl + Shift + E – Show all the folders about the highlighted folder.

What is function of F1 to f12 keys in Excel?

F1 – Opens the Help screen for almost every program. F2 – Allows you to rename a selected file or folder. F3 – Opens a search feature for an application that is active at the moment. F4 – Alt + F4 closes the active window.

What is Ctrl R in Excel?

Ctrl+R in Excel and other spreadsheet programs

In Microsoft Excel and other spreadsheet programs, pressing Ctrl + R fills the row cell(s) to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl + Shift + Right arrow to select additional ones.

What are the 10 shortcut keys?

Below are the top 10 keyboard shortcuts we recommend everyone memorize and use.

  • Ctrl+C or Ctrl+Insert and Ctrl+X. Both Ctrl + C and Ctrl + Insert will copy highlighted text or a selected item. ...
  • Ctrl+V or Shift+Insert. ...
  • Ctrl+Z and Ctrl+Y. ...
  • Ctrl+F and Ctrl+G. ...
  • Alt+Tab or Ctrl+Tab. ...
  • Ctrl+S. ...
  • Ctrl+Home or Ctrl+End. ...
  • Ctrl+P.

What is Ctrl M in Excel?

When used in the Microsoft Windows calculator, pressing Ctrl + M stores the current calculator value in memory. This keyboard shortcut is the same as pressing the MS button.

What is Ctrl N in Excel?

In Microsoft Excel and most other spreadsheet programs, pressing Ctrl + N creates a new blank worksheet.

What are 30 shortcut keys?

Word shortcut keys

  • Ctrl + A -- Select all contents of the page.
  • Ctrl + B -- Bold highlighted selection.
  • Ctrl + C -- Copy selected text.
  • Ctrl + X -- Cut selected text.
  • Ctrl + N -- Open new/blank document.
  • Ctrl + O -- Open options.
  • Ctrl + P -- Open the print window.
  • Ctrl + F -- Open find box.

What is Ctrl G in Excel?

Ctrl+G in Excel and other spreadsheet programs

In Microsoft Excel and most other spreadsheet programs, pressing Ctrl + G opens the Go To window that allows you to focus a specific reference (cell). For example, you could press Ctrl + G , type n8, and press Enter to move to the N8 cell.

What is Ctrl Q?

In Microsoft Word, Ctrl + Q removes all formatting from a highlighted paragraph.

What is Ctrl F?

Ctrl-F is the shortcut in your browser or operating system that allows you to find words or phrases quickly. You can use it browsing a website, in a Word or Google document, even in a PDF. You can also select Find under the Edit menu of your browser or app.

What is F8 in Excel?

F8 Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. Shift+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.

What is F9 Excel?

Once highlighted, pressing the F9 key calculates the highlighted portion and simply displays its value or result. This can be helpful for understanding how complex formulas are working, debugging why complex formulas are not working as expected, or for determining the source positioning of any error value.

What is F2 function in Excel?

Everybody (well, almost everybody) knows that pressing the F2 key in Excel activates the “editing” mode for the active cell – the cursor goes into the cell so that you can change the contents and the various cell references in that formula turn different colours.

How many shortcut keys are there?

199 keyboard shortcuts of a computer. List of computer shortcut keys for major applications.

What is the Ctrl D?

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! Video Player.

What are shortcut keys in computer?

A keyboard key that invokes a function in the operating system or application when pressed. Shortcut keys, which may involve pressing two or three keys at the same time, are set up for common tasks such as launching a favorite program.