UrbanPro
true
default_background

Learn Microsoft Excel Training from the Best Tutors

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

Excel Keyboard Shortcuts

Profile Photo Gaurav C
20/11/2017 0 View Comments0

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 Loading Spinner
Default Profile Photo

Please Enter a comment

Submit

Other Lessons for You

Beware Of Trainers Of Data Science.
Most of the trainers in the market are teaching DATA SCIENCE as 1) Some software tools like R/Python/SAS/Hadoop etc 2)They are spending less amount of time on Mathematics and Statistics(Mostly 10 hrs...
Profile Photo

What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...
Profile Photo

Hidden Gems of MS Excel - New Window
You are working on 2 Worksheets in Same Workbook. To complete Your task, You have to frequently navigate between the Worksheets.Understandably, to frequently navigate between the Worksheets is inconvenient,...
Profile Photo

What is a VBA Module?
VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...
Profile Photo

SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...
Profile Photo
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