Others

=counta () is a cell that counts content =countblank () is a statistical blank cell You can add two functions to the parentheses you want. You can enter your data range. All with a formula on the line, directly fill the formula can be. You can

Any software has a dead end, every software programmer wants to do this software can be universal. But every person with software wants to use the software to be very suitable for themselves, there is no corner. This is why a good software also

A Word document also looks like dozens of K, but imagine that when you have hundreds of different data files in your computer, you will occupy a large portion of your hard disk space. And compared to Notepad, the same content, Notepad only a few KB,

We find information on the Internet, often need to copy the entire content of the page, and then paste into the word file, will inevitably encounter a lot of links, at this time how can we delete these links? Shortcut keys Delete We can quickly

Excel sets the function of printing the top header row, as shown in the following figure: Version 2003: File > Page setup > Worksheet Versions 2007 and 2010: page layouts > Page settings > Print titles But Excel doesn't give us the ability to

Colleagues in the Word document is not displayed in the picture, ask me how, this problem I have met many times, in fact, there are many problems, to be one after the other, the following Icech will be all possible reasons and solutions listed for

Q: There is no problem with the Excel cell settings, why the text display is not full Answer: Is it a number or a text? If it's a number, maybe the cell format needs to be adjusted to improve the accuracy. Text display is not complete, is not the

The left and right should be each line, up and down is each two lines. Top is a page margin, a header line The bottom is a page margin, a footer line When you print a preview in Excel, you find a piece of white paper with two lines, two lines

In the big game, the medal table is actually based on the gold medal priority, in such tables how to achieve the order by Excel? 1, the medal list ranking It's actually very simple, we can understand that each of the medals are not the same index,

Visually grasp the overall distribution of data through gradient colors Displays a two-color gradient or a three-color gradient in a range of cells, shading the color to represent the values in the cell, and the gradient color intelligently changes

Hard to design a personal resume form, but someone else is a mess, is it annoying? If it is a private file is OK, as long as set a password on it, but this is to be someone else to fill in the data or to give you reference, often because of other

Usually in the operation of Excel 2007 we may not always encounter the Print button. Or some people don't pay much attention to saving. Print Excel 2007 files at will. Even directly print Excel 2007 files that are generally prohibited from printing.

People often use Word to make forms, process data, and use Word to process forms is also learned, and we share with you a few quick tips for working with word forms. 1, the text cleverly converted into a table Usually when you make a table, you

Special documents, or need to use the format of the manuscript. For example, pretend to have a literary nature, to write a little article, or some style must be the paper to appear more flavor. Before using the manuscript, be prepared, let us use

The Word2007 window has three color schemes for users to choose from, namely blue, Silver ripple and black. Users can set their favorite color scheme according to the actual needs, the steps described below are as follows: Step 1th, open the Word200

Now hackers in order to gain the benefits of all the means, when you open an Office file, you may unknowingly on the recruit, the virus is called macro virus, mainly to the EXE file into office macros can be invoked by the application, and the virus

When we worked hard code words in Word, the result still can not escape the fate of piracy, want to cry without tears you will be angry? Can you keep the words in Word hidden and be seen when you need them? In fact, we have at least 3 strokes to

Word processing is necessary for a computer user. For some purposes, we often need to protect our own documents. The word "protection" here has two layers of meaning. First, to ensure that the information in their own documents is not seen by other

In the Word program window in different locations double-click, you can quickly implement some common functions, we summarized as follows: Double-click the blank area at the bottom of the title bar or vertical scroll bar to toggle the window

For users who often sit in front of the computer to organize documents, one of the most common operations may be to document the text paragraph formatting, such as the first line of indentation, paragraph front, paragraph distance, line spacing and