Forum Discussion
Hidden Sheets
Hi all, for some reason my sheets are hidden by default. Every time I open a new excel all sheets are hidden. So I need to manually show the sheets. How do I set to have the sheets visible as default.
I have my excel for mac 365.
5 Replies
- NikolinoDEGold Contributor
Hide or unhide a worksheet
Select the worksheets that you want to hide.
How to select worksheets
To selectDo thisA single sheet
Click the sheet tab.
If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab.
Two or more adjacent sheets
Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.
Two or more nonadjacent sheets
Click the tab for the first sheet. Then hold down Command while you click the tabs of the other sheets that you want to select.
All sheets in a workbook
Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.
On the Home tab, click Format > under Visibility > Hide & Unhide > Hide Sheet.
To unhide worksheets, follow the same steps, but select Unhide. The Unhide dialog box displays a list of hidden sheets, so select the ones you want to unhide and then select OK.
Hope I was able to help you with this info.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- mmatte77Copper ContributorThat does not work, since once I close the excel and open a new one the problem is still there. I need to fix it forever.
- NikolinoDEGold Contributor
Even if I don't have any special knowledge of Macs, I always recommend updating in advance. Update the operating system and Office.
As unbelievable as it sounds, I hear very often that this cancels out many of the problems with Mac.
Update Office for Mac automatically
Check for updates and install
Update macOS and its apps
Select "System Preferences" from the Apple menu () in the corner of the screen. Click on "Software Update". If updates or upgrades are available, click Update Now or Upgrade Now to install them.Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)