Page 515 - Excel 2013 All-in-One For Dummies
P. 515
Sharing Your Workbooks Online 497
4. Select the check box in front of the name of the workbook file you
want to edit with the Excel web app to select the file.
When you select the name of the Excel workbook file to edit, the SkyDrive page displays the current Share status of the file underneath a list of viewing and editing options in a column on the right side of the page. (See Figure 4-2.)
5. Click the Edit in Browser link in the right column of options (or simply click the workbook’s filename in the middle of the page).
Your web browser opens the workbook in the Excel web app on a new page (similar to the one shown in Figure 4-3) that replaces your SkyDrive page. This workbook contains all the worksheets that you’ve placed in the file with their tabs displayed.
You can then use the option buttons on the Home and Insert tabs (most of which are identical those found on the Home and Insert tabs on the Excel 2013 Ribbon) to modify the layout or formatting of the data and charts on any of its sheets. You can also add new data to the worksheets as well as edit existing data just as you do in Excel 2013.
Figure 4-2:
Selecting the Excel workbook on my SkyDrive to edit online with the Excel web app.
Book IV Chapter 4
Sharing Workbooks and Worksheet Data