White bar in EXCEL

DESEVEDAVYDaniel Posted messages 1 Status Member -  
 Fred -
In EXCEL, how to remove the display of the unusable white band located just above the column letters?

9 answers

brucine Posted messages 24642 Registration date   Status Member Last intervention   4 139
 
Hello,

Out of simple curiosity, I assume this is it:
https://docs.microsoft.com/en-us/microsoft-365/compliance/sensitivity-labels?view=o365-worldwide

Which if I'm not mistaken requires not only Office 365, but also indeed a setup by the company/administration that owns the account in question and has a license for this purpose.

And which makes it difficult to answer the question as long as one is not in these working conditions (including potentially administrative rights for creating these labels).
2
alhock
 
That's exactly what it's all about.
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello
The only white band I know of in this area is the formula bar, and we can't say it serves no purpose
to remove it from display:
tab: View / Paragraph "show" and uncheck "formula bar"'
kind regards

--
The quality of the response mainly depends on the clarity of the question, thank you!
1
Alhock
 
It’s not because you’ve never seen this white space (I’m not talking about the line because it’s roughly equivalent to 6 or 7 lines of the spreadsheet) that it doesn’t exist, and Daniel is not an idiot; he knows how to use the formula bar.
I also had this white space and I may have managed to get rid of it.
I think it’s related to the document classification option and I believe it’s a business strategy.
Anyway, the space appears where we should find the classification choice.
What I did that made it disappear:
In a new Excel sheet
Click on “Comments” in the top right (sorry, I have an English Excel, so it’s probably Commentaires in French)
The gray comment space appears on the right side of the sheet and miraculously the classification choice appeared in the white space.
Close the Comments space
Choose a classification
Close Excel without saving
Upon the next opening, the classification choice was in its place and I no longer had the white space.
1
Daniel
 
Thank you Alhock for this response, and especially for the content of the message. That's kind.
Indeed, she has helped me a lot...
Good luck to you and take good care of yourself and your family.
Looking forward to it.
1
Fred
 

Thank you very much. Precise method, 100% effectiveness, proactive and non-critical attitude. I had been searching for weeks and here is finally my answer.

0
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   834
 
Hello DESEVEDAVYDaniel

You are talking about the formula bar; if it is too wide, hover over the bottom line until the cursor becomes a double arrow, click, and drag up to resize it.

0
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
Hello Daniel.

Attention: If you need to use Excel for anything other than putting a list of data into cells, your "white band" will be irreplaceable, necessary, mandatory, essential...
With your reasoning, we should also hide the letters indicating the columns and the numbers indicating the rows!

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
Hello.

Just to satisfy my curiosity, could you explain what you mean by "classification choice"?
I have never encountered this term in Excel before.

--
Retirement is nice! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
Hello Alhoc.

I'm asking you the same question as Daniel
Indeed, I'm not convinced that he is talking about the formula bar!

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Raymond PENTIER Posted messages 58205 Registration date   Status Contributor Last intervention   17 475
 
Ah!
Thank you very much, alhock, for your responsiveness and the quality of your response. Thank you very much.

This is an opportunity to remind Daniel, and everyone using Excel 365 and Word 365, that these online software are significantly different from the classic versions installed on computers, to the point that it became necessary for CCM to provide them with a specific forum, which is
Bureautique - Office 365
.

Best regards.

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
alhock
 
Good evening Raymond,

"Classification choice" is not related to Excel.
I have no idea how it got added; I guess it's an add-on to Office365.
It's about classifying documents: public, internal access, restricted access, secret (again, I'm roughly translating what I remember).
It's a bar that appears in all Office applications just below the menus (and below the formula bar in Excel).
It can be removed; there is an "X" on the right side of the bar for that, but I think that doing so makes the much more bothersome white space appear in the end.
I don't have my work PC with me right now; I'll try to provide a screenshot tomorrow if image insertion works here.
-1