Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
scoostraw
 
Posts: n/a
Default How do I delete cell borders?


How do I format a worksheet so that the "borders" of each individual
cell are not shown? I just want a plain background.

Thanks.


--
scoostraw
------------------------------------------------------------------------
scoostraw's Profile: http://www.excelforum.com/member.php...o&userid=33640
View this thread: http://www.excelforum.com/showthread...hreadid=534126

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default How do I delete cell borders?

On the menu click Tools Options, and on the View tab de-select the
"Gridlines" checkbox.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How do I delete cell borders?

Assuming grid lines you can not use format unless you use fill colour but
you can do

toolsoptionsview and uncheck gridlines



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"scoostraw" wrote
in message ...

How do I format a worksheet so that the "borders" of each individual
cell are not shown? I just want a plain background.

Thanks.


--
scoostraw
------------------------------------------------------------------------
scoostraw's Profile:
http://www.excelforum.com/member.php...o&userid=33640
View this thread: http://www.excelforum.com/showthread...hreadid=534126



  #4   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default How do I delete cell borders?

Try Tools- Options - View
Delect Gridlines

"scoostraw" wrote:


How do I format a worksheet so that the "borders" of each individual
cell are not shown? I just want a plain background.

Thanks.


--
scoostraw
------------------------------------------------------------------------
scoostraw's Profile: http://www.excelforum.com/member.php...o&userid=33640
View this thread: http://www.excelforum.com/showthread...hreadid=534126


  #5   Report Post  
Posted to microsoft.public.excel.misc
scoostraw
 
Posts: n/a
Default How do I delete cell borders?


Excellent. Thank you. I knew the option was someplace but I couldn't
find it.


--
scoostraw
------------------------------------------------------------------------
scoostraw's Profile: http://www.excelforum.com/member.php...o&userid=33640
View this thread: http://www.excelforum.com/showthread...hreadid=534126



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
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Delete values from cell automatically ernie Excel Discussion (Misc queries) 5 February 15th 06 09:01 PM
How can I keep my cell borders permanent? karstens Excel Worksheet Functions 1 October 19th 05 05:18 PM
can't delete a cell content in excel Mark B New Users to Excel 3 May 6th 05 06:42 PM
Paste without including cell borders Heath Excel Worksheet Functions 1 December 29th 04 04:23 PM


All times are GMT +1. The time now is 09:38 PM.

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

About Us

"It's about Microsoft Excel"