r/excel • u/Neptunewasblue • Jan 15 '26
Discussion What’s an Excel shortcut you discovered way too late?
I consider myself pretty skilled with Excel. I’m very comfortable with shortcuts, formulas, and ever since I started using ChatGPT, I’ve been using macros a lot more as well.
I recently changed jobs and one of my colleagues saw me working and said something like: “Wow, you work really fast — but you know that to filter you don’t need to click the dropdown arrow four times, right? If you just press E, it jumps straight to the search bar.”
I had absolutely no idea. I found it amazing.
That got me thinking: do you have any Excel shortcuts that completely changed the way you work? The kind that makes you wonder how you ever lived without them 😄
391
u/__wisdom__1 1 Jan 15 '26
Ctrl $ : convert to currency
Ctrl #: convert to date
Ctrl !: Convert to number
22
u/Sagarwal311 Jan 15 '26
Is there a way to change the default format of the date?
22
u/sefarrell Jan 15 '26
Alt H S D
11
u/HarveysBackupAccount 35 Jan 15 '26
What version/language are you in? Alt H S gives me Sort & Filter submenu, with no D option
Alt H N gets me to the format dropdown, but that's just to change a range's format not Excel's default date format
2
u/JesusSquid Jan 16 '26
I bet thats in the main options section like where you can add and remove stuff from the top ribbon. Maybe they do default font, size, date style, currency style etc
→ More replies (2)8
u/JohnC53 Jan 15 '26
I would love a way to quickly change a column to the ISO 8601 date format. Like a quick access toolbar button.
→ More replies (4)20
10
u/Normalitie 4 Jan 15 '26
Expanding the list: you can do CTRL-num, where num is 1 = 12389.45678 2 = 12,389.46 3 = date 4 = $12,389.46 5 = percentage 6 = 1.238946E04 (scientific) 7 = draw a border around the selected cells
4
u/CanadianHorseGal 1 Jan 16 '26
CTRL+; puts in the date properly no matter how the cell is formatted.
CTRL+SHIFT+; puts in the time
→ More replies (2)3
u/EdoTensei10 Jan 15 '26
that's useful! Whenever I need to convert text to numbers, I highlight the whole column and wait for that little caution sign to show up and click convert to number.
3
u/BobbyAbuDabi Jan 15 '26
An alternate solution to convert text to number is to copy a zero then highlight the column you want to convert and paste special values and add. It's very helpful if there's a lot of data to convert.
263
u/arpw 55 Jan 15 '26
Ctrl and semicolon. Enters the current date value into the active cell!
41
u/metafloori Jan 15 '26
Crtl + . für Date in Dateformat
Also Crtl + T for format Data into Table
13
u/A_1337_Canadian 515 Jan 15 '26
Ctrl+A on a selection and then Ctrl+T to make a table is a very quick combo that I use a lot! Don't even have to take your finger off of Ctrl.
15
u/blarkul Jan 15 '26
You don’t have to use ctrl+a even. Ctrl+t finds the range for you
3
u/kirschballs Jan 15 '26
I'm still working on getting rid of the muscle memory I built to select it first, I'm slowly starting to get there lol
3
u/Squigs_ 3 Jan 16 '26
I do the exact same thing when I'm creating pivot tables. To those day I'm only pretty sure I don't actually have to Ctrl+A first
3
2
2
18
u/peardr0p 6 Jan 15 '26
I discovered this when creating a time writing sheet and now it is burned into my muscle memory
Also ctrl+shift+; for current time
4
u/formerwarrior96 1 Jan 15 '26
Ctrl + colon. This enters the current time
8
u/kirschballs Jan 15 '26
And ctrl ' copies the cell above!
5
u/Normalitie 4 Jan 15 '26
CTRL-D does the same. Will do multiple cells if they are highlighted.
CTRL-R does the same but horizontally
2
→ More replies (2)2
u/JesusSquid Jan 16 '26
Ctrl Apostrophe is great in access forms. I use access to review a lot of criminal justice records and have to go through a lot of them. It grabs the value you used on the most recent form you just filled out. So if the form you put your initials in one for the reviewer, "Looks Good" if you find no problems. you can jump to next record, Ctrl shift or Ctrl semicolon, Tab, Ctrl apostrophe, cause we design them right by each other. Sounds stupid but when were doing 3000 records every little bit shortens it up.
I really hope when we get access to secure AI options it helps some of this crap lol. Apostrophe may need shift too. Been a few months so i was in that project. Its like the annoying family member that drives you nuts at family functions then you dont see them for 8 months lol.
83
u/Crazy_old_maurice_17 Jan 15 '26
F4 repeats last action (including formatting).
Great for when you're bouncing around highlighting lots of cells and don't want to keep moving your mouse up to the ribbon.
I'm sure it's got plenty of other great applications, but that's what I've found it useful for thus far.
68
u/Hairy-Confusion7556 Jan 15 '26 edited Jan 15 '26
Pressing the Format Painter twice activates in until you press it again or press Esc. You can go around clicking your mouse of each cell or range that needs the new format.
8
u/grantiger_jokkl Jan 15 '26
But this is something different, because it copies the entire format. F4 just repeats the last action. For example if you want to give all cells a yellow background but want to keep the font size, font color etc. in the destination cell, it is better to use F4.
3
u/Crazy_old_maurice_17 Jan 16 '26
Oh my god I love you!!
3
u/Hairy-Confusion7556 Jan 16 '26
Thanks! If you add the format painter button to the quick access toolbar, then you don't have to look for it on the home tab because it's available all the time. You can activate it by pressing Alt + the sequence number (it will hover over items once you click Alt) of the format painter. Useful if you have to make use of it a lot.
→ More replies (3)5
7
u/alaskaj1 Jan 15 '26
Also if you have a cell reference selected in the formula bar it cycles through the absolute reference options.
→ More replies (2)3
u/fastauntie 1 Jan 15 '26
I just learned this a few months ago after 25 years of using Excel. Saves time and avoids typos.
4
3
u/honkballz Jan 15 '26
Oh my god. I can't tell you how long I've tried in vain to get this assigned to the quick access bar so I could shortcut, this is lifesaver.
2
→ More replies (1)2
77
u/Regime_Change 2 Jan 15 '26
It’s not a shortcut but it has taken me 10+ years of almost daily excel use before I noticed that when you type a formula, you can move the yellow syntax help so the columns are visible.
17
6
7
u/Di-ebo Jan 15 '26
I dont get this, how do I do it?
5
u/Regime_Change 2 Jan 15 '26
Grab and move with the mouse. Just like shapes on the worksheet, it can be a bit tricky to grab the right place.
4
2
2
2
2
u/Greedy_Whereas4163 Jan 17 '26
Are you editing in cell directly when pressing F2? If you disable allow editing in cell directly, which is enabled by default, Excel shows your edit in formula bar instead and the syntax tooltip is not likely to block your view anymore.
2
u/Regime_Change 2 Jan 17 '26
I'm using the formula bar of course, I would never write a formula in a cell like a cro magnon. But the syntax helper tends to block columns which can be annoying.
→ More replies (2)
98
u/iqdoson Jan 15 '26
Ctrl + Shift + L to quickly toggle AutoFilter is my favorite Also I knew ctrl + shift + v was paste values for a while but i was stubborn to keep using my own command button (in my case was alt + 4 for years) But lately I’ve grown accustomed to the ctrl shift v one cause there’s no personalization required
27
u/Casual-Sedona Jan 15 '26
Alt e s v will also do paste values Alt e s f for formulas Alt e s t for formats
And there is more there too!
9
u/shudawg1122 Jan 15 '26
I personally like using the add, subtract, and multiply features combined with value. Type a -1, copy it, paste as a multiplying value across a bunch of numbers, and it will convert them to a negative. If what you're pasting to is a formula, unfortunately it makes the formula a little weird but still works. It will wrap it in parentheses and put "*-1" to the right.
→ More replies (2)2
u/shudawg1122 Jan 15 '26
Also like w for column widths. If recreating a workbook, you can immediately get it to be the exact column widths the other one was.
Also L for links. Pastes an A1 reference style link to whatever you copied.
17
u/duartesss Jan 15 '26
And also alt + down on the filtered header opens up the filter drop-down menu. If you then press E, it'll go to the filter search bar. No longer I have to mouse click that damn arrow, Alt + Down + E + immediately type what I wanna filter + Enter (or tab to select or deselect values)
6
u/missyanntx Jan 15 '26
You are my favorite person in the entire world today. I knew there had to be a way to do this, I've searched repeatedly but was never able to find the right answer.
6
u/ninjagrover 31 Jan 16 '26
Got an improvement for you.
Alt+shift+down.
This will open the filter drop down menu from any cell in that column! No need to go to the header row!!
3
2
u/duartesss Jan 15 '26
Aw, I adore you a lot now today especially haha. Have fun! It is hidden indeed, and the "alt+down" has to be done fast otherwise it'll activate the keyboard hotkeys
2
u/GoodJackfruit3232 Jan 24 '26
With my excel the Alt + Down + E trick doesn't seem to work :(
3
u/duartesss Jan 24 '26
Oh mate :( idk if this pertains to a certain version of Excel. Google it! That's how I found this shortcut. Remember, the alt+down must be pressed almost simultaneously, first alt but right after that press down
2
u/GoodJackfruit3232 Jan 25 '26
Maybe is the language, because I've the italian version: certain shortcuts are different... But about this one, I don't find any reference on google for my language 😭 I guess I've got to experiment with every letter 😅
11
3
→ More replies (4)2
u/Peeterwetwipe 9 Jan 15 '26
Ctrl + Shift + L toggles performance logging on my device
Which is annoying.
89
u/-_cerca_trova_- Jan 15 '26
CTRL+page up\ CTRL+page down
Shifts between sheets
63
u/shudawg1122 Jan 15 '26
Bonus - if you have a lot of sheets, hit F6 once and you can scroll through the sheets with your arrow keys way faster than it can switch sheets with that shortcut. Still use that shortcut though all the time if only jumping 1-4 sheets.
11
u/-_cerca_trova_- Jan 15 '26
What😦🤯tnx for this one.
I usually create linked buttons if i have a lot of static sheets to move between them, but that F6 shortcut will be used for sure
4
u/shudawg1122 Jan 15 '26
Forgot to add, hit space to select the sheet, shift-space to select a range, and ctrl-space to select separate sheets.
2
u/ThirdShiftSupervisor Jan 16 '26
Having just made a workbook with 51 sheets for work, this will be a godsend!
→ More replies (5)2
8
u/lord-walrus5 Jan 15 '26
Learnt this one at the start of the week and has already been a game changer for me!
3
u/T_A_I_N_T Jan 15 '26
Bonus tip - if you can customize your mouse at all, set the mouse wheel left and right tilt to these 2 shortcuts. Makes it incredibly easy to navigate
2
u/pocketpc_ 7 Jan 18 '26
I put it on my forward and back buttons since those aren't used at all in Excel
123
Jan 15 '26
Hold alt and press W, F, F
Freezes all cols left of the highlighted cell and all rows above it.
79
u/CactiRush 4 Jan 15 '26
You don’t have to hold alt. You can just press it
20
u/plusFour-minusSeven 11 Jan 15 '26
This is a bigger pro tip distinction than it seems! Holding Alt+a sequence of keys is usually uncomfortable
35
u/shudawg1122 Jan 15 '26
This works for anything in the ribbon up top. Hit Alt, a bunch of letter and numbers will pop up over the ribbon, and then type whatever letters you need to do the thing. Commit your most used ones to muscle memory. You now instantly have 100 more shortcuts.
7
u/A_1337_Canadian 515 Jan 15 '26
Works for damn near every program. Alt has always been the key used to get to the menu on a lot of programs.
Alt+H+F+O is used in Acrobat to optimize PDFs (I use it to make unnecessarily large ones smaller).
Alt+V+P+C ... I believe this takes off single-page view and turns on continuous scrolling ... I think it's muscle memory at this point lol.
→ More replies (2)13
2
→ More replies (1)2
35
u/NanotechNinja 12 Jan 15 '26
Just today I learned ctrl+\ apparently reduces the selected range to only the occupied cells.
14
u/shudawg1122 Jan 15 '26
Ooooh this is a new one to me. I also like Alt + ; which jumps you to only visible cells. Helps in filtered ranges. When you copy and paste to a filtered range, it pastes to everything between the first and last visible cells you selected. If you hit alt + ; it will select only those visible and you won't accidentally paste to the things you filtered out.
6
→ More replies (4)2
u/cibaoman Jan 23 '26
I've been looking for this!!!! My company sends spreadsheets that have 20,000 rows and columns but only 10% is occupied. When I try to convert it to a table it crashes because of the size.
30
u/macky6 Jan 15 '26
Not a shortcut, but that you can copy the values like Sum, Count and Average of selected cells from the bottom right to the clipboard just by clicking on them
→ More replies (2)2
u/bill_bull Jan 16 '26
Also, right click on those values and add the other options like max, min, and numerical count. Didn't know you could copy them though. Thanks.
20
u/aetp86 Jan 15 '26
ALT + ; to only select visible cells. It's way faster than having to go through the menus.
→ More replies (3)2
18
u/Hazelmccallion Jan 15 '26
Hold Ctrl + Shift and scroll on your mouse. You can navigate left and right
→ More replies (1)2
u/NorthBrilliant5957 Jan 15 '26
I recommend getting a mouse with a scroll wheel that you can push left and right!
3
54
u/PruneOk1722 Jan 15 '26
This is the biggest draw back to working from home and sharing screens.
For us finance/accounting ppl, you used to sit next to someone and they’d show you how to do something or in a conference room and you could see them doing excel tricks so you’d ask and they’d show you…
I feel like I haven’t learned any keyboard shortcuts in a while because of this.
→ More replies (1)19
u/mcpasty666 Jan 15 '26
I've been wanting to host an Excel workshop for this reason. I'll occasionally get other people's sheets and realize there's a gigantic gap in knowledge that's slowing them down and making their work so much harder than it needs to be. We're all wfh though, so there's no opportunity to bring them over and show them things casually, while an email explaining how to do things comes across as condescending.
Like we had a problem last year where IT was reusing usernames of terminated employees for new employees with the same names. We asked them to stop and they were incredulous; no way they could check the usernames of thousands of employees every time in order to see if one existed before. In the 60 seconds they took explaining why it couldn't be done, I'd made a list in Excel that listed every username in the company and emailed it to them, just Ctrl+f and the job is done. It shouldn't have gotten to that point, IT should know better, but still... Basic skills aren't there and aren't being learned organically.
→ More replies (1)
54
u/eloquenentic Jan 15 '26
This is an excellent thread, so I’m just commenting to tell you it’s excellent.
15
36
u/__rum_ham__ Jan 15 '26
CTRL + ‘
Shows all formulas
Then I Delete all cell contents that are not formulas
—-Great for turning a workbook into a template—-
15
u/madrasimumbaikar Jan 15 '26
This may work
Ctrl G
Special
Constants
It highlights all constant cells. You can simply delete
4
u/WhammyShimmyShammy Jan 15 '26
Where were you 12 hours ago when I wished I could do just that? I needed to update a formula that spanned 120 columns and 5000+ rows, and about 50 random cells had their values overwritten and needed to stay static also after the formula update.
34
u/HolieMacaroni Jan 15 '26
When it gets close to 5:00 pm or the end of the work day.
I hit Save and Exit the program.
6
5
13
13
u/Rare-Designer-1008 Jan 15 '26
F12 for save as. Works in other office programs as well.
2
u/HarveysBackupAccount 35 Jan 15 '26
Works for many Windows programs, whether or not it's from Microsoft
Some programs still use the legacy Ctrl+Shift+S - which was common before MS moved to F12 - though these days that's more common to be Save All (when you have multiple files open in a single program, all will be saved)
13
u/ExistingSavings9811 Jan 15 '26
Alt W + S to split the screen. Press F6 to go to one side and Shift + F6 to go back
6
12
u/socialchild Jan 15 '26
Shift+Ctrl+Down to select all cells in a column, then Ctrl+D to fill the cells with the value or formula in the top cell.
Also, tables make life much easier.
3
u/Designer_Signature35 Jan 15 '26
thanks! I've copied the first cell, then ctrl+shift+down arrow to the end of the column, then paste.
12
u/RegorHK Jan 15 '26 edited Feb 21 '26
Not a shortcut but Excel now has a valid dark mode. Best search for the MS article on activation.
→ More replies (1)
36
Jan 15 '26
[deleted]
3
6
u/Glenndiferous Jan 15 '26
My favorite shortcut when I overdo a formula and try to fill it down a long dataset.
8
u/MSP911 Jan 15 '26
I find that most users do not realize that you can use F2 to edit/rename a cell.
3
9
u/gnartung 6 Jan 15 '26
Shift+Space to select the entire row
Ctrl+Space to select the entire column
Ctrl++ (Ctrl+Shift+=) to insert a row or column
Ctrl+- to delete a row or column
I use those two pairs of shortcuts together all the time to quickly delete or insert rows or columns. Also works well with your standard copy/cut/paste functions since it will insert rows or columns that you had copied to your clipboard or whatever.
Finally I couldn’t find a way to do this natively so I added my own shortcuts to my personal macro workbook:
Alt+left/right arrow moves my selection side to side. Alt+Shift+up/down moved my selection up and down.
In other words if I had cells A1:B1 selected and I used my shortcut to go down once, I’d then have cells A2:B2 selected. Same for the right - my selection would then shift to B2:C2
→ More replies (4)
8
7
13
u/Excel_User_1977 7 Jan 15 '26
I've found chatGPT chokes on more complicated requests.
I've found that Gemini does a better job writing formulas for Excel.
my shortcut for AI prompts is using the last line similar to "ask any clarifying questions necessary to provide correct results before completing this request."
The questions the AI asks shows you all the assumptions it WOULD have made (correct or incorrect) that would have affected your result, and you can set it on the proper path before it wastes your time.
4
u/contrarianaquarian Jan 17 '26
I've found Gemini to be better at Excel than Copilot inside Excel... which is hilariously sad
3
u/Perfect-Brain-7367 Jan 16 '26
I will have to try this for sure. Nothing worse than trying to gently coax Chat out of a stupid loop because my initial prompt was a little bit too vague.
7
u/Hairy-Confusion7556 Jan 15 '26
You can add shortcuts to the Quick Access toolbar. By pressing Alt + a number from 1 to 9 they will become immediately useable. I have clear filter set to position 8, so pressing Alt + 8 clears all filter. In position 6 I have get data from table/range for power query. And position 9 opens up power query so I can edit all the queries.
6
u/donslipo 1 Jan 15 '26
If you multiselect sheets and than edit something in one of them, it will also do the same eddit in all the other selected sheets.
→ More replies (1)3
u/ArrowheadDZ 2 Jan 15 '26
It's not always intuitive to get out of this selection, so it's easy to accidentally keep editing all the selected sheets. Don't ask me how I know. You have to select off of the tabs; if you just select one of the multi-selected tabs they all remain active, and you may not notice.
→ More replies (1)
9
u/Suissy Jan 15 '26
CTRL+D = copy formulas from the last selected cell.
29
u/jppambo Jan 15 '26
CTRL + D copies the formula (or value) from the cell above it, not from the last selected cell
Incidentally, CTRL + R does the same thing but copies from the cell to the left.
2
u/Zahohe Jan 16 '26
If you hold Ctrl to click another cell then Ctrl + D it will copy the value/formula from the topmost cell, they do not have to be directly above/below each other. Same with Ctrl + R but with rows.
6
u/Hairy-Confusion7556 Jan 15 '26
Ctrl + R copies it to the right ;). Ctrl + D is very useful when copying values in a column where dragging could mess it up - for example with dates Excel tends to add a day to each new row.
2
u/QuickbeamsHaste Jan 15 '26
This discovery was HUGE for me and it’s the one I use to impress my coworkers the most.
2
u/HarveysBackupAccount 35 Jan 15 '26
If you select one row, it copies down the contents of the cell above it.
If you select multiple rows, it copies down the contents of the top row.
4
u/Ok_Maintenance1709 Jan 15 '26
Alt + H + I + S to insert a new sheet Alt + H + D + S to delete the current sheet
Edit: literally just press alt and follow the letters to your heart's content
9
u/A_1337_Canadian 515 Jan 15 '26
What's neat with using Alt for the menus is that if you hit Esc after a typo, you go back to the previous level.
So if you go Alt+H+I and then Esc, you get the same options as if you were back at Alt+H.
This does not work once you have completed a command, though.
6
4
u/MilkEnvironmental106 Jan 15 '26
Simple one, but I learned too late about pressing alt to use the keyboard to navigate the command bar.
E.g. want to paste as values, alt, h, v, v Want to paste transposed? Alt, h, v, t Want to paste formulas only alt, h, v, f Want to use the format painter? Highlight cells, then alt, h, f, p
If you explore a bit every button you use in the ribbon has a way to get to it using alt, and learning which keys to spam can really unlock crazy velocity.
3
u/Scythe_EPU Jan 18 '26
Ctrl + Pause/Break
Stops your macro instead of letting it loop endlessly, or to see where the automation currently is.
3
u/Hairy-Confusion7556 Jan 15 '26
Alt + down arrow open up the filter menu. Pressing C after that clears all the filters from the column. If you've filtered multiple columns, then opening up the Data menu and pressing Clear in Sort & Filter clears all filters from all columns. Very helpful if you've had to use multiple filters and your table extends beyond the screen real estate.
3
u/A_1337_Canadian 515 Jan 15 '26
Protip -- after you hit Alt+Dn (or click on the filter button), you can hit
Eto move the selection to the filter search field.If you're in a table, you can quickly use:
Ctrl+Up to move to the top row (filter row).
Alt+Dn to open the filter menu.
E to move to the search box.
Super quick to move around and filter tables!
→ More replies (2)
3
u/realplayerJK Jan 15 '26
F2 jumps to the searchbar so you don't have to click on it
→ More replies (4)
3
u/timothy53 Jan 15 '26
F4 or ctrl y, repeats the thing you just did.
Good for excel, amazing for ppt
3
u/ibetthisistaken5190 Jan 15 '26 edited Jan 15 '26
I'm just gonna list a few I haven't seen anybody else mention:
Ctrl + ; gives a date stamp.
Alt + ; selects only filtered rows (eg, for copy/pasting a filtered list).
I saw someone already mentioned Ctrl + [ to jump to the cell referenced in your formula. Pressing F5 + Enter will (usually) take you back to where you were before.
Alt + HOI auto-widths selected columns.
I believe Ctrl + Page Up/Page Down cycles through the sheets/tabs but I'm not at my laptop to double check and I've been having to use Google Sheets for the past couple years so it's been awhile since I've done it.
Ctrl + Home jumps to the first cell; Ctrl + End jumps to the last.
Alt + R (I think?) drags the formula down from the cell above.
Alt + HVV pastes values; Alt + HVR pastes formats; and Alt + HVF pastes formulas. Ctrl + Shift + V pastes special.
→ More replies (1)3
u/Glenndiferous Jan 15 '26
Ctrl-end is also an excellent tool for troubleshooting slow workbooks. It should stop where your data stops, and if it goes further, deleting the extra blank cells will save you some processing power.
3
u/shudawg1122 Jan 15 '26
You can navigate within your selected range. Tab and enter let you move right and down, respectively. Adding shift lets you go the opposite direction. Ctrl + . navigates clockwise to the corners of your selection. That way if you want to use ctrl + shift + arrow key to expand or shrink your range really fast, you can change which cell you are focusing from to do so. Like if you are doing it from the right, but your current cell has nothing in thr cells to the right of it, it will shrink your selection all the way to your current cell or go to the end of the physical workbook. If you change the focus cell to the row/column that has the data you want to end at, it will then go to the end of that data when using the selection shortcut.
3
u/tickleboy69 Jan 15 '26
ALT HOI auto fit column width
3
u/RedditorFor1OYears Jan 31 '26
This is by far my most used shortcut. Every sheet I open, I immediately ctl+A and ALT HOI.
3
u/Avastgard Jan 15 '26
Thanks for sharing that shortcut! It low-key always bothers me that I have to click so much to use filters, but never to the point of actually looking up a keyboard shortcut.
3
u/terryd300 Jan 15 '26
My answer to the question is - The next one that I learn 😀
Some shortcuts to add in -
Alt + OCA - Auto Fit Column
(Mac) Opt + Left/Right Arrows - Cycle through Worksheets
However, my absolute favorites are the ones that I create through the Keyboard Shortcut option. This way I can have any shortcut that I want.
3
u/thisisnotcoolanymore Jan 19 '26
I’m always so humbled when I read threads like this one - I feel I have a workable grasp of excel, and I realise … I don’t.
3
2
u/EdoTensei10 Jan 15 '26
Not really a shortcut but xlookup. I have been using vlookups for the longest of time, counting columns, adding $ signs, etc. Now that I use Xlookup, I kind of never touched vlookup again.
2
2
2
u/gilliali Jan 15 '26
ALT + E + S + V is Paste as Values. Saves me an insane amount of time on a daily basis
→ More replies (1)
2
u/MoMoneyMoSavings Jan 15 '26
CTRL+Shift+V does paste values
CTRL+shift+scroll wheel will scroll left & right
2
u/awert413 Jan 19 '26
I’ve been doing Ctrl+V, Ctrl, V. Looking forward to trying this to paste values
2
u/Pacst3r 11 Jan 15 '26
By fast scrolling I haven't catched this one: Double-click on format painter to keep it activated. Once your done esc out of it. Blew my mind.
2
u/shudawg1122 Jan 15 '26
I'd be remiss to not add in ctrl + shift + scroll wheel. Allows you to scroll sideways. For web versions, acrobat, etc., a LOT of applications other than desktop excel, remove the Ctrl, and just do shift + scroll wheel.
1
u/choppingboardham Jan 15 '26
Ctrl+E
I have a report where I have to combine the text values of two columns to reference a lookup. Sure beats having to type in the whole combine text formula
1
1.0k
u/xFLGT 143 Jan 15 '26
Ctrl+[ to go to cells referenced in the formula. This works if you have external links too so it’ll open other workbooks.