View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default How do I not print the column letters A-Z but keep the row #'s

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?