Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 78
Default How do I set up a worksheet w/gridlines on top only?

I am setting up a spreadsheet w/ the top half using gridlines and the bottom
half blank to type in information I need concerning the subject. I don't
know how get rid of the gridlines after I'm done wi/the spreadsheet which is
the top half of the page.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default How do I set up a worksheet w/gridlines on top only?

You may be better off adding a textbox (View|Toolbars|Drawing) to add
documentation.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Carla" wrote in message
...
I am setting up a spreadsheet w/ the top half using gridlines and the
bottom
half blank to type in information I need concerning the subject. I don't
know how get rid of the gridlines after I'm done wi/the spreadsheet which
is
the top half of the page.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 709
Default How do I set up a worksheet w/gridlines on top only?

Gridlines are all or nothing, tools options, view gridlines, maybe you could
cut gridlines off and use borders in the cells that you want lines around

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Carla" wrote in message
...
I am setting up a spreadsheet w/ the top half using gridlines and the

bottom
half blank to type in information I need concerning the subject. I don't
know how get rid of the gridlines after I'm done wi/the spreadsheet which

is
the top half of the page.



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default How do I set up a worksheet w/gridlines on top only?

You could merge the cells below the gridline to make a text box. Or merge
several sets of cells depending on how you wnat the info below to appear.

Alternately: You can turn off the gridlines. Gridlines themselves don't
print. Format the upper half with borders to designate the lines you do want
to see.

"Carla" wrote:

I am setting up a spreadsheet w/ the top half using gridlines and the bottom
half blank to type in information I need concerning the subject. I don't
know how get rid of the gridlines after I'm done wi/the spreadsheet which is
the top half of the page.

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I set up a worksheet w/gridlines on top only?

Carla

Leave gridline turned on.

In the bottom part where you don't to see them, Format the cells to "White"
background.

The gridlines will disappear in those cells.


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 15:35:02 -0700, Carla
wrote:

I am setting up a spreadsheet w/ the top half using gridlines and the bottom
half blank to type in information I need concerning the subject. I don't
know how get rid of the gridlines after I'm done wi/the spreadsheet which is
the top half of the page.




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
Search one worksheet for values in another worksheet? ClayShooters Excel Discussion (Misc queries) 1 July 4th 06 03:01 PM
Worksheet not showing up in VBE Kevin Vaughn Excel Worksheet Functions 3 June 12th 06 03:22 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 02:24 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"