SOLVED

using named ranges

New Contributor

Hello everyone.

My problem is when I create a new named range, the name I choose for a specific area is shown in the worksheet in the exact area but I don't want it to appear. its hard to explain so there is a screen shot from it.

I would be really thankful if someone can help me to solve this problem.Screenshot (82).png 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
This happens when your zoom percentage is below 40%. Try zooming in to 40% or higher - it should automatically disappear.
I didn’t know that and I feel really stupid.
Thank you verh much.