default page location

[HgTX]

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

 

[COEngineeer]

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

 

[johnwm]

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:

http://www.essexsteam.co.uk

 

[psafety]

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

Sub Autpen()

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

End Sub