Add header into Excel table

Hi,

How can I add header(cells in first row) to the sheet which is created after I copied values from other sheets?

Eg. values copied are like this

2003 |June| James| 250
2005 |May| John | 1001

So, the header would be
Year|Month|Name|Amount

Thanks in advance,
amy

Click on the #1 to select row 1, and hit Insert-->Row, and type them in. Or
am I being dense and not understanding?
************
Anne Troy
www.OfficeArticles.com

"jonesaa05" <[email protected]> wrote
in message news:[email protected]...
>
> Hi,
>
> How can I add header(cells in first row) to the sheet which is created
> after I copied values from other sheets?
>
> Eg. values copied are like this
>
> 2003 |June| James| 250
> 2005 |May| John | 1001
>
> So, the header would be
> Year|Month|Name|Amount
>
> Thanks in advance,
> amy
>
>
> --
> jonesaa05
> ------------------------------------------------------------------------
> jonesaa05's Profile:
> http://www.excelforum.com/member.php...o&userid=28021
> View this thread: http://www.excelforum.com/showthread...hreadid=477044
>

Sorry, I should clarify that the values are copied from different sheets into one sheet using macro.

Only certain related cells are copied, so I have to add title in the columns myself. So, what I mean is after the values are copied (run the macro), can I also add title for each columns as well. I don't want to type in manually. Is there any ways to do this?


Thankyou.

amy

Record a macro that...
Ctrl+Home (to get to cell A1)
Insert-->Row
Type the headings.
Stop recording.
I'm not sure why it might be any more difficult than that.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"jonesaa05" <[email protected]> wrote
in message news:[email protected]...
>
> Sorry, I should clarify that the values are copied from different
> sheets into one sheet using macro.
>
> Only certain related cells are copied, so I have to add title in the
> columns myself. So, what I mean is after the values are copied (run the
> macro), can I also add title for each columns as well. I don't want to
> type in manually. Is there any ways to do this?
>
>
> Thankyou.
>
> amy
>
>
> --
> jonesaa05
> ------------------------------------------------------------------------
> jonesaa05's Profile:
> http://www.excelforum.com/member.php...o&userid=28021
> View this thread: http://www.excelforum.com/showthread...hreadid=477044
>