ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do you change the A'B'C cells to text? (https://www.excelbanter.com/setting-up-configuration-excel/47588-how-do-you-change-abc-cells-text.html)

Danielle

How do you change the A'B'C cells to text?
 
Using Excel '03, is there a way to change the top cells (A, B, C, etc.) so
that when you select to print row & column headings there is text? Also, if
there is a way to do this, is there a way to print only the column headings
and not the rows?

Thanks,

Danielle


Gord Dibben

Danielle

No way to do this.

Add your own unique names to the columns in row 1 then turn off the column and
row headers in ToolsOptionsView.

Select A2 and WindowFreeze Panes to keep row 1 and your header names in view.


Gord Dibben Excel MVP


On Wed, 28 Sep 2005 08:59:17 -0700, "Danielle"
wrote:

Using Excel '03, is there a way to change the top cells (A, B, C, etc.) so
that when you select to print row & column headings there is text? Also, if
there is a way to do this, is there a way to print only the column headings
and not the rows?

Thanks,

Danielle




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

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