Excel2007 How to fill in the blanks of the form quickly and uniformly?

In our work or study will inevitably encounter some form problems, for example, some tables will have some empty table parts, and we need to fill these blank parts of the uniform number, your first reaction will do? Still hard to select the cells to fill in one step at a step? In fact, small series can give you recommend a method, Can quickly through the part of the table fill in the unified number, let's take a look at it.

Operation Steps

1. First open a workbook containing a blank form, as shown in the figure below, we want to fill in the blank part of the unified figure;

2, click the Start tab, click the Find option group in the edit area, and then select Go to in the Drop-down menu that pops up.

3, in the pop-up dialog box click the "Positioning criteria" option;

4, in the "Positioning Conditions" dialog box, click on the "null" button, and then click the "OK" tab;

5, back to the table you will find that the blank part of the table has been automatically selected, when we hold down the "ctrl+enter" button, arbitrary selection of a cell, such as B6 cell, and then enter a number inside, small series here into 0;

6, after the input we also hold down the "Ctrl+enter" key, at this time you will find that the blank parts of the table are filled in the unified number, as shown below;

Tip: For users with large table data, the above method is a good way!

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join