GREAT NEWS! You can now UNHIDE All Excel Sheets in ONE GO! #shorts

Great News for us Excel people! You can now unhide multiple sheets in one go in Excel. No more unhiding one sheet at a time. This is a new feature added to Excel for Office 365.

GEAR

Let’s connect on social:

Note: 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!

#MsExcel #exceltips

[AchtungEnglander]

At long last !! It took them ages to roll this out and for someone who hides and unhides this is great news.

[carlossasis]

Finally!!! Thank you for this nugget of wisdom today! 🥰 Much love! Stay safe!

[wayneedmondson]

Hi Leila. Nice to see this capability added to the interface, although it is pretty simple to do with VBA, such as this code in the immediate window: For each ws in worksheets: ws.visible = true: next ws which I learned in your VBA course :)) Thanks for sharing. Thumbs up!!

[adityabenwal]

I had made a vba macro and assigned a shortcut to it... It unhide all the tabs.. but i think.. this feature is still helpful if you want to unhide multiple tabs and not all.. will try firat thing on monday.. thanks for the info.

[MadMagyar]

Fantastic! This should’ve been an option all along. No need to write macros for unhiding now

[vishalpatil]

Hi leila,
I dont have to rely on office 365 for this functionality, because you already have taught me how to do this using VBA. Thank you :)

[Xyles]

it is honestly amazing that Microsoft is slowly adding all the things you had to do with vba as a built-in feature.

[evelynwald]

Now if only there was a simple way to unhide the personal macro workbook when I close it and don’t realize it until the next time I open excel and try to use a macro I created and it and all my macros are "missing" right when I need them the most. Love your videos & thank you!

[yassirkhalid]

That's why I keep paying for 365, while keep following LG's channel to be not regretting those regular payments!

[ScottLititz]

At this rate, with all the new features, I'll never write a macro again!

[jw]

Short and sweet video. Very good to know about this new excel feature. Thanks.

[Zerogenome]

Can anyone share the version containing this patch?

[amitdeshpande]

Thank you... I was waiting for this feature... Was frustrated unhiding one by one tab

[frankdavid]

Hi Leila, why does Excel not allow a workbook to have more than one .csv sheet? In other formats you can have several tabs. Why not in csv?

[MrTwixraider]

Good news. Hope to receive the update soon from our IT department.

[calgaryexpress]

Thank you. I hope you have an amazing day! My day is just starting and I love it when there is a new video from you. Thanks again, your favourite Canadian 😀

[zasasule]

Your the best leila..alwys learn something usefull from you

[MarkFreemanYVR]

Nice tip. Don't forget "Very Hidden" tabs that will still require a macro.

[prashantdubey]

Hi Leila thanks for the video.. Also can you please make a video how to split a excel file having multiple sheet into separate sheets...

[jasonipfatsiong]

Thanks Leila, more I learn…more I realise how little I know…lol. I would say enjoy long weekend, but only applicable South Africa. Have a great weekend.