Inserting cells

Sooner or later you will need to insert additional cells between those that already contain data. Of course you can move contents of those cells to make a place for the new data, but there is another, faster method which I will show you in the following example.


Example 1:

To insert the cells inside a worksheet, first select a place where you want to put them, then right-click the selection and choose Insert.


When you choose this option, a window with radio buttons will appear. You have four options to choose from. Excel, by default sets the option, which it considers the most likely in this case. In our example the default option - Shift cells right is the option we want.


After the cells are shifted to the right, new blank cells appear inside the table.


Example 2:

In the second example, we will insert new cells under the days of the week. Select cells from C3 to E3. Right-click them and then select Insert. This time, Excel also guessed correctly. We want the cells to be shifted down.

Newly inserted cells will inherit cell formatting from the cells that are located above or from those to the left, depending on where you will insert the new ones. 

Download attachment

Kurs Excel dla początkujących.