ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I set up a worksheet w/gridlines on top only? (https://www.excelbanter.com/new-users-excel/102806-how-do-i-set-up-worksheet-w-gridlines-top-only.html)

Carla

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.

Bernard Liengme

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.




Paul B

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.




NancyJeanne

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.


Gord Dibben

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.




All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com