Advance Excel Shortcut Keys – Microsoft

Advance Excel Shortcut Keys

Advance Excel Shortcut Keys: –

The topic Advance Excel Shortcut Keys will be very easy to understand if you have learnt our previous articles of excel shortcuts (Excel Shortcut keys for beginner and Excel Shortcut keys for Intermediates)Now we will explain another 10 shortcut keys to speed up your working and this is the last group of shortcut key after learning that article you will be able to do you work very fluently.

Please Note: – Practice a lot. If you want to be very fluent then stop using the mouse and use this shortcut key while working in the excel.

The following 10 Advance Excel Shortcut Keys are covered under this articles: –

  1. Create New workbook, open and close workbook
  2. Move to Next or Previous in Ribbon Control
  3. Apply and Remove the filter, open filter option and select items
  4. Insert Table and Other Table Options
  5. Drag and Drop cell value and worksheet
  6. Select and show active cell within the selection
  7. Select direct and all precedents & Dependents
  8. Display “Go To” Dialog box, the cell with comment and visible cell only
  9. More option about editing active cell
  10. Editing active cell Value

 

Download the PDF file of all Excel shortcut keys from the Following link: –

 

The Following are the Key symbol of the Mac 

Mac Keys symbols  - Advance Excel Shortcut Keys - Microsoft
Mac Keys symbols

1. Create New workbook, open and close workbook : –

Command to   Window shortcut Mac Shortcut
Create New Workbook  Ctrl + N Command Key + N
Open already saved a workbook Ctrl + O Command Key + O
Close opened workbook  Ctrl + F4 Command Key + W
Close Excel Alt + F4 Command Key + Q

Advance Excel Shortcut Keys – No. 1

2. Move to Next or Previous in Ribbon Control: –

Command to   Window shortcut Mac Shortcut
Move to Next in Ribbon Control TAB TAB
Move to previous in Ribbon Control Shift + TAB Shift Key + TAB

Advance Excel Shortcut Keys – No. 2

3. Apply and Remove the filter, open filter option and select items: –

Command to   Window shortcut Mac Shortcut
Apply and Remove the Filter  Ctrl + Shift + L Command Key + Shift + F
Open Selected cell filter option  Alt + Down arrow 150x150 - Advance Excel Shortcut Keys - Microsoft Option Key + Down arrow 150x150 - Advance Excel Shortcut Keys - Microsoft
Select option or Checkbox within the filter options Space Key Space Key

Advance Excel Shortcut Keys – No. 3

4. Insert Table and Other Table Options: –

Command to   Window shortcut Mac Shortcut
Insert Table in the Selected cell Ctrl + T Control Key + T
Select Table Row  Shift + Space Key  Shift Key + Space Key
Select Table Column  Ctrl + Space Key  Ctrl + Space Key 
Insert “Total Row” in a table  Ctrl +  Shift + T Command Key + Shift Key + T

Advance Excel Shortcut Keys – No. 4

5. Drag and Drop cell value and Worksheet: –

Command to   Window shortcut Mac Shortcut
Drag and Cut cell value drag with mouse and drop where you want to paste drag with mouse and drop where you want to paste
Drag and Copy cell value Ctrl + Drag   Option Key + Drag
Drag and Insert cell value Shift + Drag   Shift Key + Drag
Drag and Insert Copy cell value Ctrl +  Shift + Drag Option Key + Shift Key +Drag
Drag and Cut worksheet drag with mouse and drop where you want to paste drag with mouse and drop where you want to paste
Drag and Create duplicate Worksheet  Ctrl + Drag   Option Key + Drag

Advance Excel Shortcut Keys – No. 5

6. Select and show active cell within the selection: –

Command to   Window shortcut Mac Shortcut
Select active cell Shift +  Backspace Shift key +  Delete
Show active cell Ctrl +  Backspace Command key +  Delete
Cancel selection  Esc Esc

Advance Excel Shortcut Keys – No. 6

7. Select direct and all precedents & Dependents : –

Command to   Window shortcut Mac Shortcut
Select Direct Precedent Ctrl +  [ Control key +  [
Select All Precedent Ctrl +  Shift + { Control key + Shift key +  {
Select Direct Dependent Ctrl +  ] Control key +  ]
Select All Dependent Ctrl +  Shift + } Control key + Shift key +  }

Advance Excel Shortcut Keys – No. 7

8. Display “Go To” Dialog box, the cell with comment and visible cell only: –

Command to   Window shortcut Mac Shortcut
Display “Go To” Dialog Box  Ctrl +  G Control key +  G
Select All cell with comments Ctrl +  Shift + O Control key + Shift key +  O
Select visible cell only  Alt + ; Command key + Shift Key + Z

Advance Excel Shortcut Keys – No. 8

9. More option about editing active cell: –

Command to   Window shortcut Mac Shortcut
Edit Active Cell F2 Control key +  U
Insert or Edit comments Shift + F2 Fn + Shift key +  F2
Start a new line in the same cell Alt + Enter Control key + Option Key + Return

Advance Excel Shortcut Keys – No. 9

10. Editing active cell Value: –

Command to   Window shortcut Mac Shortcut
Select one character Right within the active cell Shift + Right arrow - Advance Excel Shortcut Keys - Microsoft Shift key +  Right arrow - Advance Excel Shortcut Keys - Microsoft
Select one character Left within the active cell Shift + left arrow - Advance Excel Shortcut Keys - Microsoft Shift key + left arrow - Advance Excel Shortcut Keys - Microsoft
Select one word Left within the active cell Ctrl + Shift +Right arrow - Advance Excel Shortcut Keys - Microsoft Control key + Shift Key + Right arrow - Advance Excel Shortcut Keys - Microsoft
Select one word Right within the active cell Ctrl + Shift + left arrow - Advance Excel Shortcut Keys - Microsoft Control key + Shift Key + left arrow - Advance Excel Shortcut Keys - Microsoft
Only move one word from left to right Ctrl + Right arrow - Advance Excel Shortcut Keys - Microsoft Control key + Right arrow - Advance Excel Shortcut Keys - Microsoft
Only move one word from right to Left Ctrl + left arrow - Advance Excel Shortcut Keys - Microsoft Control key + left arrow - Advance Excel Shortcut Keys - Microsoft
Select from end to beginning  Shift + Home Fn + Shift Key + left arrow - Advance Excel Shortcut Keys - Microsoft
Select from beginning to end Shift + End Fn + Shift Key + Right arrow - Advance Excel Shortcut Keys - Microsoft

Advance Excel Shortcut Keys – No. 10

Thanks for reading the topic of “Advance Excel Shortcut Keys“.

Please comment your feedback whatever you want. If you have any question please ask us by commenting.