Selecting Columns and Rows…

Many new Excel users make the mistake of thinking that they have selected. the entire column or row when all visible cells in a column or row are selected.

This is not the case.

For an entire column or row to be selected, we need to select the column header or select all.

To do this we click on A, B or C …. for the columns.

And 1, 2 or 3, …… for the rows.

Hold the “Ctrl” button to select multiple columns and / or rows.

Hold the “Shift” button pressed 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 between the columns and rows.
Please note that if you do this on a column for which you entered a formula,then your computer may crash through the mass execution of operations.
But it may be useful to you only when you want to edit the cells simultaneously with simple operations like bold, the font size, etc. …

Changing “Column width” and “Row height”

We can adjust the column width to display the data correctly.

For this we move our mouse pointer between two columns on the line until it changes into a cross.
Now click and drag the “Column width” to the desired width.

Similarly for the height, we bring the mouse pointer between the two rows, and click and drag the cross to the desired height.

“Auto Fit” of “Column width” and “Row height”

We can make the “Column width” and “Row height” adjust automatically to the most widest and most biggest data in our column or row .

To do this we double click on the cross that we see when we move mouse pointer over the line between two columns or two rows.

“Hide” and display rows and columns

We can hide rows or columns containing sensitive data and therefore it need not be seen or printed by everyone.

To hide these columns or rows is to make it invisible but, it will still have the “Formula” intact.

To hide a column or row, we right click and select “Hide” from the menu.

To unhide their display, we select the two rows or columns where our hidden row or column and right click between them and choose “Show”.

“Insert” and “Delete” columns and rows

Two rules you should remember when inserting rows and columns

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

Be careful when you insert rows or columns that you do not create problems with your formulas.

Normally the formulas adjust automatically, but to be sure, you can still check.

An example:

You have the formula = SUM (A1: D1)

you add a column in between B and C

it will automatically adjust the formula to = SUM (A1: E1)

To add columns we do the following:

Suppose we want to add two columns between columns B and C.
Then we select column C and D, right-click on the selected columns and select insert.

Result:

If you wish to add columns, you click on a column and right click and select insert columns. If you wish to insert ten columns, then select ten.

The same goes for the insertion of rows

Rows are added above the selected rows.

To “Delete” rows or columns we do the same again, selecting the columns or rows.
Right-click the column or row and choose “Delete” from the menu.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats