From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Various techniques for highlighting (selecting) cell ranges quickly

Various techniques for highlighting (selecting) cell ranges quickly - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Various techniques for highlighting (selecting) cell ranges quickly

“

- [Instructor] Highlighting cells before copying data, 2 deleting data is commonly done in Excel, 3 but there are some shortcuts 4 that'll make the task somewhat easier. 5 I've got a list of names on this worksheet here, 6 so I simply want to highlight all the names. 7 This list is pretty deep. 8 I'll click on cell A2 and do one of two things 9 after holding down the shift Key. 10 Shift key is being held down right now. 11 I can double click the bottom edge 12 highlights all the data downward. 13 Let me jump back up top with Ctrl home. 14 Another way to do this strictly from the keyboard 15 is again with the act and cell at A2 hold down the shift key 16 and then press control with down arrow. 17 Control down arrow. 18 Remember, the shift key is being held down 19 and now I can copy the data, paste it somewhere, 20 whatever it is I want to do with it. 21 Some cases we want to actually delete data. 22 Once again…

Contents