altering numbers in left hand column

  • Thread starter Thread starter Headtheball
  • Start date Start date
H

Headtheball

how do i change the numbers in the left hand column of a worksheet so that
the number one is below my worksheet headings

ie

description cost date purchased date sold
1
2
3
4
5
 
hi,
If i understand you correctly, you are talking about the
defalut xl row numbers and not a column of numbers you
input.
you can not move or change this numbers. nor can you
change the column letters to your own headers.
you can change the column letters to numbers by
Tools>options>General tab>check use R1C1 reference style.
xl uses these row number and column letters(or numbers) as
it's own reference. they cannot be altered.
best bet is to add a column of your own numbers.
regards
 

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

Back
Top