ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Range names are displaying in big blue letters on sheet (https://www.excelbanter.com/excel-discussion-misc-queries/53204-range-names-displaying-big-blue-letters-sheet.html)

Katie

Range names are displaying in big blue letters on sheet
 
Does anyone know how to turn off this display?
It seems so basic, but I can't find it.

Debra Dalgleish

Range names are displaying in big blue letters on sheet
 
The range names will appear if you set the zoom level below 40%. I don't
know of any way to turn this feature off.

Katie wrote:
Does anyone know how to turn off this display?
It seems so basic, but I can't find it.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Gord Dibben

Range names are displaying in big blue letters on sheet
 
Katie

Are you sure it is range names and not page numbers?

Try ViewNormal

Other than that, I'm at a loss without more detail.

What do the range names look like other than big and blue?

Give us an example of the text you see.


Gord Dibben Excel MVP

On Tue, 1 Nov 2005 13:59:01 -0800, "Katie"
wrote:

Does anyone know how to turn off this display?
It seems so basic, but I can't find it.



Katie

Range names are displaying in big blue letters on sheet
 
Thanks for responding. I already checked the page break preview (made sure
it was in normal view). I tested it to make sure it was range names by
adding a new range.

It is indeed what Debra wrote. If anyone knows a way to turn off range name
display for screens zoomed small, please let me know.

"Gord Dibben" wrote:

Katie

Are you sure it is range names and not page numbers?

Try ViewNormal

Other than that, I'm at a loss without more detail.

What do the range names look like other than big and blue?

Give us an example of the text you see.


Gord Dibben Excel MVP

On Tue, 1 Nov 2005 13:59:01 -0800, "Katie"
wrote:

Does anyone know how to turn off this display?
It seems so basic, but I can't find it.




Katie

Range names are displaying in big blue letters on sheet
 
Thanks, that is exactly what is happening! If anyone knows of a way to turn
this feature off (showing range names for small zooms), please let me know!

Katie

"Debra Dalgleish" wrote:

The range names will appear if you set the zoom level below 40%. I don't
know of any way to turn this feature off.

Katie wrote:
Does anyone know how to turn off this display?
It seems so basic, but I can't find it.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com