The file wont remember the way I left it

[kevs14]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a work book. I drag the bottom right corner to get rid of lots of right end columns that are showning. close, reopen, those colums are back. Any way to get excel to remember how I like it? thanks!

 

[Phillip Jones, C.E.T.]

Your sort of doing it right. But no quite.

first click on the little green button in the set of stoplight buttons
to make the window open to its fullest height and width. Drag to fill
screen. Now click again. and this time drag to hide the columns now
click the green button to return to full view. then click again to go
back to your other view. if it there then shut down Excel. wait a few
seconds. Open excel. and it should be there. if not try clicking green
button and see if it set to you preset view.

What I do instead though rather than re-size. I simply do custom zoom
File menu > zoom and set the Columns disappear. once you save the file
it will all ways zoom to that level until you set it again.

Makes a lot easier to read as well.

 

[kevs14]

Phillip
Dang, I tried that, did not stick. Still opens with the uneeded colulmns.
Zoom is under edit, not file No?
Did not understand "set the columns disappear"

 

[CyberTaz]

After you size the window as you want it make some sort of change in the
workbook (type something into a cell then delete it - but don't Undo), then
save & close the file.

 

[kevs14]

Bob,
did just that now, still did not stick, I'm really stunned as I thought that would work. Not at all.

 

[kevs14]

thanks Bob, I'm still at a loss it though. things just don't stick, maybe it's just going to be that way for workbooks I also open on laptop via my network?

 

[John McGhie]

Each computer you open that file on is going to format its display ratios
for the screen in use at the time.

The display settings will be saved with the file when you close it.

If you next open the file on a different machine, the display settings will
be wrong on that machine.

Install the opening macro I sent you on both machines, and set it on each
machine to set the display appropriately for that machine. It overrides the
display settings stored in the file.

Cheers

thanks Bob, I'm still at a loss it though. things just don't stick, maybe it's
just going to be that way for workbooks I also open on laptop via my network?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[kevs14]

Thanks John, that could explain some other issues as well now that I'm looking at workbooks on my laptop via my home router.

Which thread is that macro on?

Currently I just adjust the percentage for each machine to taste.

 

[John McGhie]

Hi Kevs:

Sorry, I don't keep a record of the stuff I send to you: I assume you saved
the macro somewhere when you got it? It was last year sometime...

Cheers

Thanks John, that could explain some other issues as well now that I'm looking
at workbooks on my laptop via my home router.

Which thread is that macro on?

Currently I just adjust the percentage for each machine to taste.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[kevs14]

I may have it.
But you know my history with Macros. They sometimes crash the program so I stay away from them if at all possible. thanks John!