Stopping at bottom of spread sheet

Closed
mrs slim - May 17, 2009 at 10:29 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - May 18, 2009 at 07:50 AM
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?
Related:

1 response

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