Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
marmur1
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Zygan
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Print cell borders with special 'skin' DavieM Excel Discussion (Misc queries) 0 March 25th 06 10:52 PM
How can I keep my cell borders permanent? karstens Excel Worksheet Functions 1 October 19th 05 05:18 PM
Cell borders and fill Marietta Excel Worksheet Functions 4 August 6th 05 04:29 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"