| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print line numbers but not column headers?
In Excel is it possible to print the Row Headings but not the Column
Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
insert an extra column on the left and fill it with the row numbers
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
I think you mean row numbers. You can put them in a column yourself. Select the column
following where you'd like to have them (click in the column header). Insert a column (Edit - Insert, or Ctrl +_. Put the first line number in the first cell, then drag the fill handle (lower right corner of the cell) down holding the Ctrl key. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "BillCo" wrote in message ... In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
Thank you. Your suggestion worked great. Bill
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
Adding a column on the left doesn't help if you want to sort your data. The
"row headings" you create will jumble out of order. If you're working with a large spread sheet it's a pain to have to select everything EXCEPT that new column when sorting. Still looking for an easier way! "john" wrote: insert an extra column on the left and fill it with the row numbers -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
Hello Carole
Rather than fill the column with hardcoded numbers, fill it with the ROW() formula executed like this: =ROW() and copied all the way down. It will always reflect the row number of the cell in which it appears so you are free to sort to your heart's desire (assuming you have Automatic Calculation enabled). Richard "Carole" wrote in message ... Adding a column on the left doesn't help if you want to sort your data. The "row headings" you create will jumble out of order. If you're working with a large spread sheet it's a pain to have to select everything EXCEPT that new column when sorting. Still looking for an easier way! "john" wrote: insert an extra column on the left and fill it with the row numbers -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
Thank you sooo much. That worked great!
"Carole" wrote: Adding a column on the left doesn't help if you want to sort your data. The "row headings" you create will jumble out of order. If you're working with a large spread sheet it's a pain to have to select everything EXCEPT that new column when sorting. Still looking for an easier way! "john" wrote: insert an extra column on the left and fill it with the row numbers -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
"BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print line numbers but not column headers?
"BillCo" wrote: In Excel is it possible to print the Row Headings but not the Column Headings. I want to print the line numbers down the side but do not want the column headings. I do not see a way to separate them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
| How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
| Print column headers on select pages only | Excel Discussion (Misc queries) | |||
| My Excel column headers have changed to numbers, how do I get bac. | Excel Discussion (Misc queries) | |||
| My column headers are numbers | Excel Discussion (Misc queries) | |||
Linear Mode
