Hi,
Around two days ago I noticed that the height of my Excel tabs got smaller. As you can see from the below image, the tab called 'Master List' looks like it has a bit of its top cut off. I use the 2021 Student and Home version
Excel Tab.png
I have searched the internet, but haven't found an answer.
Can anyone help ?
Thanks
Welcome to the forum .
Have you changed your monitor resolution or set it to something other than 100%?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
No, I haven't changed any of my monitor settings (15.6inch laptop)
One day before the tab heights changed, I was creating a user form in VBA, where I was adjusting the height of text boxes and labels, but I don't think that
would cause Excel to change the spreadsheet tab heights
I have also installed the latest updates for Excel and also Windows 11 after the tabs heights got smaller, but that hasn't fixed it
I'm on the latest versions and am not seeing the same as you - mine are all normal, so it's not Excel per se. Sorry - can't help any further.
You could attach a workbook, then we can at least check that it's not the workbook at fault.
I have attached the workbook. It contains a number of macros that help me make efficient shopping/grocery lists, but these macros have been there for years,
so it probably won't be macros causing the issue
Thanks
The tab height looks normal on my screen, even after I ran all the macros.
I haven’t run any macros (I’m on an iPad) but the tabs look fine/normal to me.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Maybe this will help:
Edit: link removed as the content appears to be "unreliable".
@6SJ: please remove the link from your initial response. Thanks.
Last edited by TMS; 12-13-2024 at 05:39 PM.
It didn't help me. It reads like AI wrote it.Originally Posted by TMS
That option does not appear on my menu. Nor here:Right-click on any worksheet tab.
Click on ‘Tab Height’.
Click on the “View” tab in the ribbon
Click on “Page Layout” in the “Workbook Views” section
Right-click on any worksheet tab
Select “Tab Color”
Choose “More Colors” at the bottom of the drop-down menu
The tab height option is located under “Advanced” settings
Last edited by 6StringJazzer; 12-14-2024 at 11:34 PM. Reason: removed link
If it is, someone has gone to a lot of trouble to create a lot of content.
Like I said, I couldn't test it.
Happy for you to remove it if you think it's fake or whatever.
There's certainly no option for tab height under Options | Advanced that I can see.
There is a lot of advertising on the page. My working hypothesis is that they generated bogus content with minimal effort to post a page that generates ad revenue.
Have you seen OzGrid? Sam (the owner) freely admits that he can't afford to run the forum as a charity, so uses ads to help pay for it. Hypotheses are just that: reality is, we really don't know.
MrExcel has its fair share of ads, too!
Last edited by AliGW; 12-13-2024 at 11:53 AM. Reason: Additional information added.
Here is more text I randomly selected from this site, bolding mine. This site is absolute garbage.
I wouldn't mind the ads if the content had any value.It's important to note that the ISNUMBER function only checks for numeric values, so it won't work with cells that contain text or other types of data. Additionally, it's worth noting that the function is not case sensitive, meaning that whether you enter a number in uppercase or lowercase, it will still be recognized as a number.
Hi All,
Upon opening my Excel this morning, the issue has been fixed. I didn't do anything, it just got fixed by itself.
I guess there was something wrong with my laptop. So, if anyone gets this issue in the future, just wait 5 days or so, and it will fix itself !
Thanks to all of you for your suggestions and comments
Thanks for letting us know. I thought this might happen.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks