Excel tips on daily work

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

Categories:Excel Concepts