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.

Alt+H+B+A

Before all borders
After all borders
 

Leave a Reply

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

Post comment