Useful tips from Microsoft!

Topic

New Reply

Hi all

While researching an Excel problem just now I came across this Microsoft tips article from a few years back:

http://support.microsoft.com/kb/843504/EN-US

Some of the tips will be well known to regulars, but some are new to me, and a couple are revelations – especially the ones about using F9 to evaluate part of a long formula and using 39% zoom to show named ranges.

Ian.

Reply | Quote

Replies

Some useful tips! Thanks for the post.

Reply | Quote

I love this one:

“Do not open and save directly from a floppy disk”

Anyone still use a floppy disk?

Alan

Reply | Quote

Would that be 8 inch, 5 1/4 inch or 3 1/2 inch? Cue stories about users folding the disk to fit in the smaller slot. A few years ago firmware updates on a Windows Server required a floppy disk. And the disk controller had a connector for the one I salvaged from a very old PC abandoned in the loft.

Another thread on this forum, re mysterious changes to link paths, would extend the tip to “do not open and save directly from a network drive or web folder”!

Ian.

Reply | Quote