ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I delete a line at the edge of a column that's not formatte (https://www.excelbanter.com/excel-discussion-misc-queries/114075-how-do-i-delete-line-edge-column-thats-not-formatte.html)

Vera Lemon

How do I delete a line at the edge of a column that's not formatte
 
There's a line that shows up on my worksheet (& prints) that is not formatted
in either as a border or a drawing. I can't select it or delete it, even if
I delete the columns. Mysterious!

Jaleel

How do I delete a line at the edge of a column that's not formatte
 
Check File - Page Setup - Header/ Footer. If you want to deleter a line, you
have to deleter the rows, not the columns.

Jaleel

"Vera Lemon" wrote:

There's a line that shows up on my worksheet (& prints) that is not formatted
in either as a border or a drawing. I can't select it or delete it, even if
I delete the columns. Mysterious!


Vera Lemon

How do I delete a line at the edge of a column that's not form
 
It's not in the header/footer, it shows up in the middle of the worksheet as
if I had put a border along one edge of a column, but only in about 15 rows.
It is not a drawn object because I can't select it. It is not a formatted
border either, I have no idea how to get rid of this line...

"Jaleel" wrote:

Check File - Page Setup - Header/ Footer. If you want to deleter a line, you
have to deleter the rows, not the columns.

Jaleel

"Vera Lemon" wrote:

There's a line that shows up on my worksheet (& prints) that is not formatted
in either as a border or a drawing. I can't select it or delete it, even if
I delete the columns. Mysterious!



All times are GMT +1. The time now is 07:13 AM.

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