How can I set a "page end" point on a large worksheet?

K

kpetefaith

I am a fairly new user to Excel. I have created a worksheet with over 200
lines of data. When I use the "control end" shortcut, I end up way down at
the end, if you know what I mean.
Is there a way to set the end of my page at the actual end of my data?

Thanks.
 
N

Nadine

Dave,
Have you tested this? I did this and it didn't remove the extra rows.
Could be user error but I wanted to check anyway.
 
D

Dave Peterson

Yep.

Did you remember to save the workbook. There's a note on that page that some
versions require saving (and closing/reopening???).
 

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

Getting To End Of Worksheet 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Create a yes no message on a command button on click 0
How do I get worksheet to end after last entry 2
move worksheet to end of another workbook 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
control end in a macro 1

Top