S
Stephen Wolstenholme
How can I have grid lines in just part of a worksheet? I don't want
them on over all of the worksheet.
Steve
them on over all of the worksheet.
Steve
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
lhkittle
How can I have grid lines in just part of a worksheet? I don't want
them on over all of the worksheet.
Steve
--
EasyNN-plus. Neural Networks plus. http://www.easynn.com
SwingNN. Forecast with Neural Networks. http://www.swingnn.com
JustNN. Just Neural Networks. http://www.justnn.com
Hi Steve,
One way...
Home Tab > Font > Fill color (paint bucket) > Theme colors > White.
HTH
Regards,
Howard
L
lhkittle
Hi Steve,
One way...
Home Tab > Font > Fill color (paint bucket) > Theme colors > White.
HTH
Regards,
Howard
I should have said "select the area you want the grid lines hidden" then color white.
H'wd
G
GS
Stephen Wolstenholme presented the following explanation :
You can turn Gridlines off and use dotted borders to 'simulate' the
gridlines where you want.
This can be managed via ConditionalFormatting for a series of cells
based on input into any specified cell. For example, if you want
simulated gridlines in B10:H10 when a value is entered in B10, select
the range and specify the following formula as the CF criteria:
=LEN($B10)
HTH
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
How can I have grid lines in just part of a worksheet? I don't want
them on over all of the worksheet.
Steve
You can turn Gridlines off and use dotted borders to 'simulate' the
gridlines where you want.
This can be managed via ConditionalFormatting for a series of cells
based on input into any specified cell. For example, if you want
simulated gridlines in B10:H10 when a value is entered in B10, select
the range and specify the following formula as the CF criteria:
=LEN($B10)
HTH
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion