ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Line appears - not border, not object, does not print - what is it (https://www.excelbanter.com/excel-discussion-misc-queries/173090-line-appears-not-border-not-object-does-not-print-what.html)

Licardi

Line appears - not border, not object, does not print - what is it
 
How can I get rid of a line in my spreadsheet that appears like a border, and
goes forever and ever? It doesn't print. It isn't an actual border, I've done
the "Edit/Go To/Special/Objects" and that isn't it. I tried format painter,
and it didn't work. I tried "Hide Gridlines" in tools and it still won't go
away. It's a vertical line that looks like a right border on Column B or a
left border on Column C (or both), and extends down as far as you scroll -
never stopping. PLEASE someone help me get rid of it!!

Kevin B

Line appears - not border, not object, does not print - what is it
 
Click WINDOW in the menu and if there's an option called UNFREEZE PANES click
it to remove. The border you speak of will no longer be present.
--
Kevin Backmann


"Licardi" wrote:

How can I get rid of a line in my spreadsheet that appears like a border, and
goes forever and ever? It doesn't print. It isn't an actual border, I've done
the "Edit/Go To/Special/Objects" and that isn't it. I tried format painter,
and it didn't work. I tried "Hide Gridlines" in tools and it still won't go
away. It's a vertical line that looks like a right border on Column B or a
left border on Column C (or both), and extends down as far as you scroll -
never stopping. PLEASE someone help me get rid of it!!


Licardi

Line appears - not border, not object, does not print - what i
 
This did work. Thank you!!!
--
~Laura~


"Kevin B" wrote:

Click WINDOW in the menu and if there's an option called UNFREEZE PANES click
it to remove. The border you speak of will no longer be present.
--
Kevin Backmann


"Licardi" wrote:

How can I get rid of a line in my spreadsheet that appears like a border, and
goes forever and ever? It doesn't print. It isn't an actual border, I've done
the "Edit/Go To/Special/Objects" and that isn't it. I tried format painter,
and it didn't work. I tried "Hide Gridlines" in tools and it still won't go
away. It's a vertical line that looks like a right border on Column B or a
left border on Column C (or both), and extends down as far as you scroll -
never stopping. PLEASE someone help me get rid of it!!



All times are GMT +1. The time now is 05:22 AM.

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