Pasting into filtered data

Resolved · Low Priority · Version 2013

Tue 17 May 2016, 16:44 Delegate Marianna said...

Marianna has attended:
Excel Advanced course

Pasting into filtered data

When I filter data in a column and then want to replace the filtered values by another value, the new value seems to be copied across the whole column rather than just selected (filtered)cells. i.e. I filter for zeros in a colum and replace them with 'non applicable', it places 'non applicable' to all cells, not only the cells with zero values. Any advice?

Wed 18 May 2016, 10:31 Edited on Wed 18 May 2016, 10:32 Trainer Doug said...

RE: Pasting into filtered data

Hi Marianna

Thanks for your forum question.

Please can I check how you replace the filtered data?
If you type N/A over the first 0 then Autofill down it works. But if you copy and paste data on top of the filtered data it doesn't.

A second way is to highlight all the filtered 0's, type N/A and press Control + Enter.

please let me know if that helps.

Regards
Doug
Best STL

Thu 2 Jun 2016, 14:10 Trainer Doug said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 9 Jun 2016: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips