How to print line numbers but not column headers? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
BillCo 2/19/2007 2:01 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
john 2/19/2007 2:13 PM PST
   
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Carole 10/8/2008 7:30 AM PST
   
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Richard Schollar  10/8/2008 7:38 AM PST
   
  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" <Carole@discussions.microsoft.com> wrote in message
news:1C92F814-9F72-48C2-9886-5FA2A8B88114@microsoft.com...
> 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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Carole 10/8/2008 8:35 AM PST
   
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Earl Kiosterud 2/19/2007 3:06 PM PST
  Answer
  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" <BillCo@discussions.microsoft.com> wrote in message
news:77C2AE94-690D-4B1D-9ECE-A8317BCE35E6@microsoft.com...
> 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.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
BillCo 2/19/2007 3:48 PM PST
   
  Thank you. Your suggestion worked great. Bill
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
campy 10/8/2008 9:30 AM PST
   
 

"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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
HAMEL 10/19/2008 9:35 PM PST
   
 

"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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies