PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Hiding matrix headers

Reply

Hiding matrix headers

 
Thread Tools Rate Thread
Old 06-06-2007, 10:38 PM   #1
=?Utf-8?B?Q2xpZmYgTWNE?=
Guest
 
Posts: n/a
Default Hiding matrix headers


On my Excel 2003, the row and column headers are surpressed from printing. A
file on a Excel 2002 computer always prints the numeric row numbers. I'm
trying to help the users, non-profit org., to supress the row printouts. I
note that they don't print the alpha column header, so it must be in their
print setup but I can't find it.

I can force it by selecting the print area but I must first put in a dummy
row and column to select the area I wish to print. If I try to select from
the first row element it always includes the row and column header.
  Reply With Quote
Old 07-06-2007, 10:56 AM   #2
Roger Govier
Guest
 
Posts: n/a
Default Re: Hiding matrix headers

Hi Cliff

Try File>Page Setup>Sheet>uncheck Row and Column Headers

--
Regards

Roger Govier


"Cliff McD" <Cliff McD@discussions.microsoft.com> wrote in message
news:0FA355E8-61B8-4649-A733-B5746D3F248E@microsoft.com...
> On my Excel 2003, the row and column headers are surpressed from
> printing. A
> file on a Excel 2002 computer always prints the numeric row numbers.
> I'm
> trying to help the users, non-profit org., to supress the row
> printouts. I
> note that they don't print the alpha column header, so it must be in
> their
> print setup but I can't find it.
>
> I can force it by selecting the print area but I must first put in a
> dummy
> row and column to select the area I wish to print. If I try to select
> from
> the first row element it always includes the row and column header.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off