tailieunhanh - how to do everything with ms office excel 2003 phần 8

Để xóa các giá trị từ các bảng dữ liệu, chọn phạm vi của các tế bào có chứa các giá trị, và sau đó chọn | Xoá | Nội dung hoặc nhấn phím Hãy chắc chắn rằng bạn không chọn bất kỳ tế bào công thức. Để xóa toàn bộ một bảng dữ liệu, chọn tất cả các tế bào trong phạm vi nó chiếm, bao gồm tất cả các tế bào có chứa công thức, và sau đó chọn Tất cả. | 290 How to Do Everything with Microsoft Office Excel 2003 changes to a different file for example so that you can integrate them later or click the Cancel button to cancel opening the original file. CAUTION Excel doesn t keep a waiting list of notifications requested for a file. If two or more people ask to be notified when the same file is available Excel notifies them both or all when it discovers the file is available. So if you re competing with your colleagues for a workbook act quickly when Excel displays the File Now Available dialog box. As you can see from this description sharing a file by placing it on a shared drive is tolerable for small or informal workgroups but is unlikely to work well in large or busy offices. However sharing a file this way does have one significant advantage that you should be aware of each user who opens it separately can take any action that Excel supports unless you restrict what they can do as discussed in Restrict Data and Protect Workbooks later in this chapter anything from enter data in cells to insert cells to insert worksheets to record macros. By contrast when you share a workbook using Excel s sharing feature Excel clamps right down on what users can do in the workbook. Configure Sharing on a Workbook To get around the problems discussed in the previous section Excel lets you configure a workbook for sharing so that multiple users can have it open for editing at the same time. To configure a workbook for sharing follow these steps 1. Choose Tools Share Workbook to display the Share Workbook dialog box. 2. On the Editing tab shown on the left in Figure 14-1 select the Allow Changes by More Than One User at the Same Time check box. NOTE The Who Has This Workbook Open Now list box shows the users who currently have the workbook open. When you re enabling sharing on a workbook only your name should be listed here and it should be marked Exclusive. After you share the workbook you may need to revisit the Editing tab and .