Without a rudder as a fill in the blank cells in a document available through the empty string?
Today's challenge, we will try to show graphically and explain how it's done.
The essence of this topic is to reduce your work with the procedure to copy-paste.
1. For the sample we take the next file "reєstr vnutrіshnіh arbitrarily" in our case, we need to fill in the blank cells in columns "Lіsgosp", "Reєstratsіyny number", that in the columns "Danі contract" (crossed dotted bar in subsequent figures will not be displayed).
Figure 1
2. Insert the formula under the first-filled cell.
Figure 2
3. As a result, the lower column is equal to the upper.
Figure 3
4. Now copy the yellow box (Ctrl+C)
Select the range in which there are empty cells, ie cells under the column "The forestry, RR number, №, date of detention, and completion date"
Be careful in this case, under the column "Date of conclusion and completion date" shall have the format "SHORT DATE"
Figure 4
5. So copy the value, select the cells are now looking at the main toolbar, click "Find and select"search for the button of "Find and highlight".
Figure 5
6. Clicked, you have to light newer box find and select "It put a checkmark" Empty "and click" OK ".
Figure 6
7. After you click OK, you will see that the selected region grayish color and gray only empty cells.
Figure 7
And then you can safely insert the copied information, but there is one thing but pasting make only a function of Ctrl V, nor in any way the right mouse button !!!!!!
8. And finally the last stage. Once we had an operation to insert, copy, need to remove all the formulas and leave just numbers.
To do this, we do a simple operation. Select the entire document, copy and via the "Paste Special" is inserted in the same document "Values".
Figure 8
And one more thing .. if in case of failures for the changes in information, it is best to use this option for each column separately .. That is, first, when you have completed the first cell in the columns do formulas for each cell with the established format (text, short date and TP. (to prevent change of date for example from 12/01/2009 to 39825, or contract number 2 on 02/01/1900)
Thank you, all done with your hands and on his experience .. have prompted many employees it will share more here ..)))))
