![]() |
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! : ) |
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