varoun717
128591
2101
20
Jun 23, 2023 11:37 AM
varoun717
128591
2101
20
BooRidley
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)
TheKonstantine
TransAutisticMakinFARTsGoBallistic
*takes notes in LibreOffice Calc*
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.
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.
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!
OSCgal
They took away Ctrl+Shift+S (Save As) and I'm still salty.
cheersdom
F12
wolfrog
F12
GrumpyPeopleNeedHugs
Ctrl+Shift+Salty
MsAmyMack
F12, no?
OSCgal
Oh wow, thank you!
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.
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.
eastend666
I need this for Google Sheets.
ugopb4me
Same
kjbopp
CTRL + :/; (Inserts current date)
Shadowhawk000095
I just want two lines in a cell!
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)
ilasid
Alt place curser at last letter first
IhopeyougetstageIIIcoloncancer
Link to the source! https://excelbianalytics.com/wp/downloads-28-important-shortcuts-in-excel-pinup-reference/
trigonman3
Oh, I love pinups. Thanks!
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.
xenjamin
As a carpenter, I'm glad I don't have to know this stuff.
whoisyourdaddy
Where can I download this in Excel format?
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.
trigonman3
Just make your own, lazybones. Or google it. Might not be on the first results page tho.
whoisyourdaddy
That would not be ironic.
CajunTroll
Dot dot
deject3000
The real question is can you vlookup?
ThisUserNameMightBeTaken
Ctrl+; = today's date.
rubypilgrim
nobody reads manuals anymore - complaints I've heard from tech writers since 1987
sevenfingerman
Saving for work.
UrbanSatyr
What's the shortcut to tell Excel the data in a cell is NOT A FUCKING DATE?
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.
igglebotato
"I have a boyfriend"
ericshen10084
Where are all the alt codes, alt+h+o+i and alt 248 are the most common codes i use
packyzackster
super handy, nice
thisisausernamelikeanyothersbutthisonesmellsweird
CRTL+13 Secret mini game..
ravenousj
Thanks. Just started Excel couple months ago. This will come in handy.
trigonman3
Maybe I missed it, but F2 edits a selected (outlined) field.
ParanoidCarrot
is this because the eve online integration ?!
FoolishMortal
Me: Learns how to do a Pivot Table. Doesn't need it for years. Re-Learns how to do a Pivot table.... ( repeat )....
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.
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.
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!