Cells in Excel

After having gone through the User Interface, the ribbons and having build a nice expense sheet from scratch, let's go through the basics.

The Cells are each of the squares or rectangles on the spreadsheet where you can enter a value, text a formula.

IMPORTANT: a cell is given a coordinate, which is the (column, row) number. In the exemple here under, the active cell (the green rectangle where you clicked last), has the name F3.

Sometimes you will see name like $F3 or $F$3. When you will drag a cell with a formula or copy paste a cell which has a formula, if there is no $ sign then the coordinate will change with the dragging. With the $ sign, the dragged formula will change only where there is no $ sign.  See copy paste section.



By RIGHT Clicking (right-click) on the cells you get usually two (2) menus opening. One is the quick menu and the lower one the contextual menu.

They both allow you to modify all the properties of the cell very quickly.

contextual menu

You can select multiple cells too and with a right click you get the same menus. In this exemple, we change the colour of the background of the cells.


Or you can Insert a cell.  But becareful when you do this and not mess up your table alignements.

insert cell   


          insert cell

TIP:Typing and entering Data

If you know what you want to enter then do the following.

Select the area you want to type in and start typing.


Every time you press ENTER, Excel will go to the next cell like this


And it will go back to the beginning



These were some basics. Now you will learn by doing.

Please Tweet, Like or Share us if you enjoyed.