ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell borders when converting 123 doc to xls (https://www.excelbanter.com/excel-discussion-misc-queries/91742-cell-borders-when-converting-123-doc-xls.html)

marmur1

Cell borders when converting 123 doc to xls
 
This may be the easiest question ever, but I was hoping that one of you might
be able to help. I use Excel all the time without problems, but am taking
over for someone who uses Lotus exclusively. I was able to save her
spreadsheets into xls, but there are multiple cells in each worksheet that
have borders that print out, and I can't get rid of them for the life of me.

I'd like to have the sheet have no cell borders at all, so I've tried
selecting the sheet (as well as just the frustrating cells) and choose no
border, but that didn't work. I unchecked the Gridlines option under
ToolsOptionsViewGridlines, and that makes it so they're not visible on the
screen, but they still print out.

Any other suggestions would be VERY MUCH appreciated! : )

Zygan

Cell borders when converting 123 doc to xls
 

This may or may not help but i can see to options
A - Copy all cells and when you past right click and paste specials -
all except borders.
B - Try looking under FORMAT - Conditional Formatting - Delete the
formatting

Hope this helps


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547689



All times are GMT +1. The time now is 12:29 AM.

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