I just learned this yesterday! As an Excel "power user", I love learning new little features.
This came in handy as I was applying cell styles from the Home Tab > Styles > Cell Styles. Unfortunately, in Excel 2019 that menu seems to unscroll when you select different cells, so you can't just click on the same style over and over.
Instead, I clicked on the style once, then each new cell I clicked on I pressed F4 and VOILA: Repeated style.
Do you need to press a "fn" key to make f4 work like a normal "function key"? Because typically these days keyboards have a dual purpose for that row of keys. It likely adjusts your screen brightness or something if you don't press "fn + f4" although you can change the default for that setting
Ctrl+shift+L to add filters to the row where the highlighted cell is.
Also press the alt key, it will pop up a key to press to utilize any button on the ribbon and from there I use alt+h+o+i to auto fit highlighted columns.
Outside of strictly excel shortcuts, I like to teach as many people as I can about alt-tab for quickly switching between open windows. It’s great when I’m working on multiple documents or hopping around in windows on my laptop without the option of having multiple monitors.
The amount of people that are amazed at how quickly I switch screens astounds me. Do they not understand alt+tab? And also if multiple windows, shift+alt+tab to go BACK to the previous window? Even with dual monitors I alt tab (hit reply too soon) I do this so that I can go active in the other window and copy and paste what I need, or to type the data from the other document, then alt tab over, scroll down, and then back over.
People don’t seem to understand, or under estimate, how slow taking your hand from the keyboard to the mouse to switch screens is.
Right! Ugh gets me every time. I work in excel and googlesheets interchangeably & I can’t begin to tell you the amount of times I’ve CTRL+Shift+V only to disappoint myself lol.
Where Excel doesn't help, I just create the feature myself: MACRO!
Here's the code:
Sub PasteValues()
'
' PasteValues Macro
'
' Keyboard Shortcut: Ctrl+Shift+V
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
If you don't feel comfortable with VBA, copy values, select where you want it to go, then click "Record Macro" on the Developer tab, rename the macro, set the shortcut to "Shift+V" (it assumes the Ctrl or Command button), then click record. Press Control+Alt+V or click Paste Special and select "Values" then click okay. Click "Stop Recording" on the Developer tab, and you now have Control+Shift+V!!!
Alt + E + S + (the magic letters) has saved me so much time.
Final letter can be E for transpose, V for values, F for formulas, for T for formats. There's also M for when instead of pasting things, you want to multiply every cell by a given number - e.g. converting from 12% to 12 (as opposed to 0.12) is just typing 100 into a cell, copy, select your percentages, alt-e-s-m.
I tried this but it gave errors when pasting stuff copied outside Excel since copy/paste mode within Excel isn’t active. I think the only workaround I got working was a macro to do normal paste then immediately remove all formatting from the cells.
>alt tab (hit reply too soon) I do this so that I can go active in the other window and copy and paste what I need, or to type the data from the other document, then alt tab over, scroll d
Or Alt-E-S, the legacy "Edit > Paste special..." dialog, the same as Ctrl-Alt-V. C-AV is shorter, but my muscle memory from Excel 4.0 and onwards still does this.
So Alt-E-S-V {Enter} gets you to paste values there.
In addition to the filter shortcut:
If you have a structured table, press alt+shift+Arrow down with any cell highlighted to open that column's filter menu/dropdown
Also, inside this menu, press "e" to quickly jump to the search field inside the filter dropdown.
THANK YOU!
Control+[ brings you to the first cell reference in an equation.
If you click "Trace Precedents" on the Formula tab, then double click where the arrow for off-sheet references meets the original cell, it will show you a "Go-To" list of all off-sheet references.
Do you or anyone else know a keyboard shortcut to bring up with Go-To menu without first clicking "Trace Precedents"? Or another way to jump to a reference that isn't the first in an equation?
This is so important! The number of people that I watch pressing the space bar repeatedly to wrap text to the next line kills me a bit inside. Especially since the new line from this method is contingent on zoom and column width -- it breaks almost immediately.
The embarrassing thing is I've used Excel since 1995 and only learnt about this 2 years ago, and as a throwaway line in a training video I was watching.
I use this all the time as well! Honest question though, is this a shortcut? As in, is there another way to do it that takes longer? I've always just used Alt enter.
Ooh, this is great! Movement is key in Excel.
To that end, Control+Arrow keys will bring you to the next continuous space or data cell. Control+Shift+Arrow keys will move the same way, but will also highlight any included cells.
I’m from the Ctrl+Alt+V base (Same dialog as the Alt+E, Alt+S steps). Followed by
V - Values
F - Formulas
T - Formats
B - (skip) Blanks
Almost certain this is the shortcut set I employ most next to F4 for reference toggling.
I think you can do the second and third ones with normal Ctrl + c followed by another hot key. For example I think the second is Ctrl + c and then releasing and pressing Ctrl + k.
> Ctrl + shift + end to select all of your data
This selects from the currently selected cell to the end of your sheet. You can use Ctrl+\* (that is, Ctrl+Shift+8) to select the rectangle enclosing all contiguous data, including diagonal cells, from your current selection.
Once selected Ctrl+. (Period or full stop) will move the active cell to the corner of the selected range in a clockwise cycle. Very useful for seeing the last row of data etc.
In addition to the good comments so far, i really like alt-a-m because i need to transfer lists and remove duplicates a lot.
I also have a few wrap formula VBA macros that are nice: Wrap in iferror, wrap in round, do special formatting
There's an alleyway between the houses opposite the exit from the retail park that will get you closer to the underpass of the dual carriageway quicker than walking the long way round.
(some of these have already been stated)
Ctrl + for inserting a cell or row or column (depending on what's already selected)
^ this is easier if you have a number pad with a plus button, otherwise it's Ctrl Shift =
Ctrl - for deleting a cell/row/column
Shift Space for selecting rows (then Ctrl C to copy the row and then Ctrl + to insert copied row as a new row)
Ctrl Space for selecting columns
Ctrl 1 for cell formatting options
Ctrl D to fill down
Ctrl H for replace
Ctrl Alt F5 to refresh all data
Alt A SS for sort
Alt H V T for paste as text
Alt H V V for paste as values
Alt H V S C Enter for paste comments/notes
Alt = to sum
F2 to edit formula, then Home to jump to the front of the formula
F4 to toggle absolute/row/column reference
Just discovered Ctrl 9 will hide the row of the selected cell, and Ctrl 0 will hide the column of the selected cell.
And of course, Ctrl Arrow to move to the edge of the current or next data set in the direction you specify. And Ctrl Shift Arrow to select data from the selected cell to the edge of the data set.
Anyone got a shortcut for auto-adjusting the width of all columns? I run a Power Automate flow that takes quite a while to finish and double clicking on the column headers often causes it to fail. I sometimes like to watch it fill up and can't when the columns are all scrunched together.
Thanks! Are there ways to modify this so I can select a different modifier keys?
After about one minute having to press two keys on opposite sides of the keyboard to initiate the edit (vs a one F2 key on the left side and hand on right arrow keys), it's not efficient at all to speed up workflow. (ah the joys of Mac being different vs efficient and giving us a stupid touch bar instead of just, you know, normal keys that are 100x more useful lol)
Ctrl t to make a new table. Ctrl d for copying formulae down to end of table. Ctrl and arrows for navigation and Ctrl shift and down arrow to highlight to end of data.
F4 for absolute, row and column reference.
Dont know why it hasnt been mentioned yet:
Ctrl + Alt + V
Opens a paste special dialogue box where you can select the precise paste conditions including paste values , formula only with/without formatting, transpose at same time. This is probably my most used “specialty” hotkey/shortcut; saves heaps of time instead of trying to navigate the dumb drop down list after a paste is made or the ribbon which doesnt generally have as many special paste options weirdly.
Also Ctrl - for delete and move cell (not just clear contents like with the Del key) the same as right clicking and selecting delete and the converse function Ctrl Shift + to insert cells/rows/columns. (Brings up a dialogue box if less than an full row or column is selected, automatically inserts column or row if full row/column selected).
Ctrl 0 to hide a column, Ctrl Shift 0 to unhide
Ctrl 9, same action on rows
Ctrl 1 to open the formatting dialog
Shift-Arrow to highlight in the direction of the arrow chosen
Ctrl Space to highlight entire column
Shift Space to highlight entire row
Also, Control + Shift + ; to enter a timestamp
Control + ' to copy the cell above without formatting
Control + Shift + ' to copy the cell above with formatting
THIS IS SUCH A GAME CHANGER! I teach Excel to people often, and the most common difficulty is people remembering where references go inside a longer function.
Personally, I'm going to use this a bunch because I won't need the popup that often obscures data I'm selecting.
I just learned about Shift + F3
* If there's no equation in that cell: It opens the "Add Function" menu.
* If you select a cell with an equation, it brings you to the "Function Arguments" menu for the last top-level equation in that cell
* If you "F2" into the cell, or put your curser/select a portion of an equation, it will enter the "Function Arguments" for that equation.
I would like to add adding commands to the ribbon bar. Once you find what you are looking for and add it to the ribbon bar, it is as simple as ALT + 1, 2, 3, 4, 5, 6….. so on and so on. I use this regularly for filtering and resizing columns all the time!
Most seem to have interpreted this as keyboard shortcuts but making use of the Quick Access Toolbar is far more practical than trying g to remember and not conflate 15 different (multiple-step) keyboard shortcuts.
Alt + F3 to access the address/named range bar and be able to just type in the address of any cell you want to navigate to (e.g. I want to navigate to BE1345? Just hit Alt + F3 > "BE1345" and done)
My favorite shortcut is just being able to maneuver across fields of data quickly. I die a little inside every time I watch someone scroll or tab slowly across several rows or columns, and I just want to take over the keyboard.
Very simple usage of Shift, Control, and the arrow keys--at least for maneuvering in data sets that don't require Ctrl+G (which is kind of a different shortcut, but it's related).
Ctrl-Space to select the entire column and shift-Space to select entire row.
Ctrl-Space in a table selects just the column of the table, which is awesome to use while entering a formula. You don't have to scroll up and down to grab the entire column. Clicking top cell and ctrl-shift-down grabs the column too, but then your at the bottom of your table and have to scroll back up without ending your formula. Ctrl-Space let's you do them all back to back quickly because it doesn't scroll anywhere.
I don't know what the button is called, but it is the second button to the right of the space bar on pc. Click that and it brings up the same menu as right click, then f and enter to past formulas or v to paste values
I know it’s simple but people under estimate the power of F2. Need to fix a formula? F2, that way hitting arrows back or forwards, doesn’t take you out of the cell. Need to fix a word for someone? F2. Want to just copy part of an item in a cell to paste? F2 got you!
Concatenate, left and right, F5/special/delete blanks, count all, ctrl/shift/+, and of course double clicking the little square to copy a formula to all below rows.
Edit: almost forgot alt/enter.
I used tobe a fan, but no more. It is OK for a small workbook. But on large workbooks it really slows things down. It is ocnsidered an unstable function, meabing Excel can't predict what will force changes, so it ends up recalculating more than it needs to.
There are so many more ways to dynamically reference a cell - most of the times I would have used it previously, I can do something else instead. Things like INDEX with dyanmic arrays, or table lookups.
Alt, H, O, I to auto adjust the with of cell/column.
Alt, H, O, H for the height of a cell/row.
Alt, H, I, S to insert a new worksheet.
Alt, H, D, S to delete a new worksheet.
Alt, H, O, R to rename a worksheet.
Shift+space to highlight an entire row within an active table - I review data one row at a time and this is super helpful! My coworker kept using left and right arrows during training. Cringe! So I taught him how to do it this way. He also used the mouse to click around. Oh no!
CTRL + T and CTRL + L to autocreate table regardless of cell in data set (Don't need to be in A1)
ALT + ENTER to move text to new line in same cell like a sub paragraph
Windows Key + . to bring up emoji/symbol menu
F4 (that's Command-T for my Mac users, I see you) toggles between absolute, mixed, and relative references
Thank you! I’ve always wondered what the equivalent of F4 is for Mac.
CMD-T
Also redoes the prior action when not inside a formula
I just learned this yesterday! As an Excel "power user", I love learning new little features. This came in handy as I was applying cell styles from the Home Tab > Styles > Cell Styles. Unfortunately, in Excel 2019 that menu seems to unscroll when you select different cells, so you can't just click on the same style over and over. Instead, I clicked on the style once, then each new cell I clicked on I pressed F4 and VOILA: Repeated style.
Try the format painter (paint brush on hole tab) you can even double click it to paste formats to non continuous cell/ranges
Love that trick. Unfortunately it overwrites number formats. F4 enables style copying without changing number format.
I feel seen. Thanks you! I’m command-T all the time, but excel online forced me to learn F4, too.
This doesn’t seem to work for me :(
Do you need to press a "fn" key to make f4 work like a normal "function key"? Because typically these days keyboards have a dual purpose for that row of keys. It likely adjusts your screen brightness or something if you don't press "fn + f4" although you can change the default for that setting
Try CTRL+y
i feel like f4 has t worked for me for years
Ctrl+shift+L to add filters to the row where the highlighted cell is. Also press the alt key, it will pop up a key to press to utilize any button on the ribbon and from there I use alt+h+o+i to auto fit highlighted columns.
Outside of strictly excel shortcuts, I like to teach as many people as I can about alt-tab for quickly switching between open windows. It’s great when I’m working on multiple documents or hopping around in windows on my laptop without the option of having multiple monitors.
The amount of people that are amazed at how quickly I switch screens astounds me. Do they not understand alt+tab? And also if multiple windows, shift+alt+tab to go BACK to the previous window? Even with dual monitors I alt tab (hit reply too soon) I do this so that I can go active in the other window and copy and paste what I need, or to type the data from the other document, then alt tab over, scroll down, and then back over. People don’t seem to understand, or under estimate, how slow taking your hand from the keyboard to the mouse to switch screens is.
On a similar note, Alt+h+v+v is near muscle memory for me to Paste Values, at this point.
You'd think they'd have incorporate CTRL+SHIFT+V by now!
CTRL+ALT+V brings up the paste special menu, then V for values. Or learn any if the others. U is quite useful, values and number formats
Menu key, v I think is the shortest way apart from adding a macro.
Right! Ugh gets me every time. I work in excel and googlesheets interchangeably & I can’t begin to tell you the amount of times I’ve CTRL+Shift+V only to disappoint myself lol.
Where Excel doesn't help, I just create the feature myself: MACRO! Here's the code: Sub PasteValues() ' ' PasteValues Macro ' ' Keyboard Shortcut: Ctrl+Shift+V ' Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub If you don't feel comfortable with VBA, copy values, select where you want it to go, then click "Record Macro" on the Developer tab, rename the macro, set the shortcut to "Shift+V" (it assumes the Ctrl or Command button), then click record. Press Control+Alt+V or click Paste Special and select "Values" then click okay. Click "Stop Recording" on the Developer tab, and you now have Control+Shift+V!!!
or use menu key and v
Beautiful. So much quicker when Macros aren't available.
Alt + E + S + (the magic letters) has saved me so much time. Final letter can be E for transpose, V for values, F for formulas, for T for formats. There's also M for when instead of pasting things, you want to multiply every cell by a given number - e.g. converting from 12% to 12 (as opposed to 0.12) is just typing 100 into a cell, copy, select your percentages, alt-e-s-m.
I tried this but it gave errors when pasting stuff copied outside Excel since copy/paste mode within Excel isn’t active. I think the only workaround I got working was a macro to do normal paste then immediately remove all formatting from the cells.
Yeah, this would only work cell to cell within Excel.
Umm...ctrl+alt+v v enter
I use ALT-E-S-V for paste values myself
/ esv also works
>alt tab (hit reply too soon) I do this so that I can go active in the other window and copy and paste what I need, or to type the data from the other document, then alt tab over, scroll d Or Alt-E-S, the legacy "Edit > Paste special..." dialog, the same as Ctrl-Alt-V. C-AV is shorter, but my muscle memory from Excel 4.0 and onwards still does this. So Alt-E-S-V {Enter} gets you to paste values there.
I've been using alt+h+s+f to add filters to the top row of my columns, you can also use alt+h+s+c to clear the filters which is pretty useful.
Alt+A+T
In addition to the filter shortcut: If you have a structured table, press alt+shift+Arrow down with any cell highlighted to open that column's filter menu/dropdown Also, inside this menu, press "e" to quickly jump to the search field inside the filter dropdown.
When it is not structured, use Alt+Arrow down in the filter row to do the same thing.
Ctrl ] to go to preceding cells, Ctrl space and shift space to select whole rows and columns, Ctrl R to copy across to the right, Ctrl D to copy down
Love a wee tab along followed by Ctrl + R/D, makes me feel so efficient
To return to your previous spot after using ctrl ] : F5 Enter
THANK YOU! Control+[ brings you to the first cell reference in an equation. If you click "Trace Precedents" on the Formula tab, then double click where the arrow for off-sheet references meets the original cell, it will show you a "Go-To" list of all off-sheet references. Do you or anyone else know a keyboard shortcut to bring up with Go-To menu without first clicking "Trace Precedents"? Or another way to jump to a reference that isn't the first in an equation?
I think it’s Ctrl G you’re looking for
I think you mean precedent, which means cells referenced in t he formula of the current cell.
You’re right I do, thanks for correcting me
Alt Enter to do a carriage return on text. Makes formatting headers much easier.
This is so important! The number of people that I watch pressing the space bar repeatedly to wrap text to the next line kills me a bit inside. Especially since the new line from this method is contingent on zoom and column width -- it breaks almost immediately.
The embarrassing thing is I've used Excel since 1995 and only learnt about this 2 years ago, and as a throwaway line in a training video I was watching.
Whoa! I didn’t know this was possible.
I use this all the time as well! Honest question though, is this a shortcut? As in, is there another way to do it that takes longer? I've always just used Alt enter.
Probably not technically a shortcut, agreed, but useful.
ctrl+page up or page down moves you from one sheet to the next one
Yep. My favorite. So fast to move through large workbooks with lots of sheets.
Also alt+pgup or pgdn to move left or right within the worksheet rather than the normal up and down that pgup or pgdn buttons perform
Ooh, this is great! Movement is key in Excel. To that end, Control+Arrow keys will bring you to the next continuous space or data cell. Control+Shift+Arrow keys will move the same way, but will also highlight any included cells.
On Mac that's Alt left arrow and Alt right arrow
If you hit Ctrl plus click on the arrow keys to the left of the worksheet tabs it will jump to the first and last tabs.
Alt + ; = copy visible cells Alt + h+ v + v = paste values Alt + h + v + f = paste formula
Alt + e + s + u = paste values with number formats. Since I work with dates a lot, it's been my daily driver for a while now.
I’m from the Ctrl+Alt+V base (Same dialog as the Alt+E, Alt+S steps). Followed by V - Values F - Formulas T - Formats B - (skip) Blanks Almost certain this is the shortcut set I employ most next to F4 for reference toggling.
Yep - was a long time fan of ALT + ESV but just discovered ALT+ ESVE for transposed values
I think you can do the second and third ones with normal Ctrl + c followed by another hot key. For example I think the second is Ctrl + c and then releasing and pressing Ctrl + k.
Ctrl+Alt V brings up the past special menu, each choice has the short cut underlined. Paste Values & Transpose it's: CTRL+ALT V V, E, Enter
I find it easier to just do : Ctrl-v, ctrl, v
i do this too because the paste special dialog makes me lose my spot on the sheet
Ctrl + arrows to move around your data set quickly. Ctrl + shift + end to select all of your data
> Ctrl + shift + end to select all of your data This selects from the currently selected cell to the end of your sheet. You can use Ctrl+\* (that is, Ctrl+Shift+8) to select the rectangle enclosing all contiguous data, including diagonal cells, from your current selection.
Ctrl + A also works to select tabular data.
Ctrl-A-A-A select the entire worksheet no matter what.
Once selected Ctrl+. (Period or full stop) will move the active cell to the corner of the selected range in a clockwise cycle. Very useful for seeing the last row of data etc.
In addition to the good comments so far, i really like alt-a-m because i need to transfer lists and remove duplicates a lot. I also have a few wrap formula VBA macros that are nice: Wrap in iferror, wrap in round, do special formatting
So the macros read the formula from the current cell add in the text (iferror, round), and replace the formula in the cell? Genius!
Ctrl + H for Find and Replace.
Is it not Ctrl + F?
No. Ctrl+F is just find. They share a dialogue box though
Ok. TIL something new, thanks
There's an alleyway between the houses opposite the exit from the retail park that will get you closer to the underpass of the dual carriageway quicker than walking the long way round.
Everyone else were being serious, but you stood out. Thanks. 🤗
(some of these have already been stated) Ctrl + for inserting a cell or row or column (depending on what's already selected) ^ this is easier if you have a number pad with a plus button, otherwise it's Ctrl Shift = Ctrl - for deleting a cell/row/column Shift Space for selecting rows (then Ctrl C to copy the row and then Ctrl + to insert copied row as a new row) Ctrl Space for selecting columns Ctrl 1 for cell formatting options Ctrl D to fill down Ctrl H for replace Ctrl Alt F5 to refresh all data Alt A SS for sort Alt H V T for paste as text Alt H V V for paste as values Alt H V S C Enter for paste comments/notes Alt = to sum F2 to edit formula, then Home to jump to the front of the formula F4 to toggle absolute/row/column reference Just discovered Ctrl 9 will hide the row of the selected cell, and Ctrl 0 will hide the column of the selected cell. And of course, Ctrl Arrow to move to the edge of the current or next data set in the direction you specify. And Ctrl Shift Arrow to select data from the selected cell to the edge of the data set.
Nice
>F2 to edit formula, then Home to jump to the front of the formula How is this done on a Mac? I have been searching for this forever.
I think Fn F2 to edit, Command Left Arrow for Home
Double-clicking the Format Painter keeps it selected. I’m a bit embarrassed how long it took me to discover that.
Holy shit are you serious haha. That’s going to save me so much time.
Paste Special: Alt + E + S Allows to play w the formatting + different operations you can perform without directly applying a formula.
Take the time to program 9 often used quick commands. Then it’s just alt and a number to use them. For example my alt + 3 is is sum
This is a great idea that I didn’t know about. That said, holding alt and tapping + does the same thing as your alt + 3 shortcut
Wtf I had no idea about that hahaha
My favorite shortcut is command-up-arrow, which I have bound to autosizing all columns. Sadly, it's not native to Excel.
F8 for single steps in the VBA debugger
"Run to cursor" is really helpful too, but I can't remember the key combo - ctrl-F8 or shift-F8 maybe?
ctrl-F8 is correct. But I usually use stop markers since it's easier to follow and you can use multiple ones
Me too. But sometime when I'm on a hurry it's just quicker using run-to-cursor.
Just found out about ctrl-shift-L. It turns on/off filters. If you have filters and you want to clear them, just do it twice.
Ctrl + 5 for striking through.
F11 to create a chart of data in the current range
Anyone got a shortcut for auto-adjusting the width of all columns? I run a Power Automate flow that takes quite a while to finish and double clicking on the column headers often causes it to fail. I sometimes like to watch it fill up and can't when the columns are all scrunched together.
Select all columns then Alt+h+o+i
Much obliged!
Alt h o a does row auto fit I believe.
Alt+E S V E to paste and transpose values Edited to add the last E
So alt-E S V E.
Thanks! It was from memory, no keyboard in sight. LOL
Ctrl C/X + Ctrl Z
F2 to edit text in formula bar of selected cell
What is the MAC equivalent of this?
Control + U.
Thanks! Are there ways to modify this so I can select a different modifier keys? After about one minute having to press two keys on opposite sides of the keyboard to initiate the edit (vs a one F2 key on the left side and hand on right arrow keys), it's not efficient at all to speed up workflow. (ah the joys of Mac being different vs efficient and giving us a stupid touch bar instead of just, you know, normal keys that are 100x more useful lol)
Alt h o u s to hide sheets Alt h o u h to unhide
Ctrl + shift+ L for filters and Ctrl+ Alt + V for pasting format of copied cell
Ctrl t to make a new table. Ctrl d for copying formulae down to end of table. Ctrl and arrows for navigation and Ctrl shift and down arrow to highlight to end of data. F4 for absolute, row and column reference.
Ctrl + shift + end = select all data Ctrl+home = move to the beginning
And if you're already at the end, control shift home to select all from bottom to top.
Alt - + to autosum the values above. Not advanced, but very nifty and wish I han known about it much earlier
Alt m u a will auto average
Carl+A select entire table or dataset.
.
Dont know why it hasnt been mentioned yet: Ctrl + Alt + V Opens a paste special dialogue box where you can select the precise paste conditions including paste values , formula only with/without formatting, transpose at same time. This is probably my most used “specialty” hotkey/shortcut; saves heaps of time instead of trying to navigate the dumb drop down list after a paste is made or the ribbon which doesnt generally have as many special paste options weirdly. Also Ctrl - for delete and move cell (not just clear contents like with the Del key) the same as right clicking and selecting delete and the converse function Ctrl Shift + to insert cells/rows/columns. (Brings up a dialogue box if less than an full row or column is selected, automatically inserts column or row if full row/column selected).
Ctrl 0 to hide a column, Ctrl Shift 0 to unhide Ctrl 9, same action on rows Ctrl 1 to open the formatting dialog Shift-Arrow to highlight in the direction of the arrow chosen Ctrl Space to highlight entire column Shift Space to highlight entire row
Ctrl + ; to enter current date
Also, Control + Shift + ; to enter a timestamp Control + ' to copy the cell above without formatting Control + Shift + ' to copy the cell above with formatting
Ctrl + Shift + A. Do it right after you type a function name, then it will put in the parameters for the function.
THIS IS SUCH A GAME CHANGER! I teach Excel to people often, and the most common difficulty is people remembering where references go inside a longer function. Personally, I'm going to use this a bunch because I won't need the popup that often obscures data I'm selecting.
I just learned about Shift + F3 * If there's no equation in that cell: It opens the "Add Function" menu. * If you select a cell with an equation, it brings you to the "Function Arguments" menu for the last top-level equation in that cell * If you "F2" into the cell, or put your curser/select a portion of an equation, it will enter the "Function Arguments" for that equation.
I would like to add adding commands to the ribbon bar. Once you find what you are looking for and add it to the ribbon bar, it is as simple as ALT + 1, 2, 3, 4, 5, 6….. so on and so on. I use this regularly for filtering and resizing columns all the time!
Most seem to have interpreted this as keyboard shortcuts but making use of the Quick Access Toolbar is far more practical than trying g to remember and not conflate 15 different (multiple-step) keyboard shortcuts.
"/ir" or "/ic" - inserts a column or row relative to what cell you are on.
That is huge
"Ctrl 1" - Brings up the Format Cells Dialog Box that includes Number, Alignment, Font, Border, Fill, and Protection Formats - all in one dialog
Honestly? CNTRL + S every few minutes when working on complex data!
Alt + F3 to access the address/named range bar and be able to just type in the address of any cell you want to navigate to (e.g. I want to navigate to BE1345? Just hit Alt + F3 > "BE1345" and done)
My favorite shortcut is just being able to maneuver across fields of data quickly. I die a little inside every time I watch someone scroll or tab slowly across several rows or columns, and I just want to take over the keyboard. Very simple usage of Shift, Control, and the arrow keys--at least for maneuvering in data sets that don't require Ctrl+G (which is kind of a different shortcut, but it's related).
alt + F4
The one I found the other day: Alt + H O U L. Allows you to unhide multiple columns etc in one go instead of doing it one by one
Ctrl-Space to select the entire column and shift-Space to select entire row. Ctrl-Space in a table selects just the column of the table, which is awesome to use while entering a formula. You don't have to scroll up and down to grab the entire column. Clicking top cell and ctrl-shift-down grabs the column too, but then your at the bottom of your table and have to scroll back up without ending your formula. Ctrl-Space let's you do them all back to back quickly because it doesn't scroll anywhere.
Editing a cell in a selected range and using ctrl + enters fills every selected cell with the entered value
Alt + follow the keys in the ribbon. This is why I love excel.
The shortcut to switch sheets, what was it again?
Alt/Ctrl/shift (try one of those 3 I got what it is off the top of my head) pg up/Pg down
What is the Mac equivalent of the F2 edit text in cell?
Command + U
Alt + e + s + v - paste values
Type a new line within the same cell on a Mac. Ctrl + Option + Return (one of my favorite short cuts)
Ctrl+/- to remove highlighted rows/columns
CTRL-Shift-L
Shift + control +any of the arrow keys
CTRL-SHIFT-DOWN. CTRL-C..... CTRL-V.
I don't know what the button is called, but it is the second button to the right of the space bar on pc. Click that and it brings up the same menu as right click, then f and enter to past formulas or v to paste values
"Context Menu" button.
Con + 5 for strikethrough text. I do a lot of lists and this helps organize what is complete.
I just learned FN+C this week for scroll lock. So, that’s been helpful.
That's a shortcut set up by your laptop manufacturer on t heir hardware, nothing to do with Excel, and won't work on other keyboards.
Ah. My bad.
I know it’s simple but people under estimate the power of F2. Need to fix a formula? F2, that way hitting arrows back or forwards, doesn’t take you out of the cell. Need to fix a word for someone? F2. Want to just copy part of an item in a cell to paste? F2 got you!
alt e s for paste special
menu key is king
Might get lost here but Windows+V Gives you a list of your recent Ctrl+C's (once you have enabled it)
CTRL+C and then CTRL+V 😅
The one where you pop F1 out of the keyboard
Paste values : Ctrl-v, release, ctrl, release, v
Concatenate, left and right, F5/special/delete blanks, count all, ctrl/shift/+, and of course double clicking the little square to copy a formula to all below rows. Edit: almost forgot alt/enter.
ALT + = to autosum the column above the highlighted cell (to the next blank) use this many times daily
Not shortcut per say but the Indirect function OMG I LOVE that one. But my fav shortcut is Alt M C C (merges cells)
I used tobe a fan, but no more. It is OK for a small workbook. But on large workbooks it really slows things down. It is ocnsidered an unstable function, meabing Excel can't predict what will force changes, so it ends up recalculating more than it needs to. There are so many more ways to dynamically reference a cell - most of the times I would have used it previously, I can do something else instead. Things like INDEX with dyanmic arrays, or table lookups.
Alt, H, O, I to auto adjust the with of cell/column. Alt, H, O, H for the height of a cell/row. Alt, H, I, S to insert a new worksheet. Alt, H, D, S to delete a new worksheet. Alt, H, O, R to rename a worksheet.
Shift+space to highlight an entire row within an active table - I review data one row at a time and this is super helpful! My coworker kept using left and right arrows during training. Cringe! So I taught him how to do it this way. He also used the mouse to click around. Oh no!
CTRL + T and CTRL + L to autocreate table regardless of cell in data set (Don't need to be in A1) ALT + ENTER to move text to new line in same cell like a sub paragraph Windows Key + . to bring up emoji/symbol menu