filling multiple cells whislt using Filter

		Microsoft Office Forums > Microsoft Excel > Excel
filling multiple cells whislt using Filter

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-27-2011, 06:02 PM

VinceO

Windows XP filling multiple cells whislt using Filter

Office 2007

Novice

Join Date: Apr 2011

Location: melbourne, Australia

Posts: 1

filling multiple cells whislt using Filter

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.