Thread: [Solved] filling multiple cells whislt using Filter
View Single Post
 
Old 04-27-2011, 06:02 PM
VinceO VinceO is offline Windows XP Office 2007
Novice
  
Join Date: Apr 2011
Location: melbourne, Australia
Posts: 1
VinceO is on a distinguished road
Exclamation 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
Reply With Quote