ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I not print the column letters A-Z but keep the row #'s (https://www.excelbanter.com/charts-charting-excel/109240-how-do-i-not-print-column-letters-z-but-keep-row-s.html)

jgb

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

Bernard Liengme

How do I not print the column letters A-Z but keep the row #'s
 
How about inserting a new A column and adding =ROW()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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?




jgb

How do I not print the column letters A-Z but keep the row #'s
 
Thanks. It looks like this will be the only way to accomplish it. Do I have
to do that for every single row or is there a way to automatically configure
a row with consecutive numbers?

"Bernard Liengme" wrote:

How about inserting a new A column and adding =ROW()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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?






All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com