![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Hi Vince
When you filter simpy highlight the range of filtered cells and right-click then paste. It works fine for me. Tony |
![]() |
|
![]() |
||||
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 |
![]() |
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
![]() |
justziggy | Word | 5 | 05-23-2009 02:33 AM |