Forum Discussion
AnzaGen
May 28, 2023Copper Contributor
View all tabs in Excel Sheet
How do I view all tabs in an Excel Sheet at once (I don't want to right click on the bottom left and go to the Activate pop up that appears and go to a tab, I'm talking of viewing all tabs in one vie...
- May 30, 2023
AnzaGen On a Mac the horizontal scroll bar sits above of the sheet tabs. There is no option to shrink/expand or hide it and it follows the width of the Excel window.
The number of visible sheet tabs depends on the length of the sheet names and the size of your window/screen. For example, on my 13" MB Air (full screen) I can fit 16 default tabs (Sheet1 - Sheet16) and they will not wrap to the next row when I add more.
You could suggest it as a new feature. Perhaps MS will do something about it. Help, Feedback, 'I have a suggestion'
AnzaGen
May 30, 2023Copper Contributor
Where is this option in Excel for Mac
peiyezhu
May 30, 2023Bronze Contributor
https://club.excelhome.net/forum.php?mod=viewthread&tid=1662588&mobile&_dsign=236fc179
consolidate with power query or other ways
consolidate with power query or other ways