Articles Comments

officehotblog.com » office 2010

Some notice in the office

1. Cancel the function of automatically replacing hyperlink Select the menu order of tool and auto correct, in the pop up interface, you can choose the TAB of automatic using the format when input. And cancel the check box of replace Internet and net path as hyperlink. 2. Cancel the checking of spelling and grammar In default, do the automatic spelling checking when you are input, and red waving lines mean the spelling problems, and green wave underline means the grammar problems. The method of canceling it should be choose the menu and option, in the pop up dialog box of option, then respectively click on the check box of “hidden in the document spelling mistakes” and “hidden grammatical errors in the document”. … Read entire article »

Filed under: office 2007, office 2010, software

How to batch set hyperlink in Excel?

When we are using Office2003, we need to set a hyperlink in it. How could we make it? use the names of macro 3.0 worktables. Press Ctrl + F3, then appear the self defined dialog box, and name it as X, and input it in the reference place. =MID(GET.WORKBOOK(1),FIND(“]”,GET.WORKBOOK(1))+1,100) Then click on Sure. … Read entire article »

Filed under: office 2007, office 2010

How to set the shortcut key

Step 1, set a new word document, select tool, macro and record a new macro, in the dialog box of macro, you can type in the macro name. Then click on the tool bar button again, in the dialog box of order, you can drag the Normal. NewMacros. Macrol to the word tool bar. Then exit. Step 2, then there will be a small window which named as recording macro. At this time, we need to record the detailed signature. Then when we are recording the macro, we can click on it and stop recording. Thus we have add all of the signature macro. Step 3, then select tool, macro and record new macro, select the macro name we just record, them click on the keyboard icon again. And switch the icon … Read entire article »

Filed under: office 2007, office 2010

In the word, how could we input emphasis mark?

When we are using the word, it is really inconvenient to use the emphasis marks. You can finish it in the font dialog box, it is really troubled to operate it. According to the study of the web page, it is really convenient to input the marks of emphasis, then we need to add a button of emphasis marks. Click on “tools/custom”, open the dialog box of “custom”, select the TAB of order in the dialog box of custom. Then select the option of all orders in the list box, then select the order of DotAccent in the right list box. Drag the order of “DotAccent” to the form toolbar, at this time there will be a button of ABC in the form. … Read entire article »

Filed under: office 2007, office 2010

Some tips in office

    1. Cancel Office assistant Right click on the icon of office assistant, choose the order of option in the pop up shortcut menu. And choose option TAB in the interface of office assistant, cancel the check box of using office helper.   2. Cancel the function of automatically replacing hyperlink Select the menu order of tool and auto correct, in the pop up interface, you can choose the TAB of automatic using the format when input. And cancel the check box of replace Internet and net path as hyperlink.   3. Cancel the checking of spelling and grammar In default, do the automatic spelling checking when you are input, and red waving lines mean the spelling problems, and green wave underline means the grammar problems. The method of canceling it should be choose the menu and option, … Read entire article »

Filed under: office 2010

Transfer PDF into DOC

In our daily life, we often need to transfer from PDF to DOC, in the situation that you dod not install the Adobe Acrobat. Then you can use the Microsoft Office Document Imaging component in the Microsoft Office 2007 suite to realize the transfer from PDF to DOC. The detailed steps are as bellow, Step 1, print as image files Open the PDF documents in the Adobe Reader, and operate the print order in the file menu, at this time, it will pop up the printing dialog box. In general default situation, the default printer is the real printer but not virtual printer. Therefore, you need to select the “Microsoft Office Document Imaging Writer” in the drop down list. Then click on the make sure button, then you can transfer  from PDF … Read entire article »

Filed under: office 2010

Common problem in the word, switch insert and rewrite state

When we are editing word document, we often insert something new in the existed contents, however, when we are inputting the contents, we will change the original contents, what is the matter? If you have such situation, that means you are in the rewriting state, you should change the rewriting state into inserting state. The method is very simple, as long as you double click on the button of rewrite in the bottom state bar, then you can get into the rewrite mode. When the rewrite button is in the overstriking state, that means that you are in the rewriting mode, when the rewrite button is gray, that means that you are in the inserting mode. There is an easier method, you can directly press the Insert button on the keyboard, then you … Read entire article »

Filed under: office 2010

How could we set page header and page foot

1, Page header At first, choose the right position in the document. Click on insert – separator – next page section break, you can also press the shortcut keys of Ctrl + Enter, then click on view – the header and footer in the menu bar, then close it and edit the page header, after editing, you can click on the button of showing the next option, then it will download and repeat the above operation and edit next page header. Second we also can click on the file – page Settings, then open the dialog of page setting, click on the TAB of format, in the option of page setup, you can select odd and even page different or first page different, you can get the effect.   2, Page foot After the page … Read entire article »

Filed under: office 2010

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