In Excel, the method of batch adding hyperlink at home
You can input B4 = INDIRECT ($A4 &! “” F” & COLUMN (), then pull right and pull down. In the first table, you can build a content, you can quote several cell table content in every line. B4 = ’1′! F2, C4 = ’1′! F3, D4 = ’1′! F4… After setting up this line, how to set the following lines is as bellow, B4=’2′! F2、C4=’2′! F3、D4=’2′! F4 B4=’3′! F2、C4=’3′! F3、D4=’3′! F4 That is, after dragging down the cell table, it will automatic add the work cell table number, not the cell table number. On the basis of the above, in the same way, you can quote the maximum number on a certain line. In B4, you input formula: =indirect(row()-3&”!”&”F$2″ C4 =indirect(row()-3&”!”&”F$3″ F4 =indirect(row()-3&”!”&”F$4″ Then it is OK to drag down … Read entire article »
Filed under: software
The request of Office 2010 software for the disk space
Compare with Office 2007, Microsoft did not change a lot on the needs of CPU and RAM. However, most applications have more request on disk space. The majority of standard components disk space requirement increased 0.5 GB, the disk space of Office 2010 suite increased 1.0 or 1.5 GB. The reasons of Microsoft increasing disk space The Office 2010 have a lot of new features, new functions mean more codes. Even though you have installed 32 bit Office, we also have some changes on their codes to ensure that it can support 64 bit Office. The whole range of the Office use the interface of the Ribbon, in Office 2010, you will find that all applications use the Ribbon interface. Different suite, take Office pro as example, the Office 2007 does not include OneNote … Read entire article »
Filed under: software
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 Excel, use the function of pictures annotations to display pictures by clicking
Sometimes, in order to make the concise forms which have a large amount of information. We need to add the hidden pictures for the Excel table cells. When we click on the cell table, it will automatic display pictures, it will not display when we move away the mouse, is it very cool? In order to realize the interaction effect, we should use the function of picture annotations in the Excel. Next, we can take making products lists as example, the detailed method of adding pictures is as bellow. Right click on the target table cell, select the “add annotations”, delete all words in the annotations box. Then move the mouse to the border of the inputting box. When the mouse is becoming a cross. You can right click on the “set … Read entire article »
Filed under: software
How to quickly transform the office Word document into PPT files
First, you can open the Word document, select all, implement the order of copy. Then, start the PowerPoint, select the “ordinary” view, click on the “outline” label. If you do not have the TAB of outline and slide, the display method will appear in the view menu, click on the “ordinary (restoration pane)” or in the lower left corner of the window, click on the general view button. Directly select the outline view, locate the cursor to the first slide, implement the order of the paste, then insert all the contents in the word documents into the first PPT slice. Next, according to the needs of the text, we can set the following setup, including the font, font size, color and alignment form. Then you put the cursor to the location … Read entire article »
Filed under: software
The office skill that your excel form can only be seen and can not be modified
If it is a private file, you set a password for it. But the form is provided for everyone to input the data or serve as a reference for everyone. Sometimes, because of someone’s carelessness. We must redo the form. You spend a lot of efforts on your resume form, but it is destroyed because of others’ carelessness. Do you get mad on it? Now, I will teach you a good way, this method will make your excel to be seen only, it can not be moved. The approach is to set these cells as read only. You can select the cell tables, right click and set the cell tables. And clear the check box of the locking protection label, then we can set the protection of the working tables. At … Read entire article »
Filed under: software
Why can’t we open the word in the USB flash drive?
How to transfer the file in the Word to the USB flash drive? We should have a look at the version of the word in the USB flash drive, whether it is version 2003 or version 2007/2010? Open the word document, it will prompt you to start converter software, or the version is not compatible, or some important files are missing, then you can not open them normally. If your computer installed office 2003 version, and the word in your USB flash drive is also office 2003 version, we suggest you to unload the original program to reinstall in order to solve the problem that you are unable to normally open. If you install the other version of office procedures, we suggest you to download compatible bag of 2007 office system. After … Read entire article »
Filed under: software
The common problems in PPT
1, Automatic demonstrate the PPT file By default, PPT file will be opened and preserved with PPT extension, only by changing its extension into PPS, then it can paly the file automatic. Later on, as long as you double click on this file, the file will be played automatic, it is very convenient. 2, PPT screen automatic become black and write When we are playing the interactive documents, we may need to hide the presentation content temporarily. So we only need to click on the key B and W, the PPT screen will become into black and white screen. When we want to cancel, we just need to click on W or B. It is very convenient to help hide the presentation content. 3, Break the limit of only canceling for 20 times When we … Read entire article »
Filed under: software
Use the word to dressed up the Windows desktop
Word is our most commonly used text processing tools, the word is used to deal with the writing and tables, in fact, those are the basic usage for the Word. We can use the word to dress up our desktop. The calendar on the desktop Because of the insert function of the Word, therefore we can insert a calendar in the word document, then as the document as a HTML. And then come back to the setting of the desktop, when we are setting the wall paper, we can choose the HTML document just saved, the it can show the calendar on the desktop. After starting the Word 2003, we can open the command of object under the menu of insert. In the pop-up dialog box of object. In the “object type”, we … Read entire article »
Filed under: office 2010, software
Cancel some uncommonly used Word function to accelerate speed
Deduce the word functions which are rarely used, you can increase its working efficiency. Too much function will give too heavy baggage to the word, which will lead to slowly operation. 1,The task pane When we start the Word program, the task pane will automatic load. The task pane include “open” and “other” and “create new document”. In the open column, it will list the recently used files, in the other column, we may open the other documents, in new document column we can create a file. And we usually open a new article, double click on the Word icon on the desktop, it will automatically open a new document, if we want to open an new article, we can click on the button of open in the toolbar. Therefore, the task … Read entire article »
Filed under: software