Anybody care to lend me some excel help?

Midlodemocrat

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:21 PM
Original message

Anybody care to lend me some excel help?

I can't remember how to *delete* the A, B, C, across the top row and replace it with custom column titles.

Anybody?

TIA.

Printer Friendly | Permalink | | Top

Hugin

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:23 PM
Response to Original message

1. You know, I use-ta know that...

*rubs chin*

*scratches head*

Talk about a 'duh' moment.

Printer Friendly | Permalink | | Top

Midlodemocrat

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:24 PM
Response to Reply #1

2. LOL. That's exactly how I feel!

And the office assistant isn't any help right now either, the bastid.

Printer Friendly | Permalink | | Top

kay1864

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:25 PM
Response to Original message

3. Is this what you mean?

Convert existing row and column labels to names

1. Select the range you want to name, including the row or column labels.
2. On the Insert menu, point to Name, and then click Create.
3. In the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.

Note: A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels

Printer Friendly | Permalink | | Top

Midlodemocrat

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:28 PM
Response to Reply #3

4. I don't think so. I just tried it.

I want to change the *A* in the *A* column to Last Name, the *B* in the *B* column to First name, etc.

Printer Friendly | Permalink | | Top

Fredda Weinberg

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:33 PM
Response to Reply #4

6. The first row contains column names

You freeze the first row to keep them visible as you scroll. Import utilities know to find field names there as well.

Printer Friendly | Permalink | | Top

unpossibles

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:31 PM
Response to Original message

5. I could be wrong

but I thought you had to keep those A or B or whatever, as the functions can refer to them more easily.

I always just put the column headers I want in the first row, then freeze that row so that it is always visible when I scroll (you do that by selecting the second row and clicking 'freeze panes' under the window menu.

Printer Friendly | Permalink | | Top

Midlodemocrat

(1000+ posts) Send PM | Profile | Ignore

Mon Dec-11-06 02:34 PM
Response to Reply #5

7. You're exactly right. D'oh. I have to put the headers in the first row.

Thanks. I spent 45minutes trying to figure out what I already knew. :eyes:

Printer Friendly | Permalink | | Top

DU AdBot (1000+ posts)

Sun May 05th 2024, 12:31 PM
Response to Original message

Advertisements [?]

Top

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.