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:
- Open Excel 2007 and go to the Quick Access Toolbar at the top of the window.
- Click the downward point arrow to the right of the toolbar and select More Commands.
- From the dropdown menu, select Commands Not in the Ribbon.
- 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.
- 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.
- 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?