Open Site Navigation
Maveristic

Be Valuable, Not Available

© 2020-2021 by Maveristic 

Web Design & Development Company

Subscribe to Our Mailing List

Thanks for submitting!

Wix Icon Level Partner
View Our Ratings
Maveristic

Be Valuable, Not Available

Follow Us

  • LinkedIn
  • Facebook
  • YouTube
  • Instagram

Email Us:

support@maveristic.in

Contact Us:

+91-9821610806

  • Canute Fernandes

Helpful Excel Shortcuts

1. Add, Clear, and Remove Filter


To Add/Remove a filter:

  1. Alt+D+F+F

  2. Shift+Ctrl+L

To Clear Filter:

  1. Alt+A+C

2. Create a Table


Advantages of inserting converting a range to the table:

  1. Structured referencing

  2. Automatic formula

  3. Chart updates

How to convert a range to a table?

Select the data you need to convert and follow the below command or path.

  1. Alt+N+T

  2. Path: Insert — Table

How to convert your table back to the range?

Select the data you need to convert and follow the below command or path.

  1. Alt+JT+G

  2. Path: Design — Convert to Range

3. Move to the Edge of the data


How to move from one cell to another without the help of a mouse or scrolling?

  1. Ctrl+Arrow Keys – Up, Down, Left, and Right respectively

  2. To jump from start to end of a particular column or row

  3. Shift+Ctrl+Arrow Keys – Up, Down, Left, and Right respectively

  4. To select the data in the range

  5. Ctrl+Home

  6. To reach the 1st cell irrespective of where you are in the sheet

  7. Ctrl+End

  8. To reach the last cell irrespective of where you are in the sheet

4. Format Cells


How to format cells?

  1. Format Cell Command box – Ctrl+1

  2. Shortcut:

  3. Shift+Ctrl+1 – Accounting Format

  4. To remove decimal: Alt+H+0

  5. To add decimal: Alt+H+9

  6. Shift+Ctrl+2 – Time Format

  7. Shift+Ctrl+3 – Date Format