|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
"Bob I" wrote:
>
>
> PDM wrote:
>
> >
> > "Tony Ruiz Sr" wrote:
> >
> >
> >>I just replied but forgot to check the "notify me of replies" box
> >>--
> >>Thanks for your time reading this and any help
> >>
> >>
> >>"Pma" wrote:
> >>
> >>
> >>>I am trying to restore the grid lines on a work sheet and can't get them
> >>>back. The tools/options/view button is not doing it. Any help?
> >
> >
> > I am having similar problem; none of the above has worked. I had different
> > rows with added background patterns. In trying to remove pattern in one row,
> > went back to cell format, patterns where first created pattern. No clear
> > pattern option is offered. Nearest thing is to choose white background,
> > which eliminates background patter, along with irretrievable grid lines.
> > Have tried all above suggestions, no help. Any suggestions? Thanks
>
> IF you put in ANY fill, then you MUST use Borders.
> Bob, Thanks for responding. However, someone above (I can't seem to locate him now or I'd give him the credit), but here is a solution that works!:
RESTORING GRID LINES IF LOST THROUGH OTHER OPERATIONS
(e.g., filing a row with a background pattern, and subsequently removing the
pattern, the grid lines will be gone as well – which you did not want to
happen):
Right click on some empty space in the Toolbars on top of the screen.
(Just to the right of the "?" that gives you the Help screens).
Choose "Customize"
Choose the Middle tab "Commands"*.
In the left pane(Categories*) choose "Forms*"
In the right pane choose “Toggle Grid.”
There's a button there that looks like a cheese grater.
Slide it out of the dialogue box onto the end of an existing toolbar on top
of the screen.
Close the Customize dialogue box.
Now when you click on the cheese grater the grid will toggle on and off for
the entire worksheet.
ONE PROBLEM:
After that operation, all other rows to which you’ve applied patterns will
also disappear!!
Therefore, before restoring the grid lines, make a special mark in the
remaining rows where you wish the patterns to remain, so that after you’ve
made them all disappear by restoring the grid lines to the row where you
wanted the pattern to disappear, you can go back and restore the background
patterns to those rows where you still need them.
It will also alter the alignment of all your cells, e.g., those that you
put in center of a cell, etc. Can quickly recognize these, and depressing
control key, pick them all and re-align pretty quickly.
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
Question
Answer
Notify me of replies