Reset Bottom of an Excel spreadhseet

A

akkrug

Is there a way to reset the end of a spreadsheet to the last cell that has
information in it? When I press End Home, I am landing on row 6,448 even
though I selected rows 500 - 6448 and hit delete. Also, another basic
question. Sometimes a range of cells will increment to the next value and
sometimes they won't. Is this just due to formatting differences in the
cell?

Thanks.

Ken K. - 2191
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-how do I reset the cell to which I go with a Control End? 1
How do you reset the position that pressing CTRL-END moves you to? 2
Excel Cannot delete empty cells/rows 4
Tabs on bottom of sheet are all white in Group Mode. 7
Excessive white space at bottom of form when printing. 2
Macro to remove last 4 characters from the contents of a cell. 1
Macro for a one time triggered copy of cell value 8
Paste from Excel shows "Bottom of Form" 2

Top