ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I not print the column letters A-Z but keep the row #'s (https://www.excelbanter.com/excel-discussion-misc-queries/109223-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?

Nick B

How do I not print the column letters A-Z but keep the row #'s
 
You could insert a new column and push everything else to the right one
column. Then in A1, type in 1 and in A2, type in 2 and then highlight the two
cells and drag them as far down as needed....

"jgb" wrote:

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 07:03 PM.

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