Excel online training course

excel lesson 6, Columns and Rows

Selecting of...

Alot of beginners in using Excel make the same mistake to think that when they selected all visible cells from a column or a row, they selected the entire colomn or row.
This is not the case.
To select the entire column or row we need to select the column- and row headers.
To do this we click on A, B, C, etc for the columns.
And 1, 2, 3, etc for the rows.

Hold down the "Ctrl" key to select multiple columns and rows.
Hold down the "Shift" key if the columns or rows are adjacent to each other.

You can also select all columns and rows in your worksheet by clicking on the intersection of the columns and rows.
But be carefull when doing this, because if you are entering a formula at that time and you click on this your computer can crash because it needs to process so many commands.
But it can be usefull if you want to edit all your cells at one with for example bold letters or another fontsize.

Changing column width and row height

We can change the column width to show the information better.
To do this we move our mousecursor between the two colomns, over the line, untill this changes into a cross.
Now click and drag the column width to the size you want it to be.
The same can be done for the row height, we move the mousecursor between two rows, and then click and drag the cross to the preferred height.

Autofitting column width and row height

We can automaticly adjust the column width and row height to the broadest and highest information from our columns and rows.
To do this we doubleclick the cross we get to see when we move our cursor over the line between two columns and rows.

Hiding and Unhiding columns and rows

We can hide columns or rows which has sensitive information and dont need to be seen or printed by everyone.
Hiding these columns or rows will only hide them and will still execute the formulas correctly.
To hide a column or row, we select it, right click and select "Hide" in the menu.
To unhide it, we select both rows or columns where our hidden column or row is in between.
And click the right mousebutton and choose to "Unhide".

Inserting and removing columns and rows

Two rules need to be remembered when inserting rows and columns.

1. The number you select when inserting a row, is the number you will insert.
2. New columns are inserted left of the selected column and rows are inserted above the selected row.

Quick note: when you are inserting columns or rows make sure that doesnt create any problems with your formulas.
Normally the formulas will automaticly adjust, but its best to check it anyway just to be sure.
A example:
You made the formula " =SUM(A1:E1) ", you will insert a column in between C and D, then the formula will automaticly adjust itself to " =SUM(A1:F1) ".

To add columns we do the following:
Lets say we like to insert two columns between column C and D.
Then we select column D and E, click the right mousebutton on the selected columns and choose "Insert".

The result :

If you want to add only one column then you only select one column, if you want to add ten columns, then you select ten.

The same rules apply for inserting rows.
Rows will be added above the selected rows.

And to remove columns and rows we do the same again, we select the columns or rows.
Right click on the selected and choose for "Delete" in the dropdown menu.