ATOI365D

#Office365Challenge – Hiding Tabs in Excel – thought I’d share this as I actually meet a lot of people who don’t know this.

Day: 137 of 365, 228 left
Tools: Excel
Description: Hiding Tabs in Excel

In Excel you have the ability to Hide Tabs. Now, I know you’re thinking – why would you hide tabs? I do a lot of data validation In my spreadsheets that lookup data from lists. These lists I keep on separate sheets and then hide those sheets (tabs), before I share it with people. They can still unhide it – but it’s not that obvious if you don’t know the extra tab exists.

Right click on the Tab to Hide it:
HideTab1

To unhide the Tab, right click on the last tab, and select Unhide:
HideTab2

Confirm which Tab you would like to unhide:
HideTab003

Easy right?

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements