Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

vertical scroll bar setting

Status
Not open for further replies.

mart10

MIS
Joined
Nov 2, 2007
Messages
394
Location
GB
using Excel 2013. I have inherited a spreadsheet. data goes down about 400 rows and yet vertical scroll bar seems to be setup to go on for ever until end! How do I reset to sensible setting, not sure what has been done by others to leave it like this
 
Hi,

Select ALL rows after the 400.

Right-click Delete Shift up
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top