From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Select entire row, column, region, or worksheet

Select entire row, column, region, or worksheet

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Select entire row, column, region, or worksheet

- [Voiceover] Before you format data, before you delete data, of course you need to select the data that needs to be formatted or deleted and many times that involves selecting an entire column, an entire row, and although you can click and drag to highlight data, many times there are keystroke shortcuts and techniques that'll speed the process up. In this worksheet, maybe I want to copy all those names from column A to a different worksheet. I don't want the title. I'm going to click right here in cell A2. If I want to highlight all the cells from here downward, I'll be holding down the Shift key and take one of two actions. I'll either double-click the bottom edge, see what's happening, I've highlighted all the cells. Whenever you do have cells highlighted, if you'd like to move around the corners of the range, you can press Control period. I'm holding down Control, I'll press period, it moves me to here, then back up top. I'm pressing Control period, simply moving around the…

Contents