LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mikeytj
 
Posts: n/a
Default Using Excel Auto Fill

I have columns in my spreadsheet that all contain information, but along with
blank rows. I want the auto fill feature to recognize date from the entire
column, not just that up to the last blank. Example:

A
B
C
D
Blank
E
F
If I start typing here with the contents of A it will not see it due to the
blank row. Can anyone tell me how to get it to recognize the entire column?

Thanks
Mike
 
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
Excel 2000 Auto Opens 24 files on startup CSUFAlex Excel Discussion (Misc queries) 7 January 20th 06 01:30 AM
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM
autoshape fill problems in Excel 2003 kcole Excel Discussion (Misc queries) 0 June 2nd 05 10:14 PM
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 05:48 AM.

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"