Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Filtering

Resolved · Medium Priority · Version 2007

Reply Fri 1 May 2009, 15:33Delegate James said...

James has attended:
Excel VBA Intro Intermediate course

Filtering

Hi

I am working with a large spreadsheet that has approx 98000 rows to start.

I have formatted as a table and added auto filters. When I have applied the auto filters there are 24000 cells left visible.

When I attempt to populate or copy paste cells with in the filtered range I receive a message telling me that the range is too complex and I should try and get the data in to one continuous rectangle.

Catch 22 is that I need to be able to copy paste in the filtered range in order to sort in to a continuous range.

Any thoughts?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Tue 5 May 2009, 10:22Trainer Amanda said...

RE: Filtering

Hello James

Thank you for your question and welcome to the forum.

Can you please clarify for me: when you are copying the filter results, are you using a standard copy (e.g. Ctrl+C, clicking the Copy button, right-clicking and selecting copy); or are you copying only the visible cells (which is a different option)?

Thanks.

Kind regards
Amanda

Reply Tue 5 May 2009, 10:27Delegate James said...

RE: Filtering

Hi Amanda

I am attempting to copy just the visible cells but I am doing it in the traditional way ie Ctrl+C.

Thanks
James

Reply Tue 5 May 2009, 10:45Trainer Amanda said...

RE: Filtering

Hi James

A couple of things I could suggest:

1. Try select and copy just the visible cells - use Ctrl+G to get to Go To, click Special; under Select, click Visible cells only, and then click OK. Then copy and paste.

2. Try using an Advanced Filter and select the option to Copy to another location, to isolate the results of the filter from your original list.

Kind regards
Amanda

Excel articles

· Tips for Transitioning to Excel 2007
· Benefits of learning about Excel charts
· Create Contrasting Coloured Rows In Excel
· How To Create An Excel Formula Using Data From Several Worksheets
· Learn How To Separate Text In Excel Into Separate Cells

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips