×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

default page location

default page location

default page location

(OP)
Not exactly an engineering question, but is there any way to set a view of a spreadsheet so that when it opens it's scrolled to the right, not to the left?

I'm using someone else's sheet and there's some useless stuff on the left and some useful stuff to the right and either I have to scroll over every time I open it, or else zoom out (it'll remember the zoom level next time but then I'm looking at smaller numbers).

Hg

Eng-Tips policies:  FAQ731-376

RE: default page location

If they are useless, you can highlight the column, right click and then hide the useless columns.

RE: default page location

Try scrolling to where you want to be, then doing a 'save as' using a new file name. If you need to keep the existing file name just insert a space into an empty cell, then save the file. When you open the saved file you should be scrolled to where it was when you saved it

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

RE: default page location

Place this in VBA Module 1 (edit to your workbook name, spreadsheet name, cell location.
===============================

Sub Auto_Open()

    Workbooks("your spreadsheet name.xls").Worksheets("the sheet you want to see").Activate
    Range("cell where you want the cursor").Select

End Sub

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources