Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C C is offline
external usenet poster
 
Posts: 61
Default I don't want row 1 as the column headings

This seems like a simple matter but I cannot find the answer anywhere. I have
typed my column headings in and they appear along row 1. I don't want the
headings to be row 1 I want row one for entering the first row of data. How
do I make row 1 truly row 1 and not the column headings. I am not asking how
to make the row appear across each page, I have that already.
thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default I don't want row 1 as the column headings

You can not change the column headings (except to numbers). However, you can
use your col headings on row 1 and hide the row/column headings. But, they
are still there.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"C" wrote in message
...
This seems like a simple matter but I cannot find the answer anywhere. I
have
typed my column headings in and they appear along row 1. I don't want the
headings to be row 1 I want row one for entering the first row of data.
How
do I make row 1 truly row 1 and not the column headings. I am not asking
how
to make the row appear across each page, I have that already.
thanks in advance.


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
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
Column headings to numbers and row headings to alphabets? Juliana Excel Discussion (Misc queries) 2 May 9th 08 05:58 PM
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 create column headings in Excel in the A, B, C etc column eliannaj Excel Discussion (Misc queries) 2 November 23rd 05 06:48 PM
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 05:39 PM.

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

About Us

"It's about Microsoft Excel"