ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hiding Column/Row Headings/Numbers (https://www.excelbanter.com/excel-programming/361183-hiding-column-row-headings-numbers.html)

cookie

Hiding Column/Row Headings/Numbers
 
I've a Sheet with a custom view to only show cells A1 thru F15 for a small
info panel on a workbook.

My question is how do I stop the display of the column headings and row
numbers?

I can't find anything in Excel help guide.

I'm running Excel 2000 SR-1 and NT4 by the way :o)

Many Thanks
David

davegb

Hiding Column/Row Headings/Numbers
 

Cookie wrote:
I've a Sheet with a custom view to only show cells A1 thru F15 for a small
info panel on a workbook.

My question is how do I stop the display of the column headings and row
numbers?

I can't find anything in Excel help guide.

I'm running Excel 2000 SR-1 and NT4 by the way :o)

Many Thanks
David


It's under "Tools, Options", View tab, Windowns Options, Row & Column
Headers.


cookie

Hiding Column/Row Headings/Numbers
 
Excellent.

Thanks very much.
David

"davegb" wrote:


Cookie wrote:
I've a Sheet with a custom view to only show cells A1 thru F15 for a small
info panel on a workbook.

My question is how do I stop the display of the column headings and row
numbers?

I can't find anything in Excel help guide.

I'm running Excel 2000 SR-1 and NT4 by the way :o)

Many Thanks
David


It's under "Tools, Options", View tab, Windowns Options, Row & Column
Headers.




All times are GMT +1. The time now is 09:02 AM.

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