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

SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

Microsoft Word
Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft Word is a component of the Microsoft Office suite of productivity software, but can also be purchased as a stand-alone...

Important points to keep in mind while trade
? Do not over trade – Do not put all your money in share market. ? Do Not put all your money in single share or single sector – Put or divide your money in multiple shares or sectors. This...

How To Create Cutom List And Its Advantages?
You must have observed when you are typing Month names, Excel suggests the next Month Name. Also, you can drag the cursor using the anchor at the right bottom of cell and the series of month...

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...
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