Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 28th 05, 04:59 PM
Danielle
 
Posts: n/a
Default 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


  #2   Report Post  
Old September 28th 05, 07:24 PM
Gord Dibben
 
Posts: n/a
Default

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




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
% change in the last two cells in a row chewmanfoo Excel Worksheet Functions 6 September 10th 05 08:58 AM
retrieve text from merged cells Eric Excel Worksheet Functions 3 July 9th 05 09:17 AM
Cells formated as numbers are calculating like text MM_BAM Excel Discussion (Misc queries) 4 July 7th 05 01:29 AM
How do I change macro text with another macro? Eric Excel Discussion (Misc queries) 4 April 27th 05 11:20 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017