ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Hiding rows and columns in XL 07 (https://www.excelbanter.com/new-users-excel/241171-hiding-rows-columns-xl-07-a.html)

mlenard

Hiding rows and columns in XL 07
 
How do I get the top column row, which contains only the column letters, and
the row number, which is the narrow column to the left of Column A, to
disappear when I print? thanks everyone for your help. -mlenard

Max

Hiding rows and columns in XL 07
 
Click File Page Setup Sheet tab
Uncheck "Row and Column headings" OK
(Its probably checked)
Success? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"mlenard" wrote:
How do I get the top column row, which contains only the column letters, and
the row number, which is the narrow column to the left of Column A, to
disappear when I print? thanks everyone for your help. -mlenard


Max

Hiding rows and columns in XL 07
 
Oops, sorry, I misread your subject line earlier as "XL97"

Don't have xl07, but this seems the xl07 route for: "FilePage Setup"
Page Layout | Page Setup | Dialog Launcher
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---


Bernard Liengme[_3_]

Hiding rows and columns in XL 07
 
Page Layout tab; Sheet Options group: uncheck the box Heading/Print
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"mlenard" wrote in message
...
How do I get the top column row, which contains only the column letters,
and
the row number, which is the narrow column to the left of Column A, to
disappear when I print? thanks everyone for your help. -mlenard





All times are GMT +1. The time now is 03:06 AM.

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