Comments

You must log in or register to comment.

keepthetips t1_itye34j wrote

Hello and welcome to r/LifeProTips!

Please help us decide if this post is a good fit for the subreddit by up or downvoting this comment.

If you think that this is great advice to improve your life, please upvote. If you think this doesn't help you in any way, please downvote. If you don't care, leave it for the others to decide.

0

hazier_riven0w t1_ityg3xs wrote

I assume you’re doing this in Windows. The ALT key will focus on the menu bar in every application in Windows. It is an OS hot key.

9

CO_Recon t1_itym2py wrote

I use Excel a lot and ha e never seen this! Can you go into more detail and does Googlesheets have this function aswell?

2

strawycape t1_itynjmo wrote

Replying to CO_Recon (#253,811)

Don't think Google sheets does this. Next time you're in an excel workbook, hit the alt key then look at the menu bar at the top - numbers will pop up all over it. Hit the number on the keyboard of the option you want. I use this to add keyboard shortcuts for things there aren't one for (like the comma button for formatting numbers nicely and for format painter) by adding them to the top bar (where the save button is) then using alt.

2

strawycape t1_itynzix wrote

There are so many LPTs for excel - one of my favourites is the new window option, which opens a linked copy of your current workbook. If you work in excel documents that have multiple sheets with formulae that pick up values from other/multiple sheets than the one it exists in, a new window means you can see how changing figures on one sheet affect formula results on another sheets live (either with 2 monitors or by using half your monitor for each window).

6

I_onno t1_itytfj8 wrote

Alt+; is my favorite excel shortcut. It let's you copy only shown cells in the selection.

2

Jigga94 t1_itz2fmz wrote

Don't forget ctrl and shift

1

Flair_Helper t1_iu7vfqb wrote

Hello Sensitive-Round-3906, thank you for your submission! Unfortunately, it has been removed for the following reason:

Your post is not a life pro tip. Advice is any guidance or recommendation concerning prudent future action. An aphorism is a short clever saying that is intended to express a general truth or a concise statement of a principle.Try r/YouShouldKnow.

If you would like to appeal this decision please feel free to contact the moderators here. Do not repost without explicit permission from the moderators. Make sure you read the rules before submitting. Thank you!

1