View Single Post
 
Old 04-29-2018, 09:23 AM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
I don't have an answer for FREEZE PANES. Sorry.

Regarding the fill handle. Highlight a row by clicking in a cell. The row is now highlighted and you should see the fill handle in the cell you clicked on. Grab the fill handle and drag the green outline to another row. Now click on the cell you wish to use the fill handle by clicking once in that cell. You will find that the green highlight does not follow in this scenario.

I can't take credit for the code as it is something I picked up somewhere but don't recall where.
Reply With Quote