I have a sign up sheet and the Row line begins with the #3!!??

G

Guest

I am going crazy trying to figure out how to make the list start with the #1.
Row 1 is the Company Name, Row 2 has the Column titles . I don't want Comany
Name or headers to have a line #, so I can have the first customer sign up on
Line 1............PLEASE help.
 
G

Gord Dibben

In A3 enter =ROW()-2

Drag/copy down.

Tools>Options>View. Uncheck Row and Column Headers.


Gord Dibben MS Excel MVP
 
G

Guest

you can't change the row numbers in EXCEL. but you can make the first column
be any list you want and not show the row numbers by going to
tools-options-view and deslecting row & column headers
 

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

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
Expand and Shrink Rows and columns to hide information. 1
Data from Rows into columns 7
Excel Is this possible?? 3
VBA to automatically cut, paste entire row based on date input and delete row 0
How To Combine Several Rows of Data into 1 Row of Data 3
Pivot tables 2 row labels 4
1 and 2 prior to beginning of Row headers 4

Top