Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Column and Row Headings

Posted by Andy on July 06, 2001 12:40 PM
I was wondering if anyone knew how to place headings for both columns and rows. I am making a basic spreadsheet, but I want to get rid of the letters and numbers that currently exist.



Re: Column and Row Headings

Posted by Ben O. on July 06, 2001 12:45 PM
Go to Tools > Options, select the View tab and un-check Row & Column headers. Enter your custome row and columns headers across row 1 and down column A. Then put the cursor in cell B2 and select Window > Freeze Panes. That's about as close to custom headers as you're going to get.

-Ben O.

Turn-off: Column and Row Headings

Posted by Joe Was on July 06, 2001 12:53 PM
Turn off the displayed header and row numbers.
Tools-Options... "Row and column headers" un-check.

To turn off the printed column and row headers:
File-Page Setup-Sheet "Row and column headings" un-check.

With lables you can create any row or column headers you want, if you turn off the default headers! JSW

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.