Excel Workbook Shortcuts

 

Excel Workbook Shortcuts

Workbook elated shortcuts deal with the workbooks of the Excel Files. It includes toggling between the worksheets, print preview, minimize, maximize, etc. All list of Workbook related shortcuts are as follows:

• Shift + F11 - Inserts a new worksheet
• Ctrl + PgDn - Next Worksheet
• Ctrl + PgUp - Previous Worksheet
  
• Ctrl + Tab - Go to next Workbook
• F6 - It lets you move to next Pane
• Shift F6 - It makes you move to the previous pane
• Ctrl + Shift + Tab - Previous Workbook
• Ctrl + F9 - Minimize
• Ctrl + F10 - Maximize
• Shift + Click - Select Adjacent Worksheets
• Ctrl + Click - Select non-adjacent Worksheets
• Ctrl + Shift + F1 - Full Screen Toggle
• Tab - Move to next control
• Shift + Tab - Move to the previous control
• Ctrl + Tab - Move to next Tab
• Ctrl + Shift + tab - Move to Previous Tab

File Shortcuts

File related shortcuts generally deal with the shortcuts related to workbooks of Excel. All the workbook or file related shortcuts are as follows:

• Ctrl + N - New Workbook
• Ctrl + O - Open Workbook
• Ctrl + S - Save Workbook
• F12 - Save As
• Ctrl + P - Print File
• Ctrl + F2 - Open Print Preview
• Ctrl + F4 - Close Workbook
• Alt + F4 - Close Excel
• Ctrl + F1 - Expand or close Ribbon
• Alt - Activate Access Keys
• Tab - Move to next control on Ribbon
• F1 - Help

Generalized Shortcuts

Let's take a look at some generalized MS Excel Shortcuts for manipulating Excel Workbooks. All the Generalized MS Excel Shortcut Keys are as follows:

• Ctrl + W: Close a Workbook
• F4 - Repeat Last Command Actions
• Alt + F + T - Open Options
• F1 - Open Help
• Ctrl + Z - Undo
• Ctrl + Y - Redo
• Ctrl + C - Copy
• Ctrl + X - Cut
• Ctrl + V - Paste
• Ctrl + Alt + V - Display Paste Special Dialogue Box
• Ctrl + F - Find Box
• Ctrl + H - Find and Replace
• Shift + F4 - Find next match
• Ctrl + Shift + F4 - Find Previous Match
• Alt + F1 - Create an Embedded Chart
• F11 - Create Chart in new Worksheet

Navigation Excel Shortcuts

Navigation-related shortcuts are the shortcuts that help in moving through the sheet or workbook easily. All the navigation-related shortcuts are as follows:

• → - Cell Right
• ← - Cell left
• ↑ - Cell Up
• ↓ - Cell down
• Alt + PgDn - Move one screen down
• Alt + PgUp - Move one screen left
• PgUp - Screen Up
• PgDn - Screen Down
• Ctrl + → - Right Edge of Data
• Ctrl + ← - Left Edge of Data
• Ctrl + ↑ - Top Edge of Data
• Ctrl + ↓ - Bottom Edge of Data
• Home - Beginning of Row

Excel Shortcuts insert a row:

1. Press Alt-4, it will insert the initial row.
2. Press F4/Ctrl-Y and Repeat.
3. Hold down the Shift Key, drag, and select Multiple Rows.
4. Press Alt-4, insert as many rows you want

Excel shortcut for SUM:

1. Keep the Cursor below or to the left of the columns that you wish to SUM
2. Hold the Alt Key. Press equals ‘=’ sign. Do not leave Alt Key while doing so.
3. Press Enter

Turn Filters On or Off shortcuts

1. Ctrl+Shift+L is the keyboard shortcut to turn the filters on/off.

Next worksheet / Previous worksheet shortcuts

1.  Control + PgDn to move to the next worksheet to the right
2. Control + PgUp to move to the worksheet to the left

Move to the edge of excel sheets shortcuts

1. Move Extreme right = Control + Right arrow
2. Move Extreme left = Control + Left arrow
3. Move Extreme up = Control + Up arrow
4. Move Extreme down = Control + Down arrow

To insert Time in Excel, follow the steps:

• Select the Tab in which you wish to insert the time
• Press Ctrl + Shift + ; (semicolon)
• The current time will be inserted

2. How to put the date in the excel shortcut?

To insert Date in Excel, follow the steps:

• Select the Tab in which you wish to insert the date
• Press Ctrl + ; (semicolon)
• The current date will be inserted