|
|
#1
04-27-2011, 06:02 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows XP 
Office 2007
Threaded Mode