Top of sheet obscured

[terrypin]

I cannot see the top of my worksheet in Excel 365 when I open the ribbon.

HeadingsObscured.jpg

[shg]

Select the row, Format > Autofit Row Height

[Fluff13]

Is the ribbon set to "AutoHide"?

[terrypin]

Select the row, Format > Autofit Row Height

I don't follow - the ribbon is not a row.

[terrypin]

Is the ribbon set to "AutoHide"?

Do you mean this setting in Options > General?
[] Collapse the ribbon automatically.

If so, that is not enabled.

[Fluff13]

No, I mean in the ribbon display options, top right of the title bar next to the - (minimise button)

[terrypin]

Thanks. No, that was not enabled. Using it makes the obscured depth worse: the first fully visible row is then row 4. (And it always maximises the window!)

The screenshot I showed earlier was with the formula bar at its greatest height. It's worse when it's reduced:


(BTW, why does this image appear as an Attachment number that has to be clicked, yet my earlier one was displayed in full?)

Attachment 649964

[Fluff13]

Not quite sure what you mean by this

The screenshot I showed earlier was with the formula bar at its greatest height. It's worse when it's reduced:

as I can increase the formula bar to almost the full screen.

Do you only get this on one file, or on all files?

[terrypin]

All files.
Here's another attempt to show the screenshot:

Attachment 650717

I cannot preview that. Anyone know why?

Let's try a link:

https://www.dropbox.com/s/zcs727vxn1...ed-1.jpg?raw=1

[Sam Capricci]

Can't work with the link and neither of your attachments are valid. Have you tried the instructions at the top of the post in the yellow banner to upload the workbook?

[Fluff13]

You have selected to only show the ribbon tabs, rather than Tabs & commands, that's why you get that.

[terrypin]

Can't work with the link and neither of your attachments are valid. Have you tried the instructions at the top of the post in the yellow banner to upload the workbook?

That's strange, both work fine for me. What exactly happens for you?

As I said, this happens with ALL files, so no point posting one!

[terrypin]

Thanks @Fluff13, that fixed it!

So that's a bug, yes?

[Sam Capricci]

Your link in post 9 is a link to a picture which cannot be worked with.
your attachment, when clicked on comes up as invalid attachment.
From the picture it appears that row 1 has been hidden and row 2 set to a row height that is too small.
Beyond that, without the actual workbook it is difficult for anyone to really figure out what is happening.

EDIT: apparently Fluff gave you the solution so posting it is irrelevant, glad you got it solved.

[Fluff13]

Thanks @Fluff13, that fixed it!

You're welcome & thanks for the feedback

So that's a bug, yes?

No, I think it's meant to work like that.