Line in Ms Excel that cannot be removed or hidden - please assist?

Candystore

Candystore

Expert Member
Joined
Jan 23, 2009
Messages
2,992
Reaction score
943
I have a line (cell border?) in an Excel document that cannot removed, no matter what I do.

I tried selecting "no border" and tried clearing formatting, to no avail.

Please help.
 
Maybe you can give us a screen shot so we can see... Be sure to include the the row and column headers, i.e. A, B, C and 1, 2, 3
 
Candystore said:
I have a line (cell border?) in an Excel document that cannot removed, no matter what I do.

I tried selecting "no border" and tried clearing formatting, to no avail.

Please help.
Click to expand...

Is your Freeze Pane activated? (It makes lines that sometimes look like borders)
 
If these are the 'borders' you are describing - as indicated by the arrows in the screenshot below - which you cannot get rid of, despite all your attempts to 'remove borders' or clear formatting, then this is the reason why you cannot delete them.

20181120 Excel borders.jpg

These are 'page break guidelines' - they visually indicate the vertical & horizontal page separation, where content to the right or below the dashed lines would then flow onto another page.

These 'page break guidelines' only appear once you have gone into the print preview mode - 'File, Print' or (Ctrl+P) - and have then returned to the 'normal' spreadsheet view once again for data entry or editing.

The only way to remove these 'guidelines' is to save your spreadsheet, close it & then re-open it - but do NOT go back to Print Preview again, or they will then return once more and you will have to repeat this procedure to make them disappear again.
 
Last edited:
Ho3n3r said:
Not true... And then it doesn't come back again either for that specific spreadsheet.

View attachment 581056
Click to expand...

I know about this option setting - but that only works individually for each separate worksheet's 'display options' and as far as I can recall, there isn't a system-wide Excel option to turn the page break indicators off permanently for the various sheets in every workbook you open.
 
alphabyte said:
Don't you just love it when a number of people jump in to help, and then the OP can't be bothered to let us know if his problem has been resolved? :rolleyes:
Click to expand...

Well kind of clear that it was, remember its 2018 and people don't have manners anymore, you assist them and they just f off
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X