Geeky Ch1ck

Geeky stuff

Get Excel to read your data back to you July 16, 2008

Filed under: Office 2007,tips and tricks,website — Geeky Chick @ 16:11
Tags:

It’s always such a nightmare entering loads of figures into an excel spreadsheet and then having to try and check the figures are right, isn’t it?

Did you know Excel can READ the data (numbers and words) back to you so you can manually check the original data? Nor did I until I read the latest tip from tech-recipes.

Here’s what they say to do:

  1. Open Excel 2007 and go to the Quick Access Toolbar at the top of the window.
  2. Click the downward point arrow to the right of the toolbar and select More Commands.
  3. From the dropdown menu, select Commands Not in the Ribbon.
  4. Scroll down the list and find Speak Cells, Speak Cells — Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speak Cells on Enter. Add each of these by selecting them one-by-one and clicking the Add button. Click OK after all 5 commands have been added.
  5. Now go to your spreadsheet and select the cells you want Excel to read by performing a simple click and drag. Once the data is selected, go to the Quick Access toolbar and select either Speak Cells by Columns or Speak Cells by Rows. When you are ready for Excel to begin reading off the data contained in the selected cells, select Speak Cells and Excel will begin reading out the data to you.
  6. If you need Excel to stop reading, simply select Speak Cells – Stop Speaking Cells.

Admittedly having all those items on your quick access toolbar is a bit clunky, but you can always remove them, I suppose?

Advertisements
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s