Stopping at bottom of spread sheet [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I often have to format a whole column with the same formula. I click the corner and pull it down which works fine. The frustrating part is that My column may be 150 cels down but the auto fill leaps to 800 plus. How can I put a bottom on the sheet I am using?

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Select the unnecessary rows at the end and DELETE the rows selected. SAVE the file and reopen. The try again

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!