filling multiple cells whislt using Filter

VinceO · #1 04-27-2011, 06:02 PM

In Excel 2003 I was able to use the CTRL+ENTER to fill multiple cells with the same data (even when filter was on).

The data would not populate in the hidden cells BUT in 2007 version when I use the filter and then use the CTRL+ENTER shortcut, it fills the data in all cells including the hidden ones which I don’t want then to fill.

Any idea how to do this in Excel 2007? Is there a shortcut for it??

Thanks heaps

OTPM · #2 05-09-2011, 06:38 AM

Hi Vince
When you filter simpy highlight the range of filtered cells and right-click then paste. It works fine for me.
Tony

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling the consecutive cell by day.	aligahk06	Excel	1	09-15-2010 08:17 AM
Show not filling screen, left to right	dougleax	PowerPoint	2	07-14-2010 06:50 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM