Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Row & Column Headings

Is there a way to have words for column headings instead of A, B, C, etc.?
Is there a way to start Row 1 on the third row?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Row & Column Headings

No. The usual way would be simply to use say, col A for row headers and row1
for col headers. Eg you could enter text col labels in B1 across, and have
the row numbers running in A2 down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
Is there a way to have words for column headings instead of A, B, C, etc.?
Is there a way to start Row 1 on the third row?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,942
Default Row & Column Headings

hi,
you can turn off excel row and columns headers by going
toolsoptionsviewuncheck row and column headers.
you can then put your own column headers in the first row and row headers in
the first column then place the curser in second column and second row and go
Windowfreeze panes.
but in doing so, you would loose many built in excel function such as select
sheet, select row, select column, autofit row/column and others.

Regards
FSt1

" wrote:

Is there a way to have words for column headings instead of A, B, C, etc.?
Is there a way to start Row 1 on the third row?

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
Using an Index by Column Headings instead of Column Numbers Sean Bishop New Users to Excel 2 November 21st 06 09:38 PM
How do I take information in 1 column to make column headings? Northside Excel Discussion (Misc queries) 1 December 16th 05 09:47 PM
How do I create column headings in Excel in the A, B, C etc column eliannaj Excel Discussion (Misc queries) 2 November 23rd 05 06:48 PM
Column headings Bridge Excel Discussion (Misc queries) 2 August 19th 05 03:56 AM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


All times are GMT +1. The time now is 08:03 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"