UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Excel Keyboard Shortcuts

G
Gaurav C
20/11/2017 0 0

Our day to day work involves excel and to complete our work fast we should have adequate knowledge of keyboard shortcuts. I am going to give you simple but useful tip which will helps you to navigate excel and perform tasks much quicker without touching the mouse.

Use arrow keys in combination of Ctrl/Shift key to traverse your Excel sheet:

  • Ctrl + Down arrow: Data Region Down.
  • Ctrl + Up arrow: Data Region Up.
  • Ctrl + Right arrow: Data Region Right.
  • Ctrl + Left arrow: Data Region Right.

Use Shift key with the above combination to select the data e.g. Ctrl+Shift+Down arrow to select the data range from current cell to last filled cell of the data region.

Some more useful shortcuts:

  • Ctrl+ Space Bar: Selects the entire column.
  • Shift+ Space Bar: Selects the entire row.
  • Ctrl + PageUp: Previous sheet.
  • Ctrl + PageDown: Next sheet.
  • Ctrl + Home: Selects cell A1 of the active sheet.
  • Ctrl + 1: Opens Format Cell window.
  • Ctrl+Shift+1: Changes the cell format to Number.
  • Ctrl+Shift+2: Changes the cell format to Time.
  • Ctrl+Shift+3: Changes the cell format to Date.
  • Ctrl+Shift+4: Changes the cell format to Dollar.
  • Ctrl+Shift+5: Changes the cell format to Percentage.
  • Ctrl+Shift+6: Changes the cell format to Scientific.

And finally Ctrl + Z to undo what ever mess you have done the excel sheet while practicing these shortcuts.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

What Is SPSS Software (SPSS Data Analysis Tool) ?
SPSS is a Windows-based program that can be used to perform data entry and analysis and to create tables and graphs. SPSS is capable of handling large amounts of data and can perform all of the analyses...

R programming language
R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and...

Hidden Gems Of MS Excel - Track All Comments At Once OR Delete All Comments At Once
*this Article is about Comments in MS Excel, NOT NotesClick here to Learn difference between Comments and Notes You have added many Comments on a Worksheet.Now, You are unable to track All Comments....

Hidden Gems of MS Excel - Reapply Filter
Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Hidden Gems Of MS Excel - Auto Fill: Only Weekdays OR Only Months OR Only Years
Fill dates Automatically in worksheet cells. The 1st and 2nd Format are known by Most Excel Users, however, 3rd - 5th Formats are lesser known. 3rd format - Only Weekdays 4th format - Only Months* 5th...
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more