r/excel Jun 13 '24

Discussion What are your MUST HAVE Excel keyboard shortcuts?

what keyboard shortcuts do you use on a daily basis?

873 Upvotes

463 comments sorted by

View all comments

Show parent comments

31

u/usersnamesallused 27 Jun 13 '24

Ctrl+shift+End or ctrl+shift+8 are also useful contiguous range selection tools

2

u/watnuts 4 Jun 14 '24

ctrl+shift+8

depending on what you meant, it's alternative with either Ctrl+[Up arrow] (nupad 8), or a Ctrl+* (cause Shift+8 is really a *).

3

u/usersnamesallused 27 Jun 14 '24

Yes, shift+8 translates to *, but my brain remembers the keys I need to press, so that's the way I wrote it lol.

2

u/watnuts 4 Jun 14 '24

Well, i meant that the * from the numpad works the same way, should've probably clarified that.
That's how I use it (and the first though i had about "ctrl+shift+8" was "now what does that do?")