I want to add a list of labels in Row 1 from columns A to H. I want the next
row, which should be row 2, to actually appear as if it is row 1. When I
print my spreadsheet I am printing the column and row headings and I don't
want my labels to show as if they are in row 1. Is this possible?
Hi
you can't renumber the row numbers but you may put in column A a
sequential number. e.g.
A2: =1
A3: =A2+1
and copy this down for all rows
--
Regards
Frank Kabel
Frankfurt, Germany
"Val" <Val@discussions.microsoft.com> schrieb im Newsbeitrag
news:C7D502F1-63D7-49B2-8357-B26393DA45A5@microsoft.com...
> I want to add a list of labels in Row 1 from columns A to H. I want
the next
> row, which should be row 2, to actually appear as if it is row 1.
When I
> print my spreadsheet I am printing the column and row headings and I
don't
> want my labels to show as if they are in row 1. Is this possible?
Under Filem menu, Set "Print Area" by hilighting the rows/columns to only
include that portion of the worksheet you actually want to print.
Marko
"Val" <Val@discussions.microsoft.com> wrote in message
news:C7D502F1-63D7-49B2-8357-B26393DA45A5@microsoft.com...
>I want to add a list of labels in Row 1 from columns A to H. I want the
>next
> row, which should be row 2, to actually appear as if it is row 1. When I
> print my spreadsheet I am printing the column and row headings and I don't
> want my labels to show as if they are in row 1. Is this possible?
Question
Reply
Top
Answer
Notify me of replies