• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Learn how to navigate through your data quickly with keyboard shortcuts in Excel

By admin on April 25, 2018April 19, 2019

When working with large data lists in Excel, you may need to know the extent of the data, i.e. the number of rows and columns.  If consistency of the data is important too, then you may need to identify whether there’s any empty rows, columns or cells. An obvious way to check this is by scrolling through the data with your mouse, but this can be time consuming.  An easier way is by using keyboard shortcuts in Excel.

Assume that you have a data list that begins in cell A1 and has no empty cells.  By selecting cell A1 and then pressing CTRL + → (right arrow), you’ll be taken to the right most cell in row 1 of your data list.  If you then press CTRL + ↓ (down arrow), you’ll be taken to the bottom right most cell in your list.  If you then press CTRL + ← (left arrow), you’ll be taken to the bottom left most cell in your list.  And if you then press CTRL + ↑ (up arrow), you’ll be taken back to cell A1.

What’s interesting to observe is what happens if there is an empty cell in a row or column you are moving across.  Starting from cell A1 again, assume that there is some missing data in column A row 10 of your data list.  Pressing CTRL + ↓ will move the cursor to the last cell in the column containing data before the empty cell.  Pressing CTRL + ↓ a second time will move the cursor to the first cell after the empty one that contains data.  If there were no other cells containing data, then the cursor would move to the last cell in column A in the workbook.  You would observe the same behaviour when moving upwards with CTRL + ↑ and when moving across a row using CTRL + → or CTRL + ←.

Also take note that the same functionality is provided in PivotTables.

Using keyboard shortcuts in Excel makes the process of navigating through your data quick and easy. This helps save you time and makes working in Excel much more efficient.

The post Learn how to navigate through your data quickly with keyboard shortcuts in Excel appeared first on Sage Intelligence.

Source: Excel on Steroids

Post navigation

Learn how to quickly save your Excel management pack as a PDF
Inserting 3D models into an Excel spreadsheet

Leave a Reply Cancel reply

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

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd