 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / June 2006Filling only empty cells below each item in column
In a 600 or so row spreadsheet, in one column, about 15 % of the cells have content. The numbers of contiguous empty cells in that column vary. I need to automatically fill the empty cells with the contents of the cell above them. example: Before: After: A B C D A B C D Z Q J A Z Q J Z N M A Z N M Z N M A Z N M Z X X Y Z X X Y Z N M Z Z N M Z N M Z Z N M Z N M Z Z N M Z N M Z Z N M J L L M J L L M R S T J R S T Any suggestions? Thanks, Bruce Try the following... 1) Select the range of cells for your column, which includes blanks 2) Edit > Go To > Special > Blanks > Ok 3) Press = 4) Press the 'Up Arrow' 5) Confirm with CONTROL+ENTER Hope this helps! > In a 600 or so row spreadsheet, in one column, about 15 % of the cells > have content. The numbers of contiguous empty cells in that column vary. [quoted text clipped - 14 lines] > R S T J R S T > Any suggestions? Thanks, Bruce It sure did! Worked perfectly. Thanks very much! > Try the following... > 1) Select the range of cells for your column, which includes blanks [quoted text clipped - 22 lines] > > R S T J R S T > > Any suggestions? Thanks, Bruce |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.