Deleting header rows when cut and pasting from another program

T

TAT

When I cut and paste from another program into an excel
spreadsheet I cannot use the CNTRL key to select just the
data and the headings on the first page only. Everything
is selected including the headers, page number,etc. when
there are more than one pages being copied and pasted.

Is there a macro that can be run to rid of these headings
from subsequent pages?
 
D

David McRitchie

The Ctrl key by itself is not a shortcut key.
If you mean Ctrl+A you are selecting everything ('cept in 2003)

Usually to make a selection you hold the left mouse and drag
through cells, rows, or columns;
or you could triple-click for a paragraph or something similar.
In HTML CTRL+click is same as triple-click (both work there).

A more explicit description would help. What application and
exactly what do you want to do, what you did, and what happens instead
of what you want.

This might help:
Use of Mouse and keys to move, and insert rows or columns (#mouse)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Cursor Problems (#cursorprob)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursorprob


HTH, (my usage is Excel 2000 on a PC, 5 button mouse)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
T

Tat

Sorry, my explanation was not very good.
To select data that is consecutive I can click on one item
then go down to the my last item and use the shift key. It
selects everything between those two points. To select
data that are not continous I select my first data then I
depress just the CTRL key to select only amy other data I
want. In this other program, not MS Office, I cannot
randomly select. I have to select all or select continous
rows. As a result when I copy and paste to an excel
spreadsheet all the headings are included that appear on
each page. How can I get rid of these headings in excel
without having to scroll down through pages of data and
delete the heading rows. The only headings I want to keep
are the ones on the first page of the report that I pasted
into excel. Is there a macro that can do this?
-----Original Message-----
The Ctrl key by itself is not a shortcut key.
If you mean Ctrl+A you are selecting everything ('cept in 2003)

Usually to make a selection you hold the left mouse and drag
through cells, rows, or columns;
or you could triple-click for a paragraph or something similar.
In HTML CTRL+click is same as triple-click (both work there).

A more explicit description would help. What application and
exactly what do you want to do, what you did, and what happens instead
of what you want.

This might help:
Use of Mouse and keys to move, and insert rows or columns (#mouse)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Cursor Problems (#cursorprob)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursorpro
b


HTH, (my usage is Excel 2000 on a PC, 5 button mouse)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TAT" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
D

David McRitchie

You normally do not have intervening headings in a spreadsheet
at the top of your pages unless you are also doing page breaks.

Selecting additional areas with the Ctrl key and mouse (ok, I get
the point it's easier to just say ctrl key) does not allow you to
paste them.as a single group.

You have two choices. One would be to use a filter that leave
only the data you want to copy and paste. If you copy from
filtered data as far as paste goes that is all that exists, as far as
mail merge goes that is all that exists.

Another option would be to use a macro and process each selection
area independently.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Tat said:
Sorry, my explanation was not very good.
To select data that is consecutive I can click on one item
then go down to the my last item and use the shift key. It
selects everything between those two points. To select
data that are not continous I select my first data then I
depress just the CTRL key to select only amy other data I
want. In this other program, not MS Office, I cannot
randomly select. I have to select all or select continous
rows. As a result when I copy and paste to an excel
spreadsheet all the headings are included that appear on
each page. How can I get rid of these headings in excel
without having to scroll down through pages of data and
delete the heading rows. The only headings I want to keep
are the ones on the first page of the report that I pasted
into excel. Is there a macro that can do this?
-----Original Message-----
The Ctrl key by itself is not a shortcut key.
If you mean Ctrl+A you are selecting everything ('cept in 2003)

Usually to make a selection you hold the left mouse and drag
through cells, rows, or columns;
or you could triple-click for a paragraph or something similar.
In HTML CTRL+click is same as triple-click (both work there).

A more explicit description would help. What application and
exactly what do you want to do, what you did, and what happens instead
of what you want.

This might help:
Use of Mouse and keys to move, and insert rows or columns (#mouse)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Cursor Problems (#cursorprob)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#cursorpro
b


HTH, (my usage is Excel 2000 on a PC, 5 button mouse)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TAT" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
.
Click to expand...
Click to expand...
 
Top