officehotblog.com » Archive
The method of data Synchronism in the Word and Excel
Step1, copy paragraphs Open the Word documents, then open the word data and Excel worktable, then press enter butter, at this time there will be a paragraph mark. Select two paragraph marks, then copy. Step2, paste link Switch to the Excel editing window, right click on the data column, select paste special, in the pop-up window, you can click on paste link, then the document object in the Microsoft Office word, then make sure and exit. Step3, synchronous input Back to the Word document, input contents including images and form. After a few seconds, the Excel will display the modified Word data, thus you can achieve the purpose of synchronizing data. If you want to make synchronous faster, then you can click on the tool bar in the Word. During inputting contents in the word, … Read entire article »
Filed under: office 2010
In excel, how could we quickly switch workbook
For the less workbook switch, you can click on the window of the workbook. If you want to switch many windows, it is more convenient to use the window menu. On the bottom of the window menu, it has listed the names of the workbooks, if you want to switch to another bookwork, you just need to select its name from the window menu. There are 9 workbooks in the window book at most, if there are more than 9 windows, there will be a option named multiple window, select this order, there will be a dialog box which will list all the opened workbook, you just need to click on the name you need. … Read entire article »
Filed under: office 2010
Two skills to accelerate the Excel operation
1, Rapidly get the help window For the toolbar or screen area, you just need to press the combination keys of Shift and F1, then use the mouse to click on the toolbar button or screen area. Then it will pop up the help window, and it will tell you the detailed help information. 2, Rapidly move or copy the cell tables First you can select the cell tables, then move the mouse pointer to the border of the cell tables, left click and drag it to the new position, then loose the button and move it. If you want to copy the cell tables, then before you loose the mouse, you can press the Ctrl key. … Read entire article »
Filed under: office 2010
The security levels of the office document
For the Word document, the biggest danger is the macrovirus, in order to prevent it, the word has set the concept of security levels. Click on tools – > options – >” security “TAB – macro security, do some setup in the security level” there are high, middle and low three levels. High level will only operate the reliable macro, and cancel any other macro. Open a macro in the middle level, you will see a warm, you choose whether use it. In the low level, it is not necessary to protect. When you are choosing the high level, the installed templates and add-ons (including guide) may be forbidden to be used. You only click on the TAB of reliable source in the “tools – > options – > security – … Read entire article »
Filed under: office 2010
Transform the tables in the notebook into the tables of the excel
Recently, I download a table on the Internet. After opening, I find that the extension name is . Txt, while we need the electronic form whose extension name is called “. XLS “. Therefore I tried many methods, but I still can realize it. At first, you can open the file in the notebook, then you can select the button of saving as in the menu, then you can select all files, then add WPS in the files bar, then you can transform into the Kingsoft form. You can open it in Kingsoft Word, you can click on save as, then select the form of . Doc “, then you can convert into the Word format. Use Word2003 to open the file, you should notice that you should delete every enter key … Read entire article »
Filed under: office 2010
Play the appointed part of voice in Power Point 2007
This operation is suitable to be used to play a part of the voice instead of the whole voice document. For example, repeat play the most wonderful part in the text. The detailed operation is as bellow, (1) you can select the object of the insertion of the menu, select the button of create, in the object type, you can choose the “media editing”, then get in the media editing window. (2)you can click on the button of inserting the clip, there are three voices, CD audio and MIDI sequencer, sound (WAV), you can choose the related type according to the sound type. (3) after selecting the voice files, you can use the voice controller as available, set the pointer to the starting point of the voice, click on start selection of the controller, … Read entire article »
Filed under: software
In office 2007, quick visit your favorite function
In Office 2007, we have already find all the options in the menu by the new users interface. At the same time, the Word 2007 provide the chances of creating personalized tool boxes for the users, you can add the often used options in the tool box, then you can operate the order by clicking, this tool box is the “quick access toolbar”. The detailed operation is as bellow, 1. You can think back, when you open and edit a certain document, which function is reached by you by a single operation? In the function zone, you can switch TAB or browse the menu of Office button, you can find the function. 2. In such function, you can right click. And operate the order of adding it to the quick access toolbar in the … Read entire article »
Filed under: office 2007
In PPT 2007, how could we copy the chart without changing the color?
Such as the theme color, after copying, it will change color, then it will look discordantly. Do we have a method that we can copy others’ PTT without changing the color? Yes, you can. After you copying others’ works, you should notice the small button on the right corner, there is a small icon which is to paste, you can click on it, select the button of remaining the old format. How could recover the old font color do the operation of hyperlinks in Microsoft Office PowerPoint 2007? If you are doing the operation of hyperlinks on the font, after clicking on it, it will change color. There is a substitution to it. You can do the hyperlink to the text box, then you can avoid the color changes on the test. You can … Read entire article »
Filed under: office 2010
How could we add hyperlink in the excel?
For example, the hyperlink contents are at A1, and the displayed contents are at B1, how could we do it? I am not so clear about the meaning of the hyperlink contents. I will give you an example: A1 formula: =HYPERLINK(“#sheet1!B”&row(),”B”&row) After inputting formula A1, it will become into the hyperlink of content “B1″. Then it is OK to drag it. If A1: is “http://www.norun.cn” B1 is computer technology C1 will be written in formula: = hyperlink (A1, B1) Or B1 oneself can be revised as formula: = hyperlink (A1, “computer technology”) … Read entire article »
Filed under: office 2010
In the word, how could we input the double underline
1, the simplest method is to use the line tool to draw a line by hand, then you can change the line shape and color. This method is the simplest and most practical, and the inserted line will be together with the document. 2, In the Word, there is no setting about the weight of the underline. But you can realize it by a particular method. But this method is only suitable to add the underline for the whole line. Input the words you need, then add the underline. Set the underline type as thick. After the inputting for the whole line, you can continue pressing three enter button. At this time, you can see the effect. But the problems are not ending. You will find that the line space is bigger … Read entire article »
Filed under: office 2010