• 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 select your data conveniently using keyboard shortcuts

By admin on June 13, 2018April 19, 2019

In a previous tip, we showed you how you can navigate around a data list quickly using keyboard shortcuts.  To view the tip, take a look here.  By combining the same shortcuts with the Shift key, you can easily make selections in your data for editing purposes.

Assume that you have a data list with no empty cells and have selected a cell somewhere within the data.  In my case, this is D15.

By using the combination CTRL + SHIFT + → (right arrow), everything in the row from D15 to the end of the row is selected.

Going back to cell D15, by using the combination CTRL + SHIFT + ↓ (down arrow), everything in the column from D15 to the end of the column is selected.

Going back to cell D15, similarly, by using the combination CTRL + SHIFT + ← (back arrow), everything in the row from the cell and to the left is selected.  And likewise, if you were to press CTRL + SHIFT + ↑ (up arrow), everything in the column from the cell and above would be selected.

By using two combinations together, you can make larger selections.  For example, starting from cell D15 again, by holding down CTRL and SHIFT and then pressing → and then ↓, all the data from D15 to the right and below will be selected.

Using these keyboard shortcuts makes it easy for you to select parts of your data for editing and by using two together, you can also make larger selections.  This can be less cumbersome than reaching for your mouse.  Like in the previous tip, it’s also important to observe what happens if you have empty cells, rows or columns in your data.  By playing around a bit, you’ll easily get the hang of things.

The post Learn how to select your data conveniently using keyboard shortcuts appeared first on Sage Intelligence.

Source: Excel on Steroids

Post navigation

How to keep your Report Manager tidy by hiding reports you don’t use
Discover a more detailed analysis of dates using timelines in Excel

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