| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gridlines
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
On Tuesday, October 9, 2012 9:54:21 AM UTC-7, Stephen Wolstenholme wrote:
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
On Tuesday, October 9, 2012 11:24:29 AM UTC-7, (unknown) wrote:
On Tuesday, October 9, 2012 9:54:21 AM UTC-7, Stephen Wolstenholme wrote: 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 I should have said "select the area you want the grid lines hidden" then color white. H'wd |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines
Stephen Wolstenholme presented the following explanation :
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gridlines | Excel Discussion (Misc queries) | |||
| Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
| not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
![Stephen Wolstenholme[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
