Teach you how to use Excel to chat

Work is always not so free, chatting with QQ for a day like a thief, but playing Excel is no matter. If you want to talk to colleagues for a day or girlfriend just in the same unit how to obedient while look? teach you how to use Excel to chat, to prevent the boss's ace.

★ First Step: Open Excel2003, create a new workbook document, name Save (such as "work record. xls").

★ Step Two: Execute tools → shared workbook, open the Shared Workbook dialog box (see Figure 1), select the Allow multiple users to edit simultaneously, and Allow workbook merge option to confirm the return.

★ Step Three: Save the workbook document in a shared folder on a computer on the local area network.

★ Fourth Step: The local Area network users open the above workbook at the same time, we agreed that the input of the cell location (such as a user in a column input, b column input time; b users in C column input content, D column input time ...).

★ Fifth Step: Select the corresponding cell (such as A1), the chat content into which, and then select B1 cell, press the "ctrl+shift+;" Enter the system current time by combining keys.

★ Sixth Step: Click on the Toolbar "Save" button, the above input to save, the other side just click the "Save" button, you can see the above input content.

★ Seventh Step: If the boss comes, just switch to other worksheets (such as Sheet2) (you can enter some work-related content in advance), you can switch to "working status." It's both convenient and safe!

Small Tips

Improve efficiency, multiple people at the same time input an Excel file this application mainly uses the Excel "allows many users simultaneously to edit, simultaneously allows the workbook to merge" The function, in the actual work, may use for many people to enter an Excel form together, the Excel will automatically maintain the information unceasingly to update. For example: There are a, B, C, D four users to work together to complete the 2005.xls file entry, first open the file, and click on the operation of the above check "allow multiple users to edit simultaneously, while allowing workbook merge", and finally click "file → Save as", save it in E computer D disk. The next four users will be able to enter the file at the same time.