let excel talk to you

heres a little known trick in excel 2007>
options/customise/all commands
scroll down and add speak cells to your quick access toolbar
now select a range of populated cells and click the speak cell icon

Now that's cool! Anyway to choose a different speaking voice? The default appears to be a midrange female voice.

hmm mine is a man
more here
http://support.microsoft.com/kb/306902 for xp

On the Start menu, point to Settings, and then click Control Panel.
Double-click the Speech icon.
Click the Text To Speech tab.
NOTE: The available voices depend on your default language installation and any language packs that you may have installed.

In the Voice selection box, click the voice that you want to use.
Click OK. but i only have Microsoft Sam to choose from
in win 7 its
Choose Start→Control Panel→Ease of Access→Text to Speech.
apparently this is also available pre excel 2007 as well eg for excel 2002

Enable Text-to-Speech

To turn on the Text-to-Speech (TTS) feature in Microsoft Excel, do one of the following:
On the View menu, point to Toolbars, and then click to select Text To Speech.

-or-
On the Tools menu, point to Speech, and then click to select Show Text To Speech Toolbar.

That's a pretty cool thang going on there! I don't know how practical this option is for most users but it is a fun toy to play with. I gave a like on this one.

And automate it

Please Login or Register  to view this content.

You can always use along with a userform to give periodic messages of progress so you don't have to look at the screen to see how far your code has progressed.

Or be some sort of trigger... etc.

abousetta

I saw this trick a few years back being used as an April Fools joke on co-workers.

didn't say it was new .most people don't either know it exists,or if they do they don't know where to find it in excel 2007!

I actually have used that tool for a few years now when comparing printed documents (that have revisions) with the original electronic versions. Very handy tool so you can avoid looking back and forth between the screen and paper (or between two screens if comparing to a scanned image).

blimey...i am not entering this as a realistic tip.. it's just to prove how pointless this whole exercise is! i can think of loads of obscure stuff. but my mirror trick is the least well known!
http://www.excelforum.com/july-compe...53-mirror.html

Too late. I'm having this tip bronzed.