FlyerTalk Forums - View Single Post - Excel Question
Thread: Excel Question
View Single Post
Old Jan 10, 2008 | 5:30 pm
  #4  
Teacher49
FlyerTalk Evangelist
20 Years on Site
 
Join Date: Jan 2004
Location: San Francisco
Programs: AA 3mm Plat
Posts: 10,068
Originally Posted by boberonicus
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"

Exactly the problem. Thanks.

Originally Posted by EricH
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.
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!
Teacher49 is offline