Excel Shortcut Keys for Intermediates

Excel Shortcut Keys for Intermediates

Excel Shortcut Keys for Intermediates to speed up your working more: –

With help of the previous article, we are now much familiar with Excel Shortcut keys. Now we will explain another 10 shortcut keys to speed up your working.

Please Note: – Your mind will take few days to store these all shortcuts, Firstly you will spend more time on using it after some time you will very fluent in it and then you will release these are easy to remember.

 

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

  1. Move and Rotate within the Selection
  2. Go to Next or Previous Worksheets
  3. Go to Next or Previous opened Workbooks
  4. Find Next and Previous match after using find option
  5. Create Chart and Embedded chat
  6. Change the format of value to number time, date, currency, and percentage
  7. Edit cell format, Bold, Italic, Underline and Strike-through Formats
  8. Auto-sum selected cells and select function.
  9. Insert Today Date and current Time
  10. Expand and collapse Ribbon and Activate access keys

 

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  - Excel Shortcut Keys for Intermediates
Mac Keys symbols

1. Shift and Rotate (Corner to Corner) within the Selection: –

Most of the people already knew it. But these are the very important excel shortcuts if you don’t Know then remember it first.

  • The shift Cursor Downward: – With this shortcut, we can select next below cell from active cell. This shortcut move within selection also. if you can move your cursor with arrow keys but if you want to shift within selection then you cannot do this with arrow keys because selected will be removed selection when you use an arrow.
  • The shift Cursor Upward: – with this shortcut, we can select next above cell from active cell. This shortcut move within selection also.
  • Rotate( Corner to Corner) within selection: – If you want to move within a selection from one corner to another then use this shortcut. It will rotate clockwise.
Command to   Window shortcut Mac Shortcut
Shift cursor Downward Enter Enter
Shift cursor upward Shift + Enter Shift + Enter
Rotate( Corner to Corner) Ctrl + . Ctrl + .

 

2. Go to Next or Previous Worksheets: –

  • Next worksheet: – Every workbook has the numbers of worksheets. So, if you want to move next worksheet within the workbook then use Ctrl + page down key(Windows) and Fn + ^ +Down arrow 150x150 - Excel Shortcut Keys for Intermediates (Mac).
  • Previous worksheet: – If you want to move to the previous worksheet within the workbook then use Ctrl + page up key(Windows) and Fn + ^ +up arrow - Excel Shortcut Keys for Intermediates (Mac).
Command to   Window shortcut Mac Shortcut
Go to Next worksheet Ctrl + Page down Key Fn + ^ + Down arrow 150x150 - Excel Shortcut Keys for Intermediates
Go to the Previous worksheet Ctrl + Page Up Key Fn + ^ + up arrow - Excel Shortcut Keys for Intermediates

 

3. Go to Next or Previous opened Workbooks: –

In most of the time we do our work within two or more workbooks together and then we need to move fast from one to another then we can use this following commands: –

  • Next workbook: – To move to next opened workbook then press Ctrl + Tab key (Windows) and Control key + Tab(Mac).
  • Previous workbook: – To move to previously opened workbook then press Ctrl + Shift + Tab key (Windows) and Control key + shift key + Tab (Mac).
Command to   Window shortcut Mac Shortcut
Go to Next Opened Workbook Ctrl + Tab Control key + Tab
Go to the Previous Opened Workbook Ctrl + Shift + Tab Control key + Shift key + Tab

 

4. Find Next and Previous match after using find option: –

If you to find next or previous matched value after using find option, you don’t need to repeat this all again just do this with following shortcut keys: –

  • Next Matched value: – Use shift +F4 to find next matched value.
  • Previous Matched value: – Use Ctrl + Shift +F4 to find previous matched value.
Command to   Window shortcut Mac Shortcut
Find to Next matched value Shift + F4 Control Key + G
Find to Previous matched value Ctrl + Shift + F4 Control Key + Shift Key + G

 

5. Create Chart and Embedded chart: –

If you want to create a chart of selected data or opened worksheet. then use the following Shortcuts key.

  • Create Chart: – Create a new chart in the new worksheet of selected data or whole data from the active worksheet.
  • Create an Embedded Chart: –Create new chart within the worksheet of selected data or whole data from the active worksheet.
Command to   Window shortcut Mac Shortcut
Create Chart F11 Fn + F11
Create an Embedded Chart Alt + F1 Fn + Option Key + F11

6. Change the format of value to number time, date, currency, and percentage: –

If you want to change the type of format of cell value then use the following Shortcuts key without using the mouse.

Command to   Window shortcut Mac Shortcut
value to Numbers Ctrl + Shift + ! Control Key + Shift Key + !
value to Time  Ctrl + Shift + @ Control Key + Shift Key + @
value to Date Ctrl + Shift + # Control Key + Shift Key + #
value to currency Ctrl + Shift + $ Control Key + Shift Key + $
value to percentage Ctrl + Shift + % Control Key + Shift Key + %

 

7. Edit cell format, Bold, Italic, Underline and Strike-through Formats: –

If you want to change the type of format of cell value then use the following Shortcuts key without using the mouse.

Command to   Window shortcut Mac Shortcut
Edit cell format Ctrl + 1 Command Key + 1
Bold Format- Apply and remove Ctrl + 2 

or Ctrl + b

Command Key + b
Italic Format- Apply and remove Ctrl + 3 

or Ctrl + i

Command Key + i
Underline Format- Apply and remove Ctrl + 4

or Ctrl + u

Command Key + u
Strike-through Format- Apply and remove Ctrl + 5 Command Key + Shift key + 5

 

8. Auto-sum selected cells and select function: –

  • Auto-sum of selected cells: – If you want to make a total of selected value then use this shortcuts after selecting your data in a column and you will get total of all value below the last selected cells.
  • Select the function from below shown suggestion: – When you are trying to using the function of excel then excel by default show you some suggestions like if you press sum after + or + then excel will show you the options like  sum, sumif, sumifs, sumproduct etc. you can select any one from them by using down or up arrow key when function if highlighted then press tab key.
Command to   Window shortcut Mac Shortcut
Auto-sum of selected cells Alt + = Command Key + 1
Select the function from below shown suggestion Tab Down arrow 150x150 - Excel Shortcut Keys for Intermediates + Tab

 

9. Insert Today Date and current Time: –

If you want to show the today date or current time use the following shortcuts. You did not need to use any function.

Command to   Window shortcut Mac Shortcut
Insert Today Date Ctrl+ ; Control Key + ;
Insert Current Time Ctrl+ Shit + : Control Key + + Shift key + :

 

10. Expand and collapse Ribbon and Activate access keys: –

  • Expand and collapse Ribbon: –If you want to show more rows on your worksheet or you don’t want to show ribbon and you can use this shortcut key to expand and collapse ribbon.
  • Activate access keys: – If you want to access all ribbon functions then use this key it will highlight all function with the alphabets and then press highlighted alphabet and you can select the function from ribbon without using a mouse.
Command to   Window shortcut Mac Shortcut
Expand and collapse Ribbon Ctrl+ F1 Command Key + option key + R
Activate access keys

(and then select by press highlighted font)

Alt N/A
Thanks for reading the topic of “Excel Shortcut Keys for Intermediates, please comment your feedback whatever you want. If you have any question please ask us by commenting.