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.

Navigation tips: Shortcuts to jump within and between worksheets and workbooks

Navigation tips: Shortcuts to jump within and between worksheets and workbooks - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Navigation tips: Shortcuts to jump within and between worksheets and workbooks

“

- [Instructor] Reviewing a worksheet that has a number 2 of keystroke shortcuts on it, 3 it's not designed to be comprehensive, 4 and some of these descriptions are a bit cryptic. 5 Most of them relate to what we call navigation, 6 the ability to quickly move around within a worksheet 7 and across different worksheets in different workbooks. 8 On the second worksheet here called employees, 9 I've never seen this before, 10 imagine that scenario, 11 and I'm just curious, how big is it? 12 I often, on any worksheet, will press Ctrl + End. 13 That's the E-N-D key. 14 And what it takes us to is what we might call 15 the lower right hand corner 16 of the active part of the worksheet. 17 When you press Ctrl + End, you can be sure of two things. 18 There is no data anywhere in this worksheet below row 742, 19 nor is there any data to the right of column M. 20 Remember, there are over a million rows 21 and over 16,000…

Contents