auto highlight and auto border

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that when i enter data in their respective cells, it
automatically fills it with a highlight and border line. I don't see any
conditional formatting nor is the track changes enabled. What's causing this?
 
Is this happening adjacent to cells with similar formatting? See if this
works: Tools-Options-Edit, uncheck "Extend list formats and formulas"
 
Thanks much Eric, that worked.

Eric said:
Is this happening adjacent to cells with similar formatting? See if this
works: Tools-Options-Edit, uncheck "Extend list formats and formulas"
Click to expand...
 
We have a user who also gets this behaviour (ie edit any cell -> border
appears around the cell, although cell format = no cell formatting.

Also saving + reopening = edits retained and cell 'border' no longer visible.
It's very similar to Track Changes, although as per el zoro's post, track
changes is not switched on.

NB this is in Excel 2000.

Any info on this would be gratefully received.
 
TechAuthorAndy's problem was that in Page Setup in the Sheet Tab
"Gridlines" was checked. Found this thread on google when I had the
same problem.

Mookey
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Product Suggestion: lock border and cell formatting only 2
Excel 2007, How do you keep orginal cell border after highlighting 1
shortcut for creating border in several highlighted cells 4
how to preserve PivotTable borders and colours on refresh? 1
Conditional formatting border thickness 2
Suddenly border of cell not highlighted when I click on it 1
Text Color Changes By Itself 3

Back
Top