|
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? |
Originally Posted by Teacher49
(Post 9039997)
Can I change the numbering of rows so that some rows at the top of a worksheet can be left numberless
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" |
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.
|
Originally Posted by boberonicus
(Post 9040351)
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
(Post 9040378)
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.
- 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! |
Originally Posted by Teacher49
(Post 9045081)
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! 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.) |
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:D |
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. |
Originally Posted by Efrem
(Post 9045606)
=row() - 3 Never heard of that function before. Thanks for that - it's a really elegant solution. ^ |
Originally Posted by Efrem
(Post 9045606)
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.
Originally Posted by Meerkat
(Post 9046019)
Never heard of that function before. Thanks for that - it's a really elegant solution. ^
|
Originally Posted by Meerkat
(Post 9046019)
Never heard of that function before. Thanks for that - it's a really elegant solution. ^
|
exactly
Originally Posted by RFTraveler
(Post 9045572)
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:D |
Originally Posted by RFTraveler
(Post 9045572)
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:D BTW, what's RFT ? |
|
|
Actually
Look at my 'handle' -- RFTraveler : RFT
Nothing more or less... RFT(raveler) :D |
| All times are GMT -6. The time now is 10:48 am. |
This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.