ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column headings with data starting in row 1 (https://www.excelbanter.com/excel-discussion-misc-queries/190662-column-headings-data-starting-row-1-a.html)

Mrs. E.

column headings with data starting in row 1
 
Is there a way to have headings on the columns and start the
data entry at Row 1?, instead of Row 2?

Dave Peterson

column headings with data starting in row 1
 
You can show A, B, C, ... or 1, 2, 3, ... or nothing at all for the column
headings.

But you can't change them.

I just put my own headers in row 1 and then I select A2 and hit Window|Freeze
panes (xl2003 menus). This way, my headers in row 1 will always be visible when
I scroll down.

Mrs. E. wrote:

Is there a way to have headings on the columns and start the
data entry at Row 1?, instead of Row 2?


--

Dave Peterson

Gord Dibben

column headings with data starting in row 1
 
No.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 07:39:01 -0700, Mrs. E. <Mrs.
wrote:

Is there a way to have headings on the columns and start the
data entry at Row 1?, instead of Row 2?




All times are GMT +1. The time now is 07:26 AM.

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