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