Excel speech reading table data easily complete data checking

Work often need to carefully proofread a variety of complex Excel table data, if all rely on the eye proofing, it is easy to make mistakes. If the Excel table can read the table data, not only does it reduce the amount of work, it's not easy to make mistakes.

In Excel2003, we can use the read-aloud cell feature by selecting the Text To Speech check box from the View-toolbar. Because this feature is not the default when you install Excel, you are prompted to insert the Office CD to install this feature on the first use.

When used, open the text To Speech toolbar, data file with the mouse to select the first data to read aloud, and then according to the arrangement of the data to choose whether the "by row" or "by the column" to read aloud, when the setting is complete, click the "Aloud cell" button on it.

If you select the "Start aloud by entering" button, you can also enter the data on the side of the speech proofing, so that after the completion of a cell input and press ENTER, Excel will automatically read the contents of the cell.

EXCEL2007 also has this feature, but it is not easy to find, the default label or the Ribbon can not be found, the user needs to customize settings. Let's look at where the voice reading in Excel2007 is hidden, and then add the voice to the Excel2007 Quick Launch toolbar.

Right-click the Rounded Office button in the upper-left corner of the Excel2007 and choose Customize Quick Access Toolbar from the right-click menu.

On the Customize Quick Access Toolbar tab, select commands that are not in the Ribbon from the Select commands from the Drop-down menu below.