Hide Row Numbers Only

How can I Hide the Grey Row Numbers ONLY in a SpreadSheet Please.

All the Best.
Paul

Hello Paul,

Excel gives you an all or nothing choice with the column and row headers. You can't display one or the other. Either you display them or you don't.

Sincerely,
Leith Ross

Paul,

Not without hiding column headers as well.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Black" <[email protected]> wrote in message
news:[email protected]...
> How can I Hide the Grey Row Numbers ONLY in a SpreadSheet Please.
>
> All the Best.
> Paul
>

Thanks Bob & Leith for the Replies.
I did do a Search and could NOT Find Anything Relevant.
Is there a Way then to Change the Font Colour of the Numbers to the
Same as the Background Colour.

Thanks in Advance.
All the Best.
Paul

Leith Ross wrote:
> Hello Paul,
>
> Excel gives you an all or nothing choice with the column and row
> headers. You can't display one or the other. Either you display them or
> you don't.
>
> Sincerely,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=480444

I believe that that would have to be a windows setting and would affect a
lot of other stuff.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Black" <[email protected]> wrote in message
news:[email protected]...
> Thanks Bob & Leith for the Replies.
> I did do a Search and could NOT Find Anything Relevant.
> Is there a Way then to Change the Font Colour of the Numbers to the
> Same as the Background Colour.
>
> Thanks in Advance.
> All the Best.
> Paul
>
> Leith Ross wrote:
> > Hello Paul,
> >
> > Excel gives you an all or nothing choice with the column and row
> > headers. You can't display one or the other. Either you display them or
> > you don't.
> >
> > Sincerely,
> > Leith Ross
> >
> >
> > --
> > Leith Ross
> > ------------------------------------------------------------------------
> > Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
> > View this thread:
http://www.excelforum.com/showthread...hreadid=480444
>

Hi Paul,
again No. The fonts and background are determined in
your control panel settings, display, appearance
and you would wipe out menus in all of your applications.

If you want to complicate things you can hide both.
Tools, Options, View, Row & Column Headings
then place a key of your columns in the top row.

Display and printing are two different options, by the way.
File, Page Setup, Sheet, row & Column Headings
and again it is both or nothing.

Why are so determined to make Excel not work and look like
Excel -- why is it important to make the row numbers unintelligible.



"Paul Black" <[email protected]> wrote in message news:[email protected]...
> Thanks Bob & Leith for the Replies.
> I did do a Search and could NOT Find Anything Relevant.
> Is there a Way then to Change the Font Colour of the Numbers to the
> Same as the Background Colour.
>
> Thanks in Advance.
> All the Best.
> Paul
>
> Leith Ross wrote:
> > Hello Paul,
> >
> > Excel gives you an all or nothing choice with the column and row
> > headers. You can't display one or the other. Either you display them or
> > you don't.
> >
> > Sincerely,
> > Leith Ross
> >
> >
> > --
> > Leith Ross
> > ------------------------------------------------------------------------
> > Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
> > View this thread: http://www.excelforum.com/showthread...hreadid=480444
>

Maybe as a workaround you can hide both column and row labels, then format
the top row to look like the column labels.

--
Regards,
Tom Ogilvy

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> I believe that that would have to be a windows setting and would affect a
> lot of other stuff.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Paul Black" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks Bob & Leith for the Replies.
> > I did do a Search and could NOT Find Anything Relevant.
> > Is there a Way then to Change the Font Colour of the Numbers to the
> > Same as the Background Colour.
> >
> > Thanks in Advance.
> > All the Best.
> > Paul
> >
> > Leith Ross wrote:
> > > Hello Paul,
> > >
> > > Excel gives you an all or nothing choice with the column and row
> > > headers. You can't display one or the other. Either you display them
or
> > > you don't.
> > >
> > > Sincerely,
> > > Leith Ross
> > >
> > >
> > > --
> > > Leith Ross
> >
> ------------------------------------------------------------------------
> > > Leith Ross's Profile:
> http://www.excelforum.com/member.php...o&userid=18465
> > > View this thread:
> http://www.excelforum.com/showthread...hreadid=480444
> >
>
>

Bob,
Thanks for the Reply.

David,
Thanks for the Reply
The Reason is that there are Numbers in Column "A". These Numbers are
NOT Sequential, so when People Input Data there are Usually a Number of
ERRORS because they have Input the Data in the Row Number Instead of
the Column "A" Number.

Thanks in Advance.
All the Best.
Paul

Thanks for the Reply Tom.
I am going to go with your Suggestion.

All the Best.
Paul