Excel 2010 part 22

pdf
Số trang Excel 2010 part 22 10 Cỡ tệp Excel 2010 part 22 833 KB Lượt tải Excel 2010 part 22 0 Lượt đọc Excel 2010 part 22 0
Đánh giá Excel 2010 part 22
5 ( 12 lượt)
Nhấn vào bên dưới để tải tài liệu
Để tải xuống xem đầy đủ hãy nhấn vào bên trên
Chủ đề liên quan

Nội dung

3 Chapter 1 Collaborating with Other People Although you will most often create and edit an Excel workbook on your own, you may have some workbooks that require input from other people. For those times when you need to collaborate with other people on a workbook, Excel has the tools to get the job done. In this chapter, you learn many ways to collaborate on a workbook, including adding comments to a cell, sharing a workbook, e-mailing a workbook, and even working on a spreadsheet online. You also learn ways to make collaboration safer by protecting any data you do not want changed, tracking whatever changes are made by others, and accepting or rejecting those changes. 15_577639-ch13.indd 210 3/15/10 2:49 PM Add a Comment to a Cell . . . . . . . . . . . . . . . . . . . . . . . 212 Protect a Worksheet’s Data . . . . . . . . . . . . . . . . . . . . . 214 Protect a Workbook’s Structure and Windows . . . . . . . . . 216 Share a Workbook with Other Users. . . . . . . . . . . . . . . . 218 Track Workbook Changes . . . . . . . . . . . . . . . . . . . . . . . 220 Accept or Reject Workbook Changes . . . . . . . . . . . . . . . 222 Send a Workbook as an E-Mail Attachment . . . . . . . . . . . 224 Save Excel Data as a Web Page . . . . . . . . . . . . . . . . . . 226 Make a Workbook Compatible with Earlier Versions of Excel . . . . . . . . . . . . . . . . . . . . . . . . . . 228 Collaborate on a Workbook Online. . . . . . . . . . . . . . . . . 230 15_577639-ch13.indd 211 3/15/10 2:49 PM Add a Comment to a Cell If you have received a workbook from another person, you can provide feedback to that person by adding a comment to a cell in the workbook. A comment is often the best way to give feedback because it does not change anything on the worksheet itself. Comments are attached to a particular cell, and Excel displays an indicator on any cell that has a comment. When you hover your mouse pointer over such a cell, Excel displays the comment in a balloon. Add a Comment to a Cell Add a Comment 2 1 Click the cell you want to 3 comment on. 2 Click the Review tab. 3 Click New Comment ( ). Note: You can also right-click the cell and then click Insert Comment. 1 Excel displays a comment balloon. • Excel precedes the comment with your Excel user name. 4 Type your comment. 5 Click outside the comment 4 5 balloon. 212 15_577639-ch13.indd 212 3/15/10 2:49 PM 13 CHAPTER Collaborating with Other People • Excel adds a comment indicator ( ) to the top right corner of the cell. View a Comment 1 Move the mouse over the cell. • • 1 Can I edit or remove a comment? Yes. To edit an existing comment, click the cell that contains the comment, click the Review tab, click Edit Comment ( ) to open the comment in a balloon, and then edit the balloon text. To remove a comment, click the cell that contains the comment, click the Review tab, and then click Delete ( ). • Excel displays the comment in a balloon. In the Review tab, you can also click Next ( ) and Previous ( ) to run through the comments. In the Review tab, you can also click Show All Comments ( ) to display every comment at once. How do I change my Excel user name? When collaborating, your user name is important because it tells other people who added the comments. If your current user name consists of only your first name or your initials, you can change it. Click File and then click Options to open the Excel Options dialog box. Click the General tab and then use the User name text box to edit the name. Click OK. Note, however, that this does not change your user name in any existing comments. 213 15_577639-ch13.indd 213 3/15/10 2:49 PM Protect a Worksheet’s Data If you will be distributing a workbook to other people, you can enable Excel’s options for safeguarding worksheet data by activating the sheet’s protection feature. You can also configure the worksheet to require a password to unprotect it. There are two main methods you can use to safeguard worksheet data: You can unlock only those cells that users are allowed to edit, and you can configure a range to require a password before it can be edited. Protect a Worksheet’s Data 2 1 Display the worksheet you want to protect. 3 2 Click the Review tab. 3 Click Protect Sheet ( ). 1 Excel displays the Protect Sheet dialog box. 4 5 4 Make sure the Protect worksheet and contents of locked cells check box is activated ( ). 5 Use the Password to unprotect sheet password box to type a password, if required. 214 15_577639-ch13.indd 214 3/15/10 2:49 PM 13 CHAPTER Collaborating with Other People 6 Click the check box beside each action that you want to allow unauthorized users to perform ( changes to ). 7 Click OK. 6 7 If you specified a password, Excel asks you to confirm the password. 8 8 Type the password. 9 Click OK. 9 If you want to make changes to a worksheet, click the Review tab, click Unprotect Sheet ( ), type the unprotect password, and then click OK. When I protect a worksheet, no one can edit any of the cells. Is there a way to allow users to edit some of the cells? When I protect a worksheet, can I configure a range to require a password before a user can edit the range? Yes. This is useful if you have a data entry area or other range that you want other people to be able to edit, but you do not want them to alter any other part of the worksheet. First, unprotect the sheet if it is currently protected. Select the range you want to unlock, click Home, click Format, and then click Lock Cell to turn off that option for the selected range. Yes. First, unprotect the sheet if it is currently protected. Select the range you want to protect, click the Review tab, and then click Allow Users to Edit Ranges. In the Allow Users to Edit Ranges dialog box, click New to open the New Range dialog box. Type a title for the range, use the Range password box to type a password, and then click OK. When Excel prompts you to reenter the password, type the password and then click OK. 215 15_577639-ch13.indd 215 3/15/10 2:49 PM Protect a Workbook’s Structure and Windows You can prevent unwanted changes to a workbook by activating protection for the workbook’s windows and structure. You can also configure the workbook to require a password to unprotect it. You should protect a workbook’s structure when you do not want others to perform actions such as adding or deleting worksheets; you should protect a workbook’s windows when you do not want others to perform actions such as splitting a window or freezing panes. See the Tips on the following page to learn what Excel does when you protect a workbook’s structure and windows. Protect a Workbook’s Structure and Windows 1 Display the workbook you 2 want to protect. 3 2 Click the Review tab. 3 Click Protect Workbook ( ). 1 Excel displays the Protect Structure and Windows dialog box. 4 Click the Structure check box to protect the workbook’s structure ( changes to ). 5 Click the Windows check box to protect the workbook’s windows ( changes to ). 6 Type a password in the 5 4 6 7 Password text box, if required. 7 Click OK. 216 15_577639-ch13.indd 216 3/15/10 2:49 PM 13 CHAPTER Collaborating with Other People 8 If you specified a password, Excel asks you to confirm it. 9 8 Type the password. 9 Click OK. • • • If you protected the windows, Excel hides the window controls. If you protected the windows, Excel disables many windowrelated commands on the View tab. If you protected the structure, Excel disables most sheetrelated commands on the sheet shortcut menu. What happens when I protect a workbook’s structure? What happens when I protect a workbook’s windows? Excel disables most worksheetrelated commands, including Insert Sheet, Delete Sheet, Rename Sheet, Move or Copy Sheet, Tab Color, Hide Sheet, and Unhide Sheet. Excel also prevents the Scenario Manager from creating a summary report. Excel hides the window’s Close, Maximize, and Minimize buttons. If the workbook is not maximized, Excel also disables the window borders, which means the window cannot be moved, sized, or closed. Excel also disables the View tab’s New Window, Split, Freeze Panes, and View Side By Side commands when the window is active. 217 15_577639-ch13.indd 217 3/15/10 2:49 PM Share a Workbook with Other Users You can allow multiple users to modify a workbook simultaneously by sharing the workbook. Once you have shared a workbook, other users can open the workbook via a network connection and edit the file at the same time. When you share a workbook, Excel automatically begins tracking the changes made to the file. For more information on this feature, see “Track Workbook Changes” later in this chapter. Note, as well, that this task assumes you have saved the workbook in a folder that other people can access over the network. Share a Workbook with Other Users 2 1 Display the workbook you want to share. 3 2 Click the Review tab. 3 Click Share Workbook ( ). 1 The Share Workbook dialog box appears. 5 4 4 Click the Editing tab. 5 Click the Allow changes by more than one user at the same time check box ( changes to ). 6 Click OK. 6 218 15_577639-ch13.indd 218 3/15/10 2:49 PM 13 CHAPTER Collaborating with Other People Excel tells you that it will now save the workbook. 7 7 Click OK. Excel saves the workbook and activates sharing. • Excel displays [Shared] in the title bar. You and users on your network can now edit the workbook at the same time. How do I know if other people currently have the workbook open? 4 The Editing tab of the Share Workbook dialog box maintains a list of the users who have the workbook open. To see this list, follow these steps: 1 Display the shared workbook. 2 Click the Review tab. 3 Click . 5 The Share Workbook dialog box appears. 4 Click the Editing tab. • The Who has this workbook open now list displays the users who are currently editing the file. 5 Click OK. 219 15_577639-ch13.indd 219 3/15/10 2:49 PM
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.