#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Column Titles

How do I put a title on a column. Example: I want column A titled - Unit#,
and I want column B titled - NAME, etc.
--
CHUCK G.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Column Titles

You don't. You can label row 1 as desired and hide the rows/columns but you
still have them....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CHUCK G." wrote in message
...
How do I put a title on a column. Example: I want column A titled -
Unit#,
and I want column B titled - NAME, etc.
--
CHUCK G.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default Column Titles

"CHUCK G." wrote:
How do I put a title on a column. Example: I want column A
titled - Unit#, and I want column B titled - NAME, etc.


You can put the desired titles in their respective columns in row 1, then
disable row and column headers by unchecking the option under Tools
Options View.

But the last step is usually undesirable because you will still want to use
cell reference indicated by row and column, unless you have a lot of named
ranges.

The more common requirement is simply to not show row and column headers
when you __print__. That can be accomplished by disabling row and column
headers under Page Setup Sheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
column titles Curtis Croulet Charts and Charting in Excel 2 December 1st 07 10:46 PM
Column and Row Titles whitemordsith Excel Worksheet Functions 1 November 12th 07 06:53 PM
Column titles James Silverton[_2_] Excel Discussion (Misc queries) 3 August 26th 07 06:20 PM
Returning the Row and Column titles of a certain value Tibbs Excel Discussion (Misc queries) 12 June 23rd 05 07:11 PM
Column Titles KrisP Setting up and Configuration of Excel 1 February 11th 05 05:21 PM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"