Microsoft Office Tutorials and References
In Depth Information
Opening Your Workbooks for Editing
As the preceding fable points out, editing a worksheet in a workbook can
occur on different levels:
You can make changes that affect the contents of the cells, such as
copying a row of column headings or moving a table to a new area in a
particular worksheet.
You can make changes that affect the structure of a worksheet itself,
such as inserting new columns or rows (so that you can enter new data
originally left out) or deleting unnecessary columns or rows from an
existing table so that you don’t leave any gaps.
You can even make changes to the number of worksheets in a workbook
(by either adding or deleting sheets).
In this chapter, you discover how to make these types of changes safely to a
workbook. As you see, the mechanics of copying and moving data or
inserting and deleting rows are simple to master. It’s the impact that such actions
have on the worksheet that takes a little more effort to understand. Not to
worry! You always have the Undo feature to fall back on for those (hopefully
rare) times when you make a little tiny change that throws an entire
worksheet into complete and utter chaos.
In the final section of this chapter (“Eliminating Errors with Text to Speech”),
you find out how to use the Text to Speech feature to check out and confirm
the accuracy of the data entries you make in your worksheets. With Text to
Speech, you can listen to your computer read back a series of cell entries while
you visually corroborate their accuracy from the original source document.
Text to Speech can make this sort of routine and otherwise labor-intensive
editing much easier and greatly increase the accuracy of your spreadsheets.
Opening Your Workbooks for Editing
Before you can do any damage — I mean, make any changes — in a
workbook, you have to open it up in Excel. To open a workbook from within Excel,
you can choose File Open, press Alt+FO, or use the old standby keyboard
shortcuts Ctrl+O or Ctrl+F12.
When you use the Ctrl+F12 shortcut, as opposed to any of the other
methods for opening a workbook, Excel 2013 bypasses the Open screen and takes
you directly to the Open dialog box. This is fine provided that the workbook
file you need to work with is in the currently open folder (by default, this is
the Documents folder in the Libraries folder on your local hard drive, unless
you’ve opened files from another folder and drive during your work session).
Search JabSto ::




Custom Search