probably simple but I'm a novice. building a worksheet to list people, pay
rates and hours worked etc. the header needs to have fill in areas that
change with the job so I entered them in the rows rather than in a proper
header. what I want to do is get rid of gridlines in the first 6 rows but
leave them intact on the rest of the document. I see templates that this was
done somehow. what am I doing wrong?

Select the cells and then pull-down:

Format Cells... Patterns Color and check white
--
Gary's Student


"joe" wrote:

probably simple but I'm a novice. building a worksheet to list people, pay
rates and hours worked etc. the header needs to have fill in areas that
change with the job so I entered them in the rows rather than in a proper
header. what I want to do is get rid of gridlines in the first 6 rows but
leave them intact on the rest of the document. I see templates that this was
done somehow. what am I doing wrong?

Hi,

I don't want to hijack this thread, but is the reverse possible? I want
gridlines in the section I'm working with, but would like them removed
from the rest of the sheet!

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488497

Not a hijack at all. Select all cells (upper left corner and format
background to white.
Then go back and re-format the "gridded" cells back to no-color background.

The edges may be a problem - you may need to outline them.
--
Gary''s Student


"mevetts" wrote:


Hi,

I don't want to hijack this thread, but is the reverse possible? I want
gridlines in the section I'm working with, but would like them removed
from the rest of the sheet!

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488497

Rather than coloring the cells white to look like normal background and
wiping out gridlines. I think what you really want to do is put your cells
back to automatic pattern color, eliminate gridlines, and use borders
around the cells you want to have borders. Then you will see the same
thing in display and in print.
http://www.mvps.org/dmcritchie/excel/gridline.htm

You might also view the formatting tricks flash file at
http://www.datapigtechnologies.com/ExcelMain.html


if you can't view using Firefox see
http://www.mvps.org/dmcritchie/excel/firefox.htm#flash
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gary''s Student" wrote in message
...
Not a hijack at all. Select all cells (upper left corner and format
background to white.
Then go back and re-format the "gridded" cells back to no-color background.

The edges may be a problem - you may need to outline them.
--
Gary''s Student


"mevetts" wrote:


Hi,

I don't want to hijack this thread, but is the reverse possible? I want
gridlines in the section I'm working with, but would like them removed
from the rest of the sheet!

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488497

Thanks for the help, really useful stuff.

Cheers,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488497

Many thanks, that is more what my poorly worded question was asking for so
that I can print as displayed. Joe

"David McRitchie" wrote:

Rather than coloring the cells white to look like normal background and
wiping out gridlines. I think what you really want to do is put your cells
back to automatic pattern color, eliminate gridlines, and use borders
around the cells you want to have borders. Then you will see the same
thing in display and in print.
http://www.mvps.org/dmcritchie/excel/gridline.htm

You might also view the formatting tricks flash file at
http://www.datapigtechnologies.com/ExcelMain.html


if you can't view using Firefox see
http://www.mvps.org/dmcritchie/excel/firefox.htm#flash
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gary''s Student" wrote in message
...
Not a hijack at all. Select all cells (upper left corner and format
background to white.
Then go back and re-format the "gridded" cells back to no-color background.

The edges may be a problem - you may need to outline them.
--
Gary''s Student


"mevetts" wrote:


Hi,

I don't want to hijack this thread, but is the reverse possible? I want
gridlines in the section I'm working with, but would like them removed
from the rest of the sheet!

Many thanks,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=488497