Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copy and pasting using filters

Copy and pasting using filters

ResolvedVersion 2007

Tue 16 Jun 2009, 14:45 Delegate Tatiana said...

Tatiana has attended:
Excel Advanced course

Copy and pasting using filters

Hi,

I have just upgraded to excel 2007 and I'm finding that when I filter down a table I cannot copy and past cells exclusively to the information shown, insteady the information pastes to the entire column whether hidden or not. Is there a setting that needs changing? Please advise.

Many thanks,

Tatiana.

Tue 16 Jun 2009, 15:32 Trainer Amanda said...

RE: copy and pasting using filters

Hello Tatiana

Thank you for your question.

I think what would work is if you asked Excel to select only the visible cells in the range you select, then copy and paste as normal.

To do this:
Select the cell range you wish to copy. Press F5, then click Special, select Visible cells only, then click OK. Then copy and paste as normal.

I hope this helps.

Kind regards
Amanda

Tue 23 Jun 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Copy and pasting using filters

Copy and pasting using filters

RE: copy and pasting using filters

Excel articles

Excel tip:

Autofit column width – Excel (all versions)