LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MBBeginner
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stop auto fill from thinking for itself!!!!!!! 1vagrowr New Users to Excel 3 November 5th 05 03:27 PM
How do I auto fill blanks cells immediately below with the same i. leo Excel Discussion (Misc queries) 2 March 16th 05 06:03 PM
HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . waz Excel Worksheet Functions 2 December 29th 04 07:49 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"