ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/136112-formatting.html)

tj

Formatting
 
I inherited a spreadsheet that has a vertical "line" that runs a long the
edge of a group of cells. I cannot remove the "line". It is not a border,
nor is it a drawn line. Clearing formats and deleting the contents of the
cells did not work. Any suggestions?

tom

Formatting
 
TJ,
It may be that the panes are "frozen". Highlight the column of cells in the
column just to the right of the line that you see. Go to WINDOW UNFREEZE
PANES and see if that removes the line.

Cheers,
Tom

"TJ" wrote:

I inherited a spreadsheet that has a vertical "line" that runs a long the
edge of a group of cells. I cannot remove the "line". It is not a border,
nor is it a drawn line. Clearing formats and deleting the contents of the
cells did not work. Any suggestions?


tj

Formatting
 
Thank you, but that did not work. The panes aren't frozen. The line is
about 10 rows tall and does not touch the top or bottom of the spreadsheet.



"Tom" wrote:

TJ,
It may be that the panes are "frozen". Highlight the column of cells in the
column just to the right of the line that you see. Go to WINDOW UNFREEZE
PANES and see if that removes the line.

Cheers,
Tom

"TJ" wrote:

I inherited a spreadsheet that has a vertical "line" that runs a long the
edge of a group of cells. I cannot remove the "line". It is not a border,
nor is it a drawn line. Clearing formats and deleting the contents of the
cells did not work. Any suggestions?



All times are GMT +1. The time now is 08:23 PM.

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