Selecting the current region and moving around region corners


show more Selecting the current region and moving around region corners provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Selecting the current region and moving around region corners

If you work with database-like data in Excel and if you'd like to optimize your use of many of the commands found on the Data tab such as Sorting and Filtering and Subtotals out here, and also PivotTables found elsewhere, you can click on a single cell and activate a lot of these commands pretty quickly. And what happens is for example I click Sort right now, and see how the background is automatically highlighted? Well that isn't always the case and doesn't always work out quite so smoothly, and here's what you need to do in some situations.

Suppose you've never seen this data, or it's been a long, long time. You are not quite so sure of, is there a hidden row somewhere or an empty row? What if I put in an empty row here? Maybe another person put this in for a page break or something, didn't think much of it, put in an empty row. So what would happen here if we did start sorting here? Now if I zoom way back, we will see pretty clearly. We don't normally z...

Selecting the current region and moving around region corners
Video duration: 3m 13s 3h 43m Intermediate

Viewers:

Selecting the current region and moving around region corners provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...