Just like this gentleman, I too use some unusual shortcuts but largely in Excel ūüėܬ†

Unusual Shortcuts 1

Late take a look at some that stay on top of my mind

1. Changing Row Height

A quick shortcut for changing row height is ALT H O H it leads you to the row height box where you specify the height you want

 

2. Changing Column Width

ALT H O W leads you to the width box. A similar and faster alternative from excel 2003 which still works in all versions is ALT O C W

 

3. Clearing Gridlines

ALT W V G it works like a toggle, doing it once will take off the grids and repeating it will get you back the grids

 

4. Inserting a Text Box

Sometimes you need to insert a Text Box in the spreadsheet. Just use the shortcut ALT N X which will change the cursor and let you draw the text box. If you are a heavy PowerPoint user you would love using it in PowerPoint too

 

5. Changing Font & Size

  • ALT H F S changes the font size
  • ALT H F F¬†leads you to the Font Names Drop Down

 

6. Merge Cells

ALT H M C merges the cells

 

7. Wrap Text

ALT H W wraps the text in the cell

 

8. Protect Sheet

ALT R P S it opens the protect sheet dialogue box

 

How ALT based shortcuts work

Shortcuts that begin with the ALT key mostly lead you to the ribbon menu, so you don’t need to hold all the keys together (unlike CTRL based shortcuts). For example if you wish to change the row width¬†with ALT H O W, you can press these keys one after the other without holding them together. Some ALT based shortcuts could be a bit longer and could make you look like a retard should you choose to press the shortcuts keys together ūüėÜ

 

Learn more about Shortcuts

  1. CLT ALT and SHIFT shortcuts in PowerPoint
  2. 12 Powerful PowerPoint Shortcuts
  3. 25 Top Excel Shortcuts you should not miss

 

PS: Why I was away for all this while

I recently launched a new training program on Business Intelligence Dashboards using Excel. Since I mismanaged my time, I had to do a lot of pilled up work in the last few days. Anyways the training went extremely well and I am all geared up to replicate it at many other places. See ya later, Take Care



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI