ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column Titles (https://www.excelbanter.com/excel-worksheet-functions/229634-column-titles.html)

CHUCK G.

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.

Don Guillett

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.



joeu2004

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.



All times are GMT +1. The time now is 07:43 PM.

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