Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Row numbers
I want to label and print row numbers for each row, however, I do not wish to
print column headings...can I disable the printing of the column headings? Is there possibly a function to run in a cell to provide it a number or something else? ----------------- Scott |
#2
|
|||
|
|||
You can only disable printing column *and* row headings.
<File <PageSetup <Sheet tab, Make sure "column & row headings" is *unchecked*. Then, you can number your first column to mirror the row numbers, and that will give the impression of displaying and printing the row headers. You could enter this formula in the first column: =ROW() Which will display the row number, even if rows might be subsequently deleted. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Scotts" wrote in message ... I want to label and print row numbers for each row, however, I do not wish to print column headings...can I disable the printing of the column headings? Is there possibly a function to run in a cell to provide it a number or something else? ----------------- Scott |
#3
|
|||
|
|||
Scott,
If you mean the "Row and column headings" option in Page setup, no. But you can turn that off, and put in your own row numbers. Put the first one in column A, then copy down with the fill handle holding Ctrl. Or put =ROW(), or =ROW()-1, etc., and copy that down. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Scotts" wrote in message ... I want to label and print row numbers for each row, however, I do not wish to print column headings...can I disable the printing of the column headings? Is there possibly a function to run in a cell to provide it a number or something else? ----------------- Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |