My first posting, so if I'm doing this incorrectly, let me know.

Regarding question 2: When I want to do a quick "fill-down", I copy the
cell (ctrl+C), then select the first receiving cell & paste (ctrl+V).
With that cell active, I double click on the fill box and voilla! it
will fill down to the end of the last active row in that column.

Let me know what you think.

seagee69