How do i change the last cell on a worksheet?

G

Guest

I have somehow got a last cell on my worksheet at row 65536 when I click
CTRL+END. How do i change the last cell so that when I click CTRL+END it
only goes to row 150, which is the last row with data?
 
B

Bill Martin

Highlight all the rows from 151 to the end of the sheet, right click and
select "delete". Then save your file and close it. When you reopen the
file, it should be right.

Bill
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Changing position of last used cell 4
Find last row with data 3
How do I set the last cell in a worksheet? 2
Error message "cannot shift nonblank cells off the worksheet" 2
change last cell reference 1
Excel Error Help 1
Last Cell Problem 4

Top