| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto fill long col. filling blanks with last filled cell
On a large worksheet, is there a way to fill the blanks in a column with the
last filled cell without using the autofill handle? My worksheet is over 2000 rows and I am hoping to find some way to mass fill the blanks in Excel. Here is a small example of what I am talking about. Thanks for any tips. S1475 201686 506456 S1888 38254 15623 56731 S9564 46321 156323 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I auto fill long col. filling blanks with last filled cell
M,
This ought to work... http://j-walk.com/ss/excel/usertips/tip040.htm Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "MBBeginner" wrote in message ... On a large worksheet, is there a way to fill the blanks in a column with the last filled cell without using the autofill handle? My worksheet is over 2000 rows and I am hoping to find some way to mass fill the blanks in Excel. Here is a small example of what I am talking about. Thanks for any tips. S1475 201686 506456 S1888 38254 15623 56731 S9564 46321 156323 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I auto fill long col. filling blanks with last filled cell
Debra Dalgleish has some techniques at:
http://www.contextures.com/xlDataEntry02.html Try the manual method. I've found it's quicker than the code! MBBeginner wrote: On a large worksheet, is there a way to fill the blanks in a column with the last filled cell without using the autofill handle? My worksheet is over 2000 rows and I am hoping to find some way to mass fill the blanks in Excel. Here is a small example of what I am talking about. Thanks for any tips. S1475 201686 506456 S1888 38254 15623 56731 S9564 46321 156323 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I auto fill long col. filling blanks with last filled c
It worked. I cannot tell you how thrilled I am. Thank you so much.
"Dave Peterson" wrote: Debra Dalgleish has some techniques at: http://www.contextures.com/xlDataEntry02.html Try the manual method. I've found it's quicker than the code! MBBeginner wrote: On a large worksheet, is there a way to fill the blanks in a column with the last filled cell without using the autofill handle? My worksheet is over 2000 rows and I am hoping to find some way to mass fill the blanks in Excel. Here is a small example of what I am talking about. Thanks for any tips. S1475 201686 506456 S1888 38254 15623 56731 S9564 46321 156323 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
| How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
