Excel tips on daily work

Last modified date

Some of the excel shortcuts we will use on a daily basis.

Autofit columns

Note: For Alt functions, we should enter keys one after not all together.

Select the cells for which you want to apply the autofit columns.

Alt + H +O +I

Before autofit columns
After autofit columns

To border all the cells which have data.

Select the cells for which you want to apply borders.


Before all borders
After all borders

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment