Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! : ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Print cell borders with special 'skin' | Excel Discussion (Misc queries) | |||
How can I keep my cell borders permanent? | Excel Worksheet Functions | |||
Cell borders and fill | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |