Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Column and Row HeadingsPosted 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 HeadingsPosted 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.
Turn-off: Column and Row HeadingsPosted 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 www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.