Top 10

Shortcut

1. ALT H O I

ALT H O I automatically changes the column widths of the selected cells to match the size of their contents

2. ALT H O A

ALT H O A automatically changes the row Height of the selected cells to match the size of their contents.

3. CTRL 0

CTRL 0 hides the active column automatically. If you select multiple columns, CTRL 0 will automatically hide them all

4.CTRL 9

CTRL 9 automatically hides the active row

5.ALT W V G

The active worksheet’s gridlines are entirely removed by pressing ALT W VG. Gridlines can be added back by pressing ALT W VG once more if necessary

6.CTRL SHIFT + OR =

Select the entire row /column and press CTRL SHIFT +/=. CTRL SHIFT +/= automatically inserts a new row/column.

7. CTRL SPACEBAR or SHIFT SPACE BAR

To select Column press CTRL SPACEBAR – (Key tip to remember this as C start with column and also CTRL) To select row press SHIFT SPACEBAR

8.ALT H B A

In excel we make table every often but to speed up the process of adding all borders in one go use ALT H B A, It applies all borders to the selected area in the excel

9.ALT H O R

In excel to quickly rename your sheet simply press ALT H O R, It quickly blink the cursor on the sheet just you need to type new name and enter

10. F7

In excel to quickly rename your sheet simply press ALT H O R, It quickly blink the cursor on the sheet just you need to type new name and enter