Excel Question
Jan 10, 2008 | 12:39 am
#1
Original Poster
FlyerTalk Evangelist
Join Date: Jan 2004
Location: San Francisco
Programs: AA 3mm Plat
Posts: 10,068
Excel Question
I am far from a power user of Excel and have a basic quesiton:
Can I change the numbering of rows so that some rows at the top of a worksheet can be left numberless and so that numbering can begin a few rows down.
such as
Title (in what is numbered row 1 by default)
subtitle ( in what is number row 2 ..)
1. for first item
2. for second, and so on?
Can I change the numbering of rows so that some rows at the top of a worksheet can be left numberless and so that numbering can begin a few rows down.
such as
Title (in what is numbered row 1 by default)
subtitle ( in what is number row 2 ..)
1. for first item
2. for second, and so on?
Jan 10, 2008 | 3:12 am
#2
Join Date: Aug 2006
Location: San Jose CA
Posts: 1,100
In general, you do not want to use the numbers or letters to refer to actual things. For example, if you have 10 students and you want to number them 1-10, do that in a separate dedicated row or column titled "Student Number"
Last edited by boberonicus; Jan 10, 2008 at 3:21 am
Jan 10, 2008 | 3:22 am
#3
Join Date: Jan 2002
Location: Washington, DC, USA
Programs: UA MM, MB LifeTit
Posts: 1,866
You can just create a column of numbers for your table. If you want numbering to begin on the spreadsheet's fourth row, enter a 1 in cell A4 and then +A4+1 in cell A5, and so on.
Jan 10, 2008 | 5:30 pm
#4
Original Poster
FlyerTalk Evangelist
Join Date: Jan 2004
Location: San Francisco
Programs: AA 3mm Plat
Posts: 10,068
No, you cannot rename either the columns (A,B,C) or the rows (1,2,3). However, you can printout the spreadsheet without any columns or row headings, if that's the issue.
In general, you do not want to use the numbers or letters to refer to actual things. For example, if you have 10 students and you want to number them 1-10, do that in a separate dedicated row or column titled "Student Number"
In general, you do not want to use the numbers or letters to refer to actual things. For example, if you have 10 students and you want to number them 1-10, do that in a separate dedicated row or column titled "Student Number"
Exactly the problem. Thanks.
- next row will be labeled with a number one higher than the preceding row AND
- perhaps more importantly, if I insert or delete a row for a new or departing student, can the rows in column A be made to readjust?
If this is too much to explain, not to worry and thanks for your help thus far!
Jan 10, 2008 | 5:42 pm
#5
Join Date: Jul 2006
Location: ATL
Programs: DL, AA
Posts: 6,033
EricH, I am probably being dense, but ... if I enter this longer string of characters in each row in column A, does it ever become automatic in the sense that:
- next row will be labeled with a number one higher than the preceding row AND
- perhaps more importantly, if I insert or delete a row for a new or departing student, can the rows in column A be made to readjust?
If this is too much to explain, not to worry and thanks for your help thus far!
- next row will be labeled with a number one higher than the preceding row AND
- perhaps more importantly, if I insert or delete a row for a new or departing student, can the rows in column A be made to readjust?
If this is too much to explain, not to worry and thanks for your help thus far!
If you insert or delete a row, your numbering will be thrown off... but easily repaired. Just copy the equation from the row above the change & copy it down to the row below the change. (If you add a new row 20, copy A19 into A20 & A21. If you delete row 31, copy A30 to the new A31.)
Jan 10, 2008 | 7:01 pm
#6
Join Date: Dec 2005
Location: PDX...most of the time.
Programs: F9 Ascent, UA, AA, AS, ICH PA, Hertz PC.....
Posts: 190
Or...
Simply enter 1 in A4, 2 in A5, 3 in A6...then select those 3 cells (click in A4, click while holding shift in A6). Then, look at the lower right corner of A6 - there's a little square there. Click and hold on the square, then drag down as far as you like.
RFT
RFT
Jan 10, 2008 | 7:10 pm
#7
FlyerTalk Evangelist
Join Date: May 1998
Location: Massachusetts, USA; AA 2.996MM & Plat Pro, DL 1MM, GM & Flying Colonel
Posts: 25,036
Instead of the formula that calculates from the row above, or dragging the first few numbers to fill in the rest (which will populate those cells with constants, which may be a problem if you delete a row) you can also use this formula in each cell of the area you want to contain numbers:
=row() - 3
The row() function equals the row number of wherever it is: if it's anywhere in row 4 it equals 4, anywhere in row 5 it equals 5, and so on. It must be followed by () for arguments even though it doesn't take any. Subtract 3 if you want row 4 to contain the number 1; adjust this for however many un-numbered rows you have at the top.
=row() - 3
The row() function equals the row number of wherever it is: if it's anywhere in row 4 it equals 4, anywhere in row 5 it equals 5, and so on. It must be followed by () for arguments even though it doesn't take any. Subtract 3 if you want row 4 to contain the number 1; adjust this for however many un-numbered rows you have at the top.
Jan 10, 2008 | 9:04 pm
#9
Original Poster
FlyerTalk Evangelist
Join Date: Jan 2004
Location: San Francisco
Programs: AA 3mm Plat
Posts: 10,068
Instead of the formula that calculates from the row above, or dragging the first few numbers to fill in the rest (which will populate those cells with constants, which may be a problem if you delete a row) you can also use this formula in each cell of the area you want to contain numbers:
=row() - 3
The row() function equals the row number of wherever it is: if it's anywhere in row 4 it equals 4, anywhere in row 5 it equals 5, and so on. It must be followed by () for arguments even though it doesn't take any. Subtract 3 if you want row 4 to contain the number 1; adjust this for however many un-numbered rows you have at the top.
=row() - 3
The row() function equals the row number of wherever it is: if it's anywhere in row 4 it equals 4, anywhere in row 5 it equals 5, and so on. It must be followed by () for arguments even though it doesn't take any. Subtract 3 if you want row 4 to contain the number 1; adjust this for however many un-numbered rows you have at the top.
Jan 11, 2008 | 6:50 am
#11
Join Date: Feb 2000
Location: Menlo Park, CA, USA
Programs: UA 1MM 0P, AA, DL, *wood, Lifetime FPC Plat., IHG, HHD
Posts: 7,174
exactly
exactly, no formula needed. Works with many data sets, dates, even primes!
Jan 11, 2008 | 2:32 pm
#12
Original Poster
FlyerTalk Evangelist
Join Date: Jan 2004
Location: San Francisco
Programs: AA 3mm Plat
Posts: 10,068
BTW, what's RFT ?
