Top 10 Excel Shortcut for formatting: In this article we will see the top 10 excel shortcut that is used in formatting, with the help of shortcut you can speed up the excel tasks… so let’s start..
ALT H O I
It will feel frustrating when you open the excel workbook but you can not see the data properly like content is hidden. Instead of manually adjusting the columns you need to try ALT H O I. ALT H O I automatically changes the column widths of the selected cells to match the size of their contents.
ALT H O A
As above we saw that column width adjusted according to the content size. Now we will learn how to adjust row Height. ALT H O A automatically changes the row Height of the selected cells to match the size of their contents.
When you are working in excel there are multiple columns but you want to hide them for time being you need to use CTRL 0. CTRL 0 hides the active column automatically. If you select multiple columns, CTRL 0 will automatically hide them all.
As above we learned to hide column now we will learn how to hide row, to hide row press CTRL 9. CTRL 9 automatically hides the active row. If you select multiple rows, CTRL 9 will hide them all.
ALT W V G
Suppose you are working in excel that consists of gridlines and you want gridlines only in your table just press 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.
CTRL SHIFT + OR =
Select the entire row /column and press CTRL SHIFT +/=. CTRL SHIFT +/= automatically inserts a new row/column.
CTRL SPACEBAR or SHIFT SPACE BAR
We need to work quickly in excel to select row or column using keyboard not using mouse because it takes time so.
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
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
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
This shortcut make your life little bit easier. In excel while typing we can make spelling mistake to check that simply press F7.
If this article is useful please share with friends and family and also visit our YouTube channel: EduTaxTuber