Hi
I joined your group after searching the archives for help and could not
find anything. I have an Excel spread sheet that is 15 columns and 148
rows. Cells G18:G36, I18:I36 and G54:G60 have a blue border around
them.
I can see the border when I am viewing the spreadsheet at 25% but not
50% or 100%. I can also see it in the print preview and on paper. I
want only horizontal lines, not vertical lines. The borders function
does not help. I erased each border individually and I also changed
the border to white, but it has not effect. Anyone have a suggestion?
Thanks
librarygirlTry this on a copy of your data...........the lines may not be boarders, but
may be Drawing Objects.......slowly approach one of the quot;linesquot;, and if the
cursor changes shape, right-click gt; cut........if it was a drawing object, it
will now be gone.
Vaya con Dios,
Chuck, CABGx3
quot;librarygirlquot; wrote:
gt; Hi
gt;
gt; I joined your group after searching the archives for help and could not
gt; find anything. I have an Excel spread sheet that is 15 columns and 148
gt; rows. Cells G18:G36, I18:I36 and G54:G60 have a blue border around
gt; them.
gt;
gt; I can see the border when I am viewing the spreadsheet at 25% but not
gt; 50% or 100%. I can also see it in the print preview and on paper. I
gt; want only horizontal lines, not vertical lines. The borders function
gt; does not help. I erased each border individually and I also changed
gt; the border to white, but it has not effect. Anyone have a suggestion?
gt;
gt; Thanks
gt;
gt; librarygirl
gt;
gt;
Thanks for the advice, but the cursor does not change.Try selecting all the cells in one of the ranges and using
Edit-gt;Clear-gt;Formats to try to get rid of the borders. You'll lose ALL
formatting, but then you can start fresh amp; format the cells the way you want.quot;librarygirlquot; wrote:
gt; Thanks for the advice, but the cursor does not change.
gt;
gt;
Hi everyone,
I received some advice from another source. Basically it seems my
lines were representing a text box. I copied the lines to a new
worksheet. Deleted them from the original worksheet (note just clear
contents), went back to the new worksheet, copied the cells, and
inserted the copied cells in my original worksheet the lines were gone.
Thanks
- Nov 18 Sat 2006 20:10
Lines around cells
close
全站熱搜
留言列表
發表留言