10 Shortcuts About Excel Every Computer Owner Should Know

By -

You need to know all the tricks and shortcuts of any software to become proficient in it. Therefore, today, we have collected 10 great tips for you to improve your Microsoft Excel Skills.

1. Keyboard Shortcuts To Add Or Delete Comments 

Excel Tip Add Or Delete Columns

2.  Adjust Width For Or Multiple Columns

If you need to adjust the width of a column click on the column’s header, move cursor to the right side of the header and double click when it turns into a plus sign.

Excel Tip Adjust Width Of Columns

3. Automatically SUM() With ALT =

You can add an entire column or row by just clicking in the first empty cell in the column or row. Then enter ALT =  to add up the numbers in every cell above or sideways.

Excel Tip Automatic Sum

4. Copy A Pattern Of Numbers Or Date

Excel Tip Copy Numbers Or Date

5. Display Formulas with CTRL +  `

Excel Tip Display Formulas

6. Double Click Format Painter To Duplicate The Format In Other Cells

Excel Tip Double Click Format Painter

7. Quickly Jump To The First Or Last Cell Using Keyboard Shortcuts

Use ctrl + upward key to go to the first cell and ctrl + downward key to go the last cell.

Excel Tip Jump To Start Or End Of A Column

8.  Logic For Number Formatting Keyboard Shortcuts

Excel Tip Number Formatting Keyboard Shortcuts

Excel Tip Number Formatting Keyboard Shortcuts

9. Create Formula In The First Cell And Then Duplicate It Too The Rest 

Excel Tip Repeat A Formula To Multiple Cells

10. Tab Between Worksheets Keyboard Shortcuts

Excel Tip Tab Between Worksheets

➘ Share this Article on:

1 Comment to 10 Shortcuts About Excel Every Computer Owner Should Know

  1. I would like to thank for those very important post. Please I want a full lesson of engineering exel and it’s application.

Leave a Reply

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