Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto number rows when printing
Is there a way to auto number the rows on a printout? I have a column in my
spreadsheet that is the count column (increases by 1 in each row to show how many "records" there are). When I am working with the filters or sorting, it obviously moves the count column around too (I know that I can sort without that column). I would like to print rosters of various subgroups from my spreadsheet using various filters and have Excel number my rows on the printout in consecutive order. Is it possible?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto number rows when printing
for you count column
=subtotal(3,$A$2:A2) then drag fill down the column Make sure that the column it counts is one that will have data in every row. -- Regards, Tom Ogilvy "Eduman" wrote: Is there a way to auto number the rows on a printout? I have a column in my spreadsheet that is the count column (increases by 1 in each row to show how many "records" there are). When I am working with the filters or sorting, it obviously moves the count column around too (I know that I can sort without that column). I would like to print rosters of various subgroups from my spreadsheet using various filters and have Excel number my rows on the printout in consecutive order. Is it possible?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto number rows when printing
Thanks Tom. That worked great. Can you explain what the coding in the
parenthesis? Just so that I truly understand what I did. I'm like that. "Tom Ogilvy" wrote: for you count column =subtotal(3,$A$2:A2) then drag fill down the column Make sure that the column it counts is one that will have data in every row. -- Regards, Tom Ogilvy "Eduman" wrote: Is there a way to auto number the rows on a printout? I have a column in my spreadsheet that is the count column (increases by 1 in each row to show how many "records" there are). When I am working with the filters or sorting, it obviously moves the count column around too (I know that I can sort without that column). I would like to print rosters of various subgroups from my spreadsheet using various filters and have Excel number my rows on the printout in consecutive order. Is it possible?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto number rows when printing
The coding in the parentheses means to take the subtotal of range A2:A2 by
counting the number of occurrences of text in that range. As you fill the formula down it will change its range from A2:A2 to A2:A3, etc. That's what the dollar signs mean. Dave -- Brevity is the soul of wit. "Eduman" wrote: Thanks Tom. That worked great. Can you explain what the coding in the parenthesis? Just so that I truly understand what I did. I'm like that. "Tom Ogilvy" wrote: for you count column =subtotal(3,$A$2:A2) then drag fill down the column Make sure that the column it counts is one that will have data in every row. -- Regards, Tom Ogilvy "Eduman" wrote: Is there a way to auto number the rows on a printout? I have a column in my spreadsheet that is the count column (increases by 1 in each row to show how many "records" there are). When I am working with the filters or sorting, it obviously moves the count column around too (I know that I can sort without that column). I would like to print rosters of various subgroups from my spreadsheet using various filters and have Excel number my rows on the printout in consecutive order. Is it possible?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto number rows when printing
Appreciate it. That helped a lot and I understand the process now.
"Dave F" wrote: The coding in the parentheses means to take the subtotal of range A2:A2 by counting the number of occurrences of text in that range. As you fill the formula down it will change its range from A2:A2 to A2:A3, etc. That's what the dollar signs mean. Dave -- Brevity is the soul of wit. "Eduman" wrote: Thanks Tom. That worked great. Can you explain what the coding in the parenthesis? Just so that I truly understand what I did. I'm like that. "Tom Ogilvy" wrote: for you count column =subtotal(3,$A$2:A2) then drag fill down the column Make sure that the column it counts is one that will have data in every row. -- Regards, Tom Ogilvy "Eduman" wrote: Is there a way to auto number the rows on a printout? I have a column in my spreadsheet that is the count column (increases by 1 in each row to show how many "records" there are). When I am working with the filters or sorting, it obviously moves the count column around too (I know that I can sort without that column). I would like to print rosters of various subgroups from my spreadsheet using various filters and have Excel number my rows on the printout in consecutive order. Is it possible?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Displaying all rows, printing only certain rows | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
set number of rows equal in mutiple columns | Excel Discussion (Misc queries) |