|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
10-19-2006, 04:49 PM
|
#1 |
|
Member (12 bit)
Join Date: Dec 2001
Location: St. Louis, Missouri
Posts: 3,294
  |
Possible to Change Column Names in Excel?
Just curious. Can the column names (A, B, C, etc.) be changed to a text title? I'm wanting to do that so the headings are reflected at the top of every page of a multi-page document.
Thx.
__________________
Kov Are You Foldin'? Join PCMech's Folding@Home Team and Help Save Lives! Click Here!
|
|
|
|
10-20-2006, 12:06 AM
|
#2 |
|
Forum Administrator
Staff
Premium Member
Join Date: May 2000
Location: Joplin MO
Posts: 37,785
|
Not that I'm aware of, but why not just use Row 1 for your titles?
|
|
|
|
10-20-2006, 12:21 AM
|
#3 |
|
Member (12 bit)
Join Date: Dec 2001
Location: St. Louis, Missouri
Posts: 3,294
|
Wouldn't Row 1 show up as the title for the first page only, tho? This doc will wind up being multiple pages... Shoulda just done it in Works Database, I guess....
|
|
|
|
|
10-20-2006, 12:29 AM
|
#4 |
|
Forum Administrator
Staff
Premium Member
Join Date: May 2000
Location: Joplin MO
Posts: 37,785
|
Good point.
|
|
|
|
|
10-20-2006, 12:34 AM
|
#5 |
|
Member (10 bit)
Join Date: Jul 2002
Location: Trivandrum, India
Posts: 800
 |
Kov-Ice,
First set your column titles in the first row of your sheet. Set your print area (Select the area you want to print, then FILE>PRINT AREA>SET PRINT AREA), and adjust your page layout using Page Preview (VIEW>PAGE BREAK PREVIEW). Then on the Sheet tab of the Page Setup (FILE>PAGE SETUP) dialog, there is a place where it says Rows to repeat at top. Click on the button at the left end of the box and then select the row in the sheet that contains your column titles. The cells you select will show up in the box.Then click the button again to return to the Page Setup dialog. This row will then appear at the top of every sheet in the printout.
__________________
[FONT=Arial][SIZE=1][COLOR=Navy][CENTER]Intel Core2Quad Q9550; EP45-UD3R (rev 1.1); 4x2GB DDR2 800MHz; eVGA e-GeForce 9600GT KO 512MB DDR3; Seagate ST31000528AS 1T, Seagate ST3500320AS 500GB SATA II, Seagate ST3500418AS 500GB SATA II; LG GH22-NS50 DVD-RAM x 2; DELL SP2208WFP; Windows 7 Ultimate 64-Bit Palm LifeDrive Mobile Manager Last edited by pillainp; 10-20-2006 at 12:38 AM. |
|
|
|
|
10-20-2006, 01:47 AM
|
#6 |
|
Member (12 bit)
Join Date: Dec 2001
Location: St. Louis, Missouri
Posts: 3,294
|
Excellent, thanks!
pillainp, does that have to be done right before printing? Or can it be done, saved, and then further edited while still keeping that property? |
|
|
|
|
10-20-2006, 02:06 AM
|
#7 | |
|
Member (10 bit)
Join Date: Jul 2002
Location: Trivandrum, India
Posts: 800
|
Quote:
Once the printing properties are set up and the sheet is saved, they will remain with the sheet, even if it saved under a different name or emailed. NPP |
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change nameservers ? | Parangles | Internet, Web Applications, & The Cloud | 2 | 06-24-2006 06:47 PM |
| How to change a user name in the Windows System Folder | darla | Windows Legacy Support (XP and earlier) | 1 | 09-15-2005 06:03 PM |
| Excel Formula Question | shaticus | Software Discussion & Support | 2 | 07-12-2005 08:45 AM |
| How to change AGP Rate??? | jnc007 | Computer Hardware | 6 | 12-12-2001 08:44 AM |
| Global font change possible? | pconley | Windows Legacy Support (XP and earlier) | 4 | 05-23-2001 03:39 PM |
Linear Mode
