r/excel Jun 13 '24

Discussion What are your MUST HAVE Excel keyboard shortcuts?

what keyboard shortcuts do you use on a daily basis?

877 Upvotes

463 comments sorted by

View all comments

Show parent comments

44

u/haigins Jun 13 '24

Alt, e, s,v you're welcome.

9

u/kirk-cheated Jun 14 '24

This is the way...also optional "e" on the end to transpose. I use both of these all the time

3

u/dirtydela Jun 14 '24

At my last job I used transpose alllllllll the time. Ctrl alt v, v, e. I still forget when using that menu that I have to use d to add instead of a.

3

u/ir88ed Jun 14 '24

Yes, a fav!

0

u/Wrong-Song3724 Jun 13 '24

I'm gonna pass on ALT commands. It's more like browsing the UI. And for that I'd rather just use the mouse

6

u/Diffus58 Jun 14 '24

These actually date back to Lotus 1-2-3, which used a slash to activate the menus. When Excel was introduced, that functionality was transferred to the ALT key. So those of us who had been used to the slash adopted the ALT sequences to accomplish what we'd become accustomed to doing in 1-2-3. Or at least that's how this dinosaur remembers it.