Can I re-number the row numbers?

G

Guest

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?
 
F

Frank Kabel

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
 
M

Marko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I don't want row 1 as the column headings 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Pivot Table Columns 2
Trying to add column headings to array formula 1
Function in Excel to count and list number of entries of text valuesin a row. 2
How can I reference a worksheet in a formula based on a cell value 2
moving row data to a colunm in sorted order 9
Printing a Different Row Heading Mid-way through a Spreadsheet 1

Top