In Excel, over there are countless ways come quickly and efficiently fill cells through data. Anyone knows the laziness – is the engine the progress. Know about this and also the developers.

You are watching: Fill in the table

To fill in the data you have to spend many of the moment on boring and routine work. For example, filling while sheet or the invoice, etc.

Let`s consider the methods of automatic and semi-automatic pour it until it is full in Excel. And also, what tools have actually spreadsheets to facilitate the user"s work. We will certainly learn just how to use them in practice and find out how efficient they are.

How in Excel to fill cells v the exact same values?

At first, let"s look at at how to instantly fill the cell in Excel. For example, we room filling in the half-empty early stage table.


This is the small nameplate: just for this example and it can be fill in manually. But in practice, periodically you need to fill in 30 thousands lines. To not fill this source table manually, friend should develop a formula to to fill in Excel data by automatically. To carry out this, execute the collection of sequential actions:

Go to any empty cell in the source table.Select the tool: «HOME» – «Find and also select» – «Go To» (or to push the warm keys CTRL + G).
In the home window that appears, click the «Special» button.In the window that appears, select the alternative «Blanks» and click OK. All empty cells space highlighted.Now go into the formula «=A1» and also press CTRL + Enter. This is how the north cells in Excel room filled v the previous value – automatically.
Highlight the columns A:B and copy the contents.Select the tool: «HOME» – «Paste» – «Paste Special» (or press CTRL + ALT + V).In the home window that appears, pick the «Value» option and also click OK. Now the original table is to fill not simply with formulas, however with natural values of the cells.

When filling 30 thousands lines the is impossible not to do mistakes. The above technique not just saves forces and time, but additionally eliminates the incident of errors resulted in by the human being factor.

Attention! In the 5-th paragraph, the table was beautifully filled without errors, since our active cell was at deal with A2, after perfect the 4-th item. Once using this method, be careful and also watch wherein the active cell is after the selection. The is crucial where it will take that values.

Semi-automatic filling of the cell in Excel from the drop-down list

Now in semi-automatic mode you have the right to fill the empty cells. There are only a few values the are repetitive in sequential or in arbitrarily order.

In the brand-new source table, instantly fill in the columns C and also D v the data equivalent to them.


This semiautomatic an approach of data entry enables several time to speed up and also facilitate the procedure of working v tables.

Attention! If the value is composed of several lines, then when you press the ALT + (down arrow) combination, it will certainly not be shown in the drop-down list of values.

To break-up the value right into strings making use of the ALT + Enter crucial combination. Thus, the message is split into rows in ~ the very same cell.

See more: Which Of The Following Does Not Define A &Quot;Healthy Body Weight?&Quot;


Note. Notice how we gotten in the current date in step 4 making use of the hotkeys (CTRL +;). The is really convenient! and also when you push CTRL + change +; we gain the present time.