How do I not print the column letters A-Z but keep the row #'s jgb 09.09.2006 14:18:01 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?

Re: How do I not print the column letters A-Z but keep the row #'s "Epinn" <someone[ at ]example.com.NO_SPAM> 09.09.2006 15:11:43 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/microsoft.public.excel.newusers/browse_thread/thread/1d9e674cfbd27d37/e0a02ab0c571e8bc%23e0a02ab0c571e8bc 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:F7A10B86-BE8E-4C05-ABC1-A7595C38D45C[ at ]microsoft.com... 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?

Re: How do I not print the column letters A-Z but keep the row #'s jgb 09.09.2006 16:41:01 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: [Quoted Text] > 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/microsoft.public.excel.newusers/browse_thread/thread/1d9e674cfbd27d37/e0a02ab0c571e8bc%23e0a02ab0c571e8bc > > 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:F7A10B86-BE8E-4C05-ABC1-A7595C38D45C[ at ]microsoft.com... > > 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? > >

Re: How do I not print the column letters A-Z but keep the row #'s "Epinn" <someone[ at ]example.com.NO_SPAM> 09.09.2006 17:40:11 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:C61DE9C1-14EA-4128-A4C8-F28FD6548A64[ at ]microsoft.com... 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: [Quoted Text] > 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/microsoft.public.excel.newusers/browse_thread/thread/1d9e674cfbd27d37/e0a02ab0c571e8bc%23e0a02ab0c571e8bc > > 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:F7A10B86-BE8E-4C05-ABC1-A7595C38D45C[ at ]microsoft.com... > > 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? > >

Re: How do I not print the column letters A-Z but keep the row #'s Dave Peterson <petersod[ at ]verizonXSPAM.net> 09.09.2006 18:55:14 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: [Quoted Text] > > 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/microsoft.public.excel.newusers/browse_thread/thread/1d9e674cfbd27d37/e0a02ab0c571e8bc%23e0a02ab0c571e8bc > > > > 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:F7A10B86-BE8E-4C05-ABC1-A7595C38D45C[ at ]microsoft.com... > > > > 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

Re: How do I not print the column letters A-Z but keep the row #'s jgb 09.09.2006 18:59:02 Thanks, I will experiment. "Epinn" wrote: [Quoted Text] > 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:C61DE9C1-14EA-4128-A4C8-F28FD6548A64[ at ]microsoft.com... > 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/microsoft.public.excel.newusers/browse_thread/thread/1d9e674cfbd27d37/e0a02ab0c571e8bc%23e0a02ab0c571e8bc > > > > 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" <jgb[ at ]discussions.microsoft.com> wrote in message news:F7A10B86-BE8E-4C05-ABC1-A7595C38D45C[ at ]microsoft.com... > > > > 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? > > > > > >