varoun717
128582
2101
20
Jun 23, 2023 11:37 AM
varoun717
128582
2101
20
ParanoidCarrot
is this because the eve online integration ?!
ericshen10084
Where are all the alt codes, alt+h+o+i and alt 248 are the most common codes i use
ThisUserNameMightBeTaken
Ctrl+; = today's date.
thisisausernamelikeanyothersbutthisonesmellsweird
CRTL+13 Secret mini game..
CajunTroll
Dot dot
packyzackster
super handy, nice
rubypilgrim
nobody reads manuals anymore - complaints I've heard from tech writers since 1987
BigStew83
If I had had this when I was attempting my MPA I might have passed🤣 The online professor from another university was no help.
trigonman3
Maybe I missed it, but F2 edits a selected (outlined) field.
UnluckyLunkhead
Alt+Shift+N runs macro.
RabeMeansRaven
Is that custom?
UnluckyLunkhead
Office 365, apparently. I used to have a custom shortcut but that was disabled in 365. Now the only way I can see of working it is by Alt+Shift+N
RabeMeansRaven
Yeah it's custom. I have 365 and it doesn't do anything for me.
FoolishMortal
Me: Learns how to do a Pivot Table. Doesn't need it for years. Re-Learns how to do a Pivot table.... ( repeat )....
xenjamin
As a carpenter, I'm glad I don't have to know this stuff.
danherz
Is there a shortcut for inserting a new row or column? (Did I miss it?)
krizzizle
Select a row or col and Ctrl+ to insert to the right of selected and ctrl- to delete :)
danherz
Oh great, thank you!
IntelligentLake
Did you know excel can add numbers together? You don't just have to put in a bunch of numbers and get your calculator to add them together.
IhopeyougetstageIIIcoloncancer
Link to the source! https://excelbianalytics.com/wp/downloads-28-important-shortcuts-in-excel-pinup-reference/
trigonman3
Oh, I love pinups. Thanks!
TransAutisticMakinFARTsGoBallistic
*takes notes in LibreOffice Calc*
BooRidley
kjbopp
CTRL + :/; (Inserts current date)
thedoci
Saving so I can never look at it again like the exercises and other useful info buried in my favorites list.
drduffer
Took an Excel class because work paid for it and learned a lot of these. Got a Covid-19 lay off in 2020 shortly afterwards and haven’t touched Excel since. Oh well. Saved and upvoted as is the Way.
thatauzzieguy
Ctrl-Alt-& for that (save & upvote)
belovedlover
I always favorite and upvote these "because I wanna learn these, I use Excel so often", then I never check back on these :D
drduffer
That’s the mystery of Imgur favorites. They exist, we add to them, and then they’re never seen again.
TheKonstantine
sevenfingerman
Saving for work.
SubTrout
I still can't make my brain understand vlookups no matter how many times I've used them.
krunchybssehku
Vlookup < xlookup
MrBismarck
Good news! Now you can xlookup or Index Match. Godspeed.
SubTrout
Bold of you to assume I know how to do either of those too!
shponglefan
My favorite Excel shortcut: Alt-F4
ikecurumba
Noooooooo!
rshini
man, remembering the early days of MMOs and chatrooms someone says alt+F4 either opens a cheat menu or some cool text editing and seeing how many people suddenly log off
ILikeRocks8
I definitely just had RuneScape flashbacks.
OSCgal
They took away Ctrl+Shift+S (Save As) and I'm still salty.
cheersdom
F12
wolfrog
F12
GrumpyPeopleNeedHugs
Ctrl+Shift+Salty
Ltserb
And Ctrl+shift+v (paste as text)
mbus
You can still do Ctrl+Alt+V, V, Enter or Alt, E, S, V, Enter. It's not quite as fast obviously, but not horrible.
PostingByLees
Thanks for other options. I always do Alt, H, V, V. Which is similar to your first one. Did not know about that ctrl,alt,v to get there.
mbus
You can hit, in order, "Alt, F, A". It takes the same amount of time, and it still works.
TransAutisticMakinFARTsGoBallistic
I may be a drama llama, but my computer isn't. It doesn't eat alt-fa-fa. (Thank you, I'm here all week whether y'all like it or not!)
TyphoonMuscles
Alpaca your bags, you're leaving.
MsAmyMack
F12, no?
OSCgal
Oh wow, thank you!
umbabrahattasil
F4 also duplicates the last action you did, I.e delete a cell. Useful so you don’t have to constantly pick “shift cells up” etc.
umbabrahattasil
Also handy for highlighting.
eastend666
I need this for Google Sheets.
ugopb4me
Same
UrbanSatyr
What's the shortcut to tell Excel the data in a cell is NOT A FUCKING DATE?
igglebotato
"I have a boyfriend"
TooCuteToDie
It says it in the image. Control+Shift+1. Well, that is with two decimals. Control+shift+~ should change that to "common", so you should get away with the decimals, but that doesn't seem to work for me. Of course, this was the first thing I looked at from the image.
PrincessAris
Dear Excel: I do not want Scientific Notation. Ever. NEVER EVER EVER. Please stop.
forsteri80
Dear Excel, I almost exclusively want scientific notation. Always.
ravenousj
Thanks. Just started Excel couple months ago. This will come in handy.
Shadowhawk000095
I just want two lines in a cell!
ilasid
Alt place curser at last letter first
NiceGuy16969
Alt-Enter to act as real Enter, it also changes the formatting to turn on Line Wrapping (I sometimes do an Alt-Enter on a LONG entry that I want to wrap, not have extra lines on, then backspace that Enter)
whoisyourdaddy
Where can I download this in Excel format?
trigonman3
Just make your own, lazybones. Or google it. Might not be on the first results page tho.
whoisyourdaddy
That would not be ironic.
runner630
Convert images to PDF, then in Excel, Select the tab Data > Get data > From file > From PDF, then you can import the text and formatting directly into Excel without having to retype anything.