column headings with data starting in row 1

  • Thread starter Thread starter Mrs. E.
  • Start date Start date
M

Mrs. E.

Is there a way to have headings on the columns and start the
data entry at Row 1?, instead of Row 2?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals 2
Lookup Column Headings and Sum the Rows 3
Excel Help to copy information from one row at a time to another sheet 1
HELP! 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How: reset the column headings from numeric to alphabetic? 1
conditional formatting referencing 3 cells by row in a range 3
Column Headings in Excel 2

Back
Top