How do I "grey out" a row in excel

I am looking for a way to "Grey Out" a row in an Excel tracking chart I am
using. I did not want to use the text and fill colors if I did not need to.

Thanx !!

Maybe you could use Format|conditional formatting and change the color of the
row based on some criteria.

Or maybe you could lock those cells on that row (and unlock the other cells)
(format|cells|protection tab), then protect the worksheet.

But I'm not sure what "grey out" means...

KLJ wrote:
>
> I am looking for a way to "Grey Out" a row in an Excel tracking chart I am
> using. I did not want to use the text and fill colors if I did not need to.
>
> Thanx !!

--

Dave Peterson

"Dave Peterson" wrote:

> Maybe you could use Format|conditional formatting and change the color of the
> row based on some criteria.
>
> Or maybe you could lock those cells on that row (and unlock the other cells)
> (format|cells|protection tab), then protect the worksheet.
>
> But I'm not sure what "grey out" means...
>
> KLJ wrote:
> >
> > I am looking for a way to "Grey Out" a row in an Excel tracking chart I am
> > using. I did not want to use the text and fill colors if I did not need to.
> >
> > Thanx !!
>
> --
>
> Dave Peterson
>

Thanks Dave.
I am trying to acheive an effect similar to what Microsoft does
when"buttons" are not available on a toolbar.

Kevin

If you're trying to get it so that it can't be selected, then you can use the
sheet protection.

I don't know how knowledgeable you are, so some / all of this may be old hat
to you, but maybe it'll help and maybe it'll help someone else.


When you start with a new worksheet, each cell is by design locked. But,
the locking doesn't do anything unless the sheet is protected:
TOOLS >> PROTECTION >> PROTECT SHEET

One of the basic aspects is that you can make it so locked cells cannot e
selected. [you can even gray the cells out with shading first, if you like].
But, when you do that, those fields will be unselectable. Most folks would
suggest to first change the bulk of the cells you're going to use to
unlocked, and just lock the cells that you want to gray out.

hope this helps, and I hope I didn't yammer too much.

This will bring up a menu for you to check on what you want the locked cells
to do / what behaviors they should exhibit

"KLJ" wrote:

>
>
> "Dave Peterson" wrote:
>
> > Maybe you could use Format|conditional formatting and change the color of the
> > row based on some criteria.
> >
> > Or maybe you could lock those cells on that row (and unlock the other cells)
> > (format|cells|protection tab), then protect the worksheet.
> >
> > But I'm not sure what "grey out" means...
> >
> > KLJ wrote:
> > >
> > > I am looking for a way to "Grey Out" a row in an Excel tracking chart I am
> > > using. I did not want to use the text and fill colors if I did not need to.
> > >
> > > Thanx !!
> >
> > --
> >
> > Dave Peterson
> >
>
> Thanks Dave.
> I am trying to acheive an effect similar to what Microsoft does
> when"buttons" are not available on a toolbar.
>
> Kevin

why not hide the row
"KLJ" <KLJ@discussions.microsoft.com> wrote in message
news:61797FF3-7C60-4D8F-BD41-0D21FA372159@microsoft.com...
> I am looking for a way to "Grey Out" a row in an Excel tracking chart I
am
> using. I did not want to use the text and fill colors if I did not need
to.
>
> Thanx !!

"R.VENKATARAMAN" wrote:

> why not hide the row
> "KLJ" <KLJ@discussions.microsoft.com> wrote in message
> news:61797FF3-7C60-4D8F-BD41-0D21FA372159@microsoft.com...
> > I am looking for a way to "Grey Out" a row in an Excel tracking chart I
> am
> > using. I did not want to use the text and fill colors if I did not need
> to.
> >
> > Thanx !!
>
>
> Thank you all for the help,I am using this as atracking metod and as an item is complete I want to "gery out ,but still be able to show the completed item. I would normally use "project" but the community does not have this option and I did not want to have to create image of list.

"MatthewTap" wrote:

> If you're trying to get it so that it can't be selected, then you can use the
> sheet protection.
>
> I don't know how knowledgeable you are, so some / all of this may be old hat
> to you, but maybe it'll help and maybe it'll help someone else.
>
>
> When you start with a new worksheet, each cell is by design locked. But,
> the locking doesn't do anything unless the sheet is protected:
> TOOLS >> PROTECTION >> PROTECT SHEET
>
> One of the basic aspects is that you can make it so locked cells cannot e
> selected. [you can even gray the cells out with shading first, if you like].
> But, when you do that, those fields will be unselectable. Most folks would
> suggest to first change the bulk of the cells you're going to use to
> unlocked, and just lock the cells that you want to gray out.
>
> hope this helps, and I hope I didn't yammer too much.
>
> This will bring up a menu for you to check on what you want the locked cells
> to do / what behaviors they should exhibit
>
> "KLJ" wrote:
>
> >
> >
> > "Dave Peterson" wrote:
> >
> > > Maybe you could use Format|conditional formatting and change the color of the
> > > row based on some criteria.
> > >
> > > Or maybe you could lock those cells on that row (and unlock the other cells)
> > > (format|cells|protection tab), then protect the worksheet.
> > >
> > > But I'm not sure what "grey out" means...
> > >
> > > KLJ wrote:
> > > >
> > > > I am looking for a way to "Grey Out" a row in an Excel tracking chart I am
> > > > using. I did not want to use the text and fill colors if I did not need to.
> > > >
> > > > Thanx !!
> > >
> > > --
> > >
> > > Dave Peterson
> > >
> >
> > Thanks Dave.
> > I am trying to acheive an effect similar to what Microsoft does
> > when"buttons" are not available on a toolbar.
> >
> > Kevin



No yammering at allsir ;-)
,I am using this as atracking metod and as an item is complete I want to
"gery out ,but still be able to show the completed item. I would normally use
"project" but the community does not have this option and I did not want to
have to create image of list.