I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?

Wonder if you have already read the following writeup by Dave Peterson in 2004. Mind you it was for Excel 97. Has there been an improvement? Anyone?

************************************************** ************************************************** **************************

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.


A helper column (new column A) filled with formulas:


=row()

Source: http://groups.google.ca/group/micros...a02ab0c571e8bc

If broken, try this - http://tinyurl.com/j86ag

************************************************** ************************************************** *************************************************

Following from Help:-

"Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function......."

More details under Help.

Now, how about if we want to print column headings and NOT row numbers? Just a thought. Won't worry for now.

Epinn

"jgb" wrote in message ...

I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?

What do you mean that I have to "do it myself"? Do you mean a a cosecutive
numbers column but don't check the "headers and footers" box on page setup?

"Epinn" wrote:

Wonder if you have already read the following writeup by Dave Peterson in 2004. Mind you it was for Excel 97. Has there been an improvement? Anyone?

************************************************** ************************************************** **************************

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.


A helper column (new column A) filled with formulas:


=row()

Source: http://groups.google.ca/group/micros...a02ab0c571e8bc

If broken, try this - http://tinyurl.com/j86ag

************************************************** ************************************************** *************************************************

Following from Help:-

"Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function......."

More details under Help.

Now, how about if we want to print column headings and NOT row numbers? Just a thought. Won't worry for now.

Epinn

"jgb" wrote in message ...

I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?

Please note that it *wasn't* me, Epinn, saying "do it yourself." I was quoting *part* of Dave's post in the thread (click link to see the entire thread). If you want me to interpret Dave's suggestion, I say mine will be similar to yours i.e. create a column of consecutive row numbers using ROW() and don't check "row and column headings" box under the sheet tab. I guess when you said "headers and footers" you actually meant "row and column headings?"

I am just passing on info that I have read. You may want to wait for a bit and see if Dave or anyone else has other suggestions. At this point, I am not aware of a "better" or an automatic way of doing it.

Epinn

"jgb" wrote in message ...
What do you mean that I have to "do it myself"? Do you mean a a cosecutive
numbers column but don't check the "headers and footers" box on page setup?

"Epinn" wrote:

Wonder if you have already read the following writeup by Dave Peterson in 2004. Mind you it was for Excel 97. Has there been an improvement? Anyone?

************************************************** ************************************************** **************************

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.


A helper column (new column A) filled with formulas:


=row()

Source: http://groups.google.ca/group/micros...a02ab0c571e8bc

If broken, try this - http://tinyurl.com/j86ag

************************************************** ************************************************** *************************************************

Following from Help:-

"Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function......."

More details under Help.

Now, how about if we want to print column headings and NOT row numbers? Just a thought. Won't worry for now.

Epinn

"jgb" wrote in message ...

I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?

Yep. That's what my suggestion meant--except replace your "headers and footers"
phrase with "row and column headings".

It's either show both or show neither.

And since you don't want both, then choose to show neither--and add some "fake"
row numbers your own self.



jgb wrote:

What do you mean that I have to "do it myself"? Do you mean a a cosecutive
numbers column but don't check the "headers and footers" box on page setup?

"Epinn" wrote:

Wonder if you have already read the following writeup by Dave Peterson in 2004. Mind you it was for Excel 97. Has there been an improvement? Anyone?

************************************************** ************************************************** **************************

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.


A helper column (new column A) filled with formulas:


=row()

Source: http://groups.google.ca/group/micros...a02ab0c571e8bc

If broken, try this - http://tinyurl.com/j86ag

************************************************** ************************************************** *************************************************

Following from Help:-

"Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function......."

More details under Help.

Now, how about if we want to print column headings and NOT row numbers? Just a thought. Won't worry for now.

Epinn

"jgb" wrote in message ...

I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?



--

Dave Peterson

Thanks, I will experiment.

"Epinn" wrote:

Please note that it *wasn't* me, Epinn, saying "do it yourself." I was quoting *part* of Dave's post in the thread (click link to see the entire thread). If you want me to interpret Dave's suggestion, I say mine will be similar to yours i.e. create a column of consecutive row numbers using ROW() and don't check "row and column headings" box under the sheet tab. I guess when you said "headers and footers" you actually meant "row and column headings?"

I am just passing on info that I have read. You may want to wait for a bit and see if Dave or anyone else has other suggestions. At this point, I am not aware of a "better" or an automatic way of doing it.

Epinn

"jgb" wrote in message ...
What do you mean that I have to "do it myself"? Do you mean a a cosecutive
numbers column but don't check the "headers and footers" box on page setup?

"Epinn" wrote:

Wonder if you have already read the following writeup by Dave Peterson in 2004. Mind you it was for Excel 97. Has there been an improvement? Anyone?

************************************************** ************************************************** **************************

If you really only want the row numbers, but not the column headings, you'll
have to do it yourself.


A helper column (new column A) filled with formulas:


=row()

Source: http://groups.google.ca/group/micros...a02ab0c571e8bc

If broken, try this - http://tinyurl.com/j86ag

************************************************** ************************************************** *************************************************

Following from Help:-

"Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function......."

More details under Help.

Now, how about if we want to print column headings and NOT row numbers? Just a thought. Won't worry for now.

Epinn

"jgb" wrote in message ...

I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?