Hide multiple columns in Excel with this simple shortcut! #shorts

If you have a lot of columns or rows to hide in Excel, I have a great productivity tip for you. In this #shorts Excel tips video I'll show you a super-convenient Excel shortcut you can use.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[lorimiller]

F4 works in Word, too. I use it all the time.

[wayneedmondson]

Thanks Leila. CTRL+y also repeates last action. Thanks for the tips! Thumbs up!!

[vijayarjunwadkar]

With Leila on our "Side", Excel has nothing to "Hide" 😁, I mean with such useful tips, we will know everything about Excel to master it and all "hidden" Excel features will be "unhidden" soon! 😊👍

[chh]

I catch myself subconsciously grinning during Leila's presentations, either 'short' or 'long', as the 'AHA! moment hits me. Once again I had no idea this useful tip even existed, (... and one that I can put to 'immediate' use).

👍👍 ... Thank you... thank you ... thank you ... Prof Leila

[justsurfin]

Very cool. Also in Google Sheets - Hide columns - Control+Alt+0. F4 also works in Sheets for repeat last action.

[towshinst]

I don't know how many people I've suggested to follow you to improve Excel skill with professional manner!

[rusektor]

Also: select columns you need (holding Ctrl) - and hide them ))

[edbrown]

There are so many uses for F4 - anything from repeating a Paste Special > Formatting to colouring/highlighting multiple individual bars on a bar chart. I always say if people are going to learn one shortcut, make it this one (although Ctrl + arrow keys to move around is a close second!)

[suneelrvishwakarma]

I knew this..

but your knowledge is awesome

[BobG-ehfc]

Your channel is great, very useful tips.

[spidersj]

You're the "Last Action Hero"

[jonathanm]

One of my favourites Leila - and you'll no doubt know that it works in Word and PowerPoint too. Maybe Project, but not Outlook. 🤩

[hansklein]

Once F4 for the $$ in the formula, and second for the last action, I'm excited. Another useful "mini" is F2 for cell editing, you can use it also for file or folder names.

[andribimo]

Ah this is great, thank you Leila! Recently I use ctrl+space to select then keyboard(right click)+H

[rabbiltube]

I also use F4 to fold laundry. Lol but seriously try F12 for a one key ‘save as’ (if you have a dedicated function key row or function keys are enabled) works across office programs 👍🏾

[user]

Something Im noticing is that when it comes to doing any repeatable task, excel excels at having a shortcut available for each action. Really cool tips here

[mathieud.]

Great tip indeed ;) thanks for sharing, that f4 function is really a basic to know to save lots of repetitive steps
I personnaly prefer group function, it gives much more flexibility to unhide as needed and also improves columns management.
Select all the columns you want to hide and press ctrl + maj + left arrow
Right arrow to ungroup

[darkensky]

What is the purpose to hide the column?

[mohamedhicham]

Please, my dear sister, make a video on how to move between hidden worksheets using the combo box, and always stay on the active sheet only in the tab names of the sheets, and when entering any other sheet using the combobox, it is shown only and the other is hidden, and so on

[riyazkhan-xmqn]

I need a formula about (20 the value count =1 ) If I entered (40 the value count =2 and 100 the value count = 5 and 1000 the valu count change = 100 could you help me with what formula it was?