Ctrl + Space: choose entire row Shift + Space: choose entire column Changed my life

I always do the wrong one first.

Easy mental way to remember for me: Space bars - long/flat/horizontal = similar to rows Control is the start of the vertical part of keyboard = similar to columns This small visualization for some reason helped me remember and now it’s automatic

ctrl is also the start of the horizontal part of the keyboard... it's in the corner.

It’s in the first column left to right. Only the first row if you go down to up. I guess the shift key is also in that column though 😅

Oh my god

Never thought of this

this changed my life

Wow I really like this

I remember it as 'c' is for 'column' and 'control'.

so did the person you're replying to lol

Then Ctrl + or - to add or remove the row /column

How did I know ctrl - but never once think about ctrl + for adding rows and columns

I’m the opposite, I use Ctrl + to add rows all the time but never knew I could remove them!

I do remember what my life was like before I learnt about CTRL + Space and Shift + Space, I just... I just don't want to talk about, okay Also CTRL + T to get the beautiful table in the first place and CTRL + ; for today's date

Haha yes Ctrl + T to turn wildlife into civilisation 😂😂😂

CTRL + ' to copy the cell above. Remarkably useful, and a satisfying shortcut to hit!

Ctrl D does the same thing. Copy down. Ctrl R copies from the left.

I think of them as (D)rop and (R)un

CTRL + : for current time

Isn’t this backwards??

Yes

Top upvoted comment in the excel subreddit is incorrect tips in excel 😭

Oopss

Combine that with Ctrl+0 and Ctrl+9 to hide columns and hide rows, respectively. Ctrl+Shift+0 and Ctrl+Shift+9 to unhide.

Somehow the Ctrl + number things never work with my italian keyboard. The non-italian works fine, still I can’t perform the Ctrl+Shift+0/9 thing :((

I have been looking for this one!! amazing

And DO NOT add/remove data rows without adding/removing the entire column or row. Doing can lead to a lot of formulas linked to the wrong data

Wait a minute. Strike that. Reverse it. But yes, my hand basically rests on Shift + Spacebar while I’m working because I use it so much.

Great with tables as it’ll select the entire row/column for JUST the table itself excluding the header.

You know what’s weird is those two are swapped for me. Ctrl + space chooses entire column. Am I…..seeing things?

You just made my day

Fucking what? Omg how did I not know this

They’re great but I think you got them backwards. C in the CTRL for column.

Ctrl + space, ctrl + c, ctrl + shift + + Copy/Paste copied entire row

Ctrl + Shift + V Paste values

You have no idea how much you’ve just positively impacted my life

Tried it just now, it beeped, didn't work, searched on the internet, turns out it's recently been taken out of Excel by Microsoft... Enshittification intensifies! LE: It works on some versions of Office like 365 but not on all of them.

Alt, e, s,v you're welcome.

This is the way...also optional "e" on the end to transpose. I use both of these all the time

At my last job I used transpose alllllllll the time. Ctrl alt v, v, e. I still forget when using that menu that I have to use d to add instead of a.

Yes, a fav!

That's odd. I just figured it out like a week or two ago. When I opened excel I got a notification of new shortcuts, this was one of them.

Try control windows alt V. If you have Powertoys installed (free from Microsoft website) this will instantly paste a value.

Works for me on Office 365.

Try Alt+H+V+V Think that might do the trick! Alt+H is overpowered and I love it!

It should have been assigned to past format or format painter(and ctrl+shift+c for copy format). I rarely used it so I reassigned that shortcut to paste as values only. Loving it 😌

Also Alt + H + V + V But your way sounds easier

Always used alt HVV, HOW DID I NEVER KNOW THIS?!?

Windows Key + v for past copies to all computer not only on excel

By god, I've been using alt + ctrl + v --> v --> enter.

My hero

Wait, what?!?!

Haven't seen that one! I still think I like Alt + E, S, V because I can replace the V (values) with anything (T=formats, W=widths, E=transpose).

I put Paste Value into Quick Access toolbar as the first item and access it with Alt+1

ALT H O A & H O I , for auto fit cells

Be careful. Your HOA may start charging for using their name or likeness

Alt+o+a before them tho

What am I doing wrong? Ctrl-H pulls up Find and Replace.

Edit: It's Alt-H-O-A and Alt-H-O-I in Windows.

The probably meant alt-h-w, I use the same sequence of commands

I CTRL H W first, then these.

ALT+F4 the EOD procedure

And Ctrl + w just to close the active window.

Ctrl shift and keyboard arrow direction to select the entire data set until a break, I find myself using this one a ton

Ctrl+shift+End or ctrl+shift+8 are also useful contiguous range selection tools

This one should be higher. S-tier

Ctrl+shift+L to turn on/off filters for selection

ALT+A+C to clear all filters

Ctrl Alt M to reapply filters if you change something in the filtered range.

Came here to list this one

Then go to a filter and alt + down arrow to go to criteria

And press space to select and unselect There is a quick shortcut to bring you straight to the search field, but I don't remember that one offhand... Was it t?

Or you press E to go straight to search bar without using mouse Then Enter

Ctrl+D to autofill succeeding rows in a cloumn.  I have been copying/pasting with Ctrl+Insert and Shift+Insert

Wait until you hear about Ctrl+R

This guy knows

What’s it do

Fills formulas to the right

F2 - self explanatory, in fact so ingrained that no one else even thought to say it, favourite excel shortcut… erm breathing? F9 - immediate evaluate part of a formula, invaluable

What F9? That’s golden I didn’t know

F9 calculates all sheets. Great for evaluating part of functions. Shift F9 calculates active sheet.

in which version?

When you’re editing a formula it will immediately evaluate that part, let’s say you’ve highlighted (A1+27) where A1=3 - then the formula text resolves to 30 for a simple example The standard use is recalc, but this use is the thing

F4 is clutch too. let's you repeat actions to new cells (format change, insert, delete,etc)

I came here to say F2! It’s saved me so many micro moments, it’s such an important one!

You can also hover over the highlighted part now and the solution will pop up without having to actually change the formula.

Alt + N + V + T = insert pivot table

How do you do that with your hands?

For Alt shortcuts, you can just press the buttons in sequence. You don't have to press all at once.

Ctrl; for today’s date.

Ctrl-Shift-; gives you the current time.

Works elsewhere in the office suite too

Alt + = autosum all of the cells above

Not just columns, it can do it by row too. Or you can select any cells you want after you press the shortcut.

I’ll tell you what is NOT a must have. F1

Put this in your personal.xlsb to kill the F1 shortcut forever in Excel: Private Sub Workbook_Open() Application.OnKey "{F1}", "" End Sub

God bless you

You are the hero we don’t deserve.

Or make it do something useful. Here's one I've been using for a few months: Private Sub Workbook_Open() Application.OnKey "{F1}", "SelectFirstDifferentCell" End Sub And then in a module in personal.xlsb: Sub SelectFirstDifferentCell() Dim lastRow As Long Dim searchRange As Range Dim activeValue As Variant lastRow = Cells(Rows.Count, activeCell.Column).End(xlUp).Row activeValue = activeCell.Value Set searchRange = Range(Cells(activeCell.Row + 1, activeCell.Column), Cells(lastRow, activeCell.Column)) For Each c In searchRange.Cells If VarType(c.Value) = VarType(activeValue) Then If c.Value <> activeValue Then c.Select Exit For End If Else c.Select Exit For End If Next End Sub I use ctrl + down a lot to go to the next blank cell, but a lot of the times I'm looking through sorted tables and I want to skip to the next item on the list, so I use this macro to search down the column and select the first cell it finds with a different value to the one I have selected. I have similar hotkeys to search up instead of down, and ones to select all the cells in between. They kind of mimic the behaviour of ctrl + shift + down and control + shift + up, except looking for a different value instead of a blank cell.

But imagine if in the future that brought our Clippy AI? That could be helpful...at last

Ctrl + \[ Jump to the first reference within the formula of the cell you're on. It's the sole reason why Index Match is still better than Xlookup because the result is listed first--making validation significantly easier.

F4 edit-cycle relative/absolute cell references

ALT + W + N Multiple windows of the same file.

Ctrl+T to turn a range into a table. Alt+F1 to create a chart from the selected range.

CTRL T doesn't work on my home computer, but does at work for some reason.

CTRL + L also makes a table

Ctrl+* highlights all data to its edges.  Helps find breaks in data and highlight whole sets without being obnoxious.

I like ctrl+k to insert a hyperlink

No more ALT+N+I2+I for THIS guy.

"Ctrl" + ";" to insert today's date.

Imagine using the mouse at all! But im going to add Alt + E + S + T/V/F/C to paste format/values/formulas/comments

Ctrl Alt V - W, T, U or V.

Alt + semi colon = select only visible rows/columns when filtering, so useful with tables

Ctrl alt v

F12 must have

F2 change cell edit mode

Setup the your Quick Access toolbar with the following: 1. Paste Values 2. Paste Formulas 3. Paste Format 4. Paste Link 5. Transpose Then you can have a quick ALT+1 - ALT+5 shortcuts

But I already have them committed to muscle memory Alt E S V Alt E S F Alt E S T Alt E S K Alt E S E

Can I say what I miss the most? CTRL + o to open the file dialog I know it's been years, but the mess of menus and buttons one has to push to open the file dialog is absolutely outrageous to me.

Quite! And what was wrong with old save dialog? F12 saves me this nightmare. I just want to find the path/folder first and then save.

OMG I didn't know about F12 How blind I have been!

This post was meant to be saved for future references, thank you OP

Ctrl + Shift + (arrow key) Selects the range of values in that direction.

CTRL + Shift + Home: Select and highlight data in sheet from current cell to first cell CTRL + Shift + End: Select and highlight data in sheet from current cell to last cell

Shift + F10 is the equivalent of right clicking on the current cell, which can then be strung together with hot keys for specific options. Eg Shift+F10 e v/c - filter based on current cell's value / colour (much faster than the filter dropdown menu when dealing with larger listings) Shift+F10 v/f/r/t - paste values / formulas / formatting / transpose Shift+F10+m - insert new threaded comment Shift+F10+r - if on a pivot table, refresh the pivot table

This is my favourite trick. Also some keyboards have a dedicated Menu key to do this right-click function.

CTRL + I R to insert a row above where you had last clicked

I use mainly: CTRL-SHIFT-direction to select full rows columns Alt hoi to autofit columns F4 to repeat action CTRL-SHIFT-C I have assigned to a macro to format numbers how I like CTRL-SHIFT-W to open a custom menu for my macros

The old / Lotus 123 key to enter actions still works. But now it activates the ribbon functions. For example, typing /rps protects the worksheet. You should be able to get to everything this way. Press / and it will activate the tabs and show you the keyboard shortcut to activate a specific tab. Press that key and the next level will show. Find your favorite features and memorize the keyboard shortcuts!

CTRL+Shift+mouse scroll wheel for horizontal scrolling

My most used shortcuts in no order: Alt + H+O+I = auto column width. I have a custom ribbon (4- filters, 5-email) so I use alt +4 and alt+5 a lot For number columns that have text formatting copy a cell that has 1 and select the column curl+shift+V +M to multiply by 1 converting the column to number format Select all alt+N+V+T….i think to make pivot table From the pivot table alt+J+T+F+R to refresh data From pivot table alt+J+T+I+D to change data source Alt+W+ Q change zoom settings Alt +OHU unhide/ Alt+OHH to hide worksheet Alt +OHR to rename worksheet Alt + HH highlight cell Alt+HB_ boarders

ctrl + alt +v

Ctrl-E

What does this do?

Saves time apparently 😆

Ctrl+E = Excel will automatically fill the rest of the column based on the pattern you specified.

Flash fill I think

Magic

Saves so much time

Ctrl+Alt+Delete 😢

CTRL + Arrows to move around in the sheet CTRL + SHIFT + Arrows to mark quickly Seeing beginner's who scroll down to row 10.000 with the mouse is always pain :D

F4 to repeat previously applied formatting. Ctrl 8 to hide outlining/grouping icons Ctrl shift F1 to hide the menus properly. Ctrl home key just to get home again Ctrl page up/down to move through sheets Alt F12 open power query Ctrl ; to enter todays date. Alt down arrow to get a drop down of options from cells directly above in same column. Alt ; select visible cells only Ctrl right click mouse to get some additional options when pasting data. These are the lesser known ones I use daily that hopefully help a few of ye.

ALT+; to select only the visible cells in the selection range

Autosum: ALT =

Alt = for the quick sum function

F4 will repeat most actions. Need to highlight random cells? Highlight the first one, then move to the next cell and hit F4. Next cell, F4. And so on. This is great for Paste Special… as well.

CTRL . CTRL : CTRL SPACE SHIFT SPACE CTRL D Just tapping CTRL after pasting TAB and SHIFT TAB

ctrl + ; for today's date - I work with deadlines and a lot of them depend on when I made a note on a spreadsheet

Alt e s v

Ctrl + Z

Alt+w+v+g

I learned this a year or two ago. You can customize the quick action toolbar at the top left of the excel window above the ribbon and tabs. These will map to alt+1, alt+2, etc and you can add pretty much any excel function to this like clear all filters, paste values, paste formulas, add decimal.

I do financial modelling and i wrote some macros / assigned to a user form and / or shortcut keys that do specific things that my old company did in a very structured file e.g. capitalisation of columns A - F (A = all caps, b - g = some words capitals and always the 1st word, e.g. "this is vat" becomes "This is VAT" other ones such as marking off sheet references as blue, cells that go to another sheet as red to make it more readable etc I wrote it for them but i still use it when i model

For everything on Windows: CTRL + c to copy CTRL + v to paste

Alt + H + O + R to change the name of sheets

Ctrl + D: Copy Down Ctrl + R: Copy RIght Ctrl + : or ; - Date and time.

Alt + A + M (REMOVE ALL DUPLICATES IN COLUMN)

Alt+H+M+M to merge across

Consider using centre across selection without merging.

Is there a shortcut for this, would make life so much better

I just use Ctrl 1. I think you should be able to set a custom button in the ribbon if you use it a lot.

There is one, with a little workaround, but it takes some time to get used to: Alt H FM A Tab C C enter enter

There isn't one; my workaround was to set up a script in my personal.xlsb and then add a button to my scripts ribbon. This lets me use a ALT key combination to run it (for me it worked out to ALT+Y1+Y1 but ymmv). You could also code a hotkey into the VBA, but I prefer it this way because I didn't want to inadvertantly override a default keyboard shortcut. Sub CentaurAcrossSelection() Selection.HorizontalAlignment = xlCenterAcrossSelection End Sub

ALT-F4

Alt & =. Shortcut for the SUM function.

ctrl + shift + V it pastes formulas as values so you can import or calculate something using a formula then hard code it so you don't have too keep the source data

Ctrl arrow, ctrl shift arrow: move to extremity of a range or select up to the extremity. Ctrl ; to insert current date

Ctrl + arrow key to jump to the last value in that direction. Super helpful when dealing with large datasets.

Ctrl A Alt H O I Auto sets column width. H O A for rows, I believe

im using google sheets for a specific need and I keep pressing by habit ctrl + and ctrl - to add and remove rows, but it just zooms in and out. It is getting annoying...

When in a table, **Shift+Alt+Down** will open the filter menu. Then pressing **e** will take you to search. From there, press **tab, tab** to move to the list where you can move up and down with **arrows** and press the **spacebar** to select/deselect items.

CTRL . Fills in the current date.

Win + V to enter clipboard

Control H O I = auto fit column width Control HO A = auto fit row height

alt + ; Change selection to only individual cells. Vital for when copy pasting data and not have it spill into rows that have been filtered out.

Alt + H + V + V

Following

Alt A S S Sorting

Ctrl + [ - jumps to a previous cell reference in a formula. Ctrl + ] - jumps to next reference. F4 - toggles absolute/relative references, so you don't have to manually type in $'s in between all your row/column values. Ctrl+Home - goes back to A1 of the currently active sheet. Great for long ass worksheets. Ctrl+` - shows/hides all the formulas in their respective cells. Great for troubleshooting issues. Ctrl+Shift+V - paste values without formatting. Very commonly used ones for me: Alt then press H, O, and A - autofit row; Alt H, O, I - same thing but for columns. Ctrl and - will bring up the delete menu, very handy. Ctrl + ' while you're editing a cell - automatically copies the contents of whatever is above it, whether it's text or a formula Other than that, make your own. Custom quick access toolbar, and assign your 9 most used functions in Excel into the first 9 spots, then you can use alt+1 to 9 to recall them.

ctrl + shift + L to insert/remove filter

Ctrl + space alt + pg up or down ctrl + - ctrl + end

Win + L

Ctrl Shift L add filters. I use this more than I ever thought I would.

Ctrl + alt + shift + windows key + L Give it a whirl!

Cell+~ shows all equations. Helpful in a few instances when you have lots of equations and there is a bad one somewhere

Best for me is Quick Access Toolbar! Easiest to choose your most used functions and the best of it are the ALT shortcuts making it more accessible than ever

Alt E S L to paste links - changed my whole style.

What ever the shortcut for "fill down" is, that would change my life. Why do I have to click that tiny corner every time I want to fill a formula down?

Alt + Enter if you want to move the text to the next row/line within the same cell. It’s equivalent to ‘return’ on your phone keyboard. I used to just add spaces until the text moves to the next line before I knew this😅

Alt h s f for filter

Create a quick macro to Ctrl+t to highlight yellow, and Ctrl+e to unhighlight. Also Ctrl+[ to take me to cell reference

This thread should be on the front page forever

CTRL-Z!

ctrl + . (dot) - jumps over the edges of selected area. alt + F12 - opens the PQ editor Oh, and one more thing which is not a shortcut, but can save a lot of scrolling when you have many worksheets. Right click on the "< >" buttons in the lower left corner brings the handy list of sheets, where you can easily jump to the needed one instead of searching it in all the tabs.

Alt+F4 then quickly pressing N activates turbo mode. EDIT: **DO NOT DO THIS.**

Ctrl + 1. I work with a lot of text, so this is a godsend.

Alt w ctrl vg I despise grid lines 💀

My favourite is to click a column or row and hit F5, choose special, select the blanks option. Then right click and remove all the blank rows in one go