How to select a row in Excel 2007?

There are little more than a million rows in Excel 2007. In a new workbook, all the rows look alike. For identification, you have the Row Header at the left most part of the worksheet area with numbers 1, 2, 3, and so on till 1,048,576.
To select a row, for example, say row number 2, move the mouse or the pointing device over the row number 2 in the Row Header. The cursor changes from plus sign to right arrow. Now, left-click the mouse or the pointing device to select the row.

Alternately, click on any cell in row 2 and press SHIFT + SPACEBAR to select the row using keyboard.

How to resize multiple columns in Excel 2007?

In a new workbook, all columns are of the same size but you can resize the columns to suite your needs. If your worksheet has a larger number of columns that needs to be resized to the same width then you can resize all the columns at the same time. To resize multiple columns, you have to select the columns first.
The selection of multiple columns can be:

Adjacent columns

Columns that are besides each other are called adjacent columns. Consider resizing columns B, C, D, E, and F. Click column B in the column header area. Press the SHIFT key and click the column F in the column header area.

Non-adjacent columns

Columns that are not besides each other are called non-adjacent columns. Consider resizing columns B, H, J, N, and P. Click column B in the column header area. Press the CTRL key and click the columns H, J, N, and P in the column header area.

Once the selection of the columns is over, drag the border of one of the selected column to the right to enlarge the size of all the selected columns. Dragging towards left will minimize the size of all the selected columns.
You can also resize the column width by right-clicking on any selected column and clicking Column Width... and entering a number and clicking OK. (or) On the Home tab, in the Cells group, click Format, and click Column Width... and enter a number and click OK.

How to make all rows the same height in Excel 2007?

To make all the rows the same height, select the rows first (you may select adjacent or non-adjacent rows or a combination of both).
Once the selection of rows is over, drag the border of one of the selected rows (or) right click on any selected row and click Row Height... and enter a value and click OK.

How to select a column in Excel 2007?

Choose the column you need to select. For example, to select column B, move the mouse or the pointing device over the column header B. The cursor changes from plus sign to down arrow and the color of column B header changes to a darker color.

Left-click the mouse or the pointing device to select the column.

Alternately, click on any cell in column B and press CTRL + SPACEBAR to select the column using keyboard.

How to insert a blank column using keyboard shortcuts in Excel 2007?

To insert a blank column, for example between B and C using keyboard shortcuts, move to any cell in column C and press ALT + I + C.

Alternately, move to any cell in column C and press CTRL + SPACEBAR. This will select the entire column. Press CTRL + SHIFT + PLUS SIGN. (Not the plus sign in the Numeric keypad but the key that has the + and = sign.

How to insert a blank row using keyboard shortcuts in Excel 2007?

To insert a blank row, for example between row number 2 and 3 using keyboard shortcuts, move to any cell in row number 3 and press ALT + I + R.

Alternately, move to any cell in row number 3 and press SHIFT + SPACEBAR. This will select the entire row. Press CTRL + SHIFT + PLUS SIGN. (Not the plus sign in the Numeric keypad but the key that has the + and = sign.

How to unhide a single row in Excel 2007?

To unhide a row, for example row number 3, perform the following:

1. On the row header, click 2 and drag the mouse to highlight row number 4.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Rows.

How to unhide multiple rows in Excel 2007?

To unhide multiple rows, for example row number 2, 3, 6, 10, and 12 perform the following:

1. On the row header, click 1 and drag the mouse to highlight till row number 13.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Rows.

How to unhide multiple columns in Excel 2007?

To unhide multiple columns, for example column C, D, F, and K perform the following:

1. On the column header, click B and drag the mouse to highlight till column L.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Columns.

How to unhide a single column in Excel 2007?

To unhide a column, for example column C, perform the following:

1. On the column header, click B and drag the mouse to highlight column D.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Columns.

How to unhide row number 1 in Excel 2007?

To unhide row number 1, perform the following:

1. In the Name Box, type A1 and press ENTER key.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Rows.

How to unhide column A in Excel 2007?

To unhide column A, perform the following:

1. In the Name Box, type A1 and press ENTER key.

2. On the Home tab, in the Cells group, click the DOWN arrow in Format. Point to Hide & Unhide and click Unhide Columns.

How to delete multiple columns in Excel 2007?

To delete multiple columns, you have to select the columns that you need to delete first. The selection of columns can be adjacent or non-adjacent.

To select adjacent columns (for example, columns B, C, D, E, and F), click the column B in the column header area. Press the SHIFT key and click the column F in the column header area.

To select non-adjacent columns (for example, columns B, H, J, N, and P), click the column B in the column header area. Press the CTRL key and click the columns H, J, N, and P in the column header area.

Once the columns selection is over, on the Home tab, in the Cells group, click the down arrow in Delete and click Delete Sheet Columns.

Alternately, you can right-click on any selected column in the column header and click Delete.

How to delete multiple rows in Excel 2007?

To delete multiple rows, you have to select the rows that you need to delete first. The selection of rows can be adjacent or non-adjacent.

To select adjacent rows (for example, row number 3, 4, and 5), click the row number 3 in the row header area. Press the SHIFT key and click the row number 5 in the row header area.

To select non-adjacent rows (for example, row numbers 4, 7, 11, and 15), click the row number 4 in the row header area. Press the CTRL key and click the click the row numbers 7, 11, and 15 in the row header area.

Once the rows selection is over, on the Home tab, in the Cells group, click the down arrow in Delete and click Delete Sheet Rows.

Alternately, you can right-click on any selected row number in the row header and click Delete.

How to delete a column in Excel 2007?

To delete a column (for example column number C), click column C in the column header and then on the Home tab, in the Cells group, click the down arrow in Delete and click Delete Sheet Columns.
Alternately, you can right-click the row number in the column header and click Delete.

How to delete a row in Excel 2007?

To delete a row (for example row number 4), click row number 4 in the row header and then on the Home tab, in the Cells group, click the down arrow in Delete and click Delete Sheet Rows.

Alternately, you can right-click the row number in the row header and click Delete.

How to insert a column with or without formatting details in Excel 2007?

When you insert a column in Excel 2007, by default the inserted column has the formatting details as that of the previous column. You can change this behavior and have other formatting options too. Input the following information to demonstrate this:

1. Click cell A1 and press the SHIFT key and click cell A5. Five cells are now selected.
2. Change the color of the cells to yellow and the color of the text to red.
3. Click cell B1 and press the SHIFT key and click cell B5. Five cells are now selected.
4. Change the color of the cells to blue and the color of the text to white.
5. Enter the information in cells A1 to A5, B1 to B5 as shown in the figure below.
6. Click cell B1. On the Home tab, in the Cells group, click the down arrow in Insert and click Insert Sheet Columns.

The Insert Options button appears. Clicking the Insert Options button pops up three values:

A. Format Same As Left

B. Format Same As Right

C. Clear Formatting

A. Format Same As Left

When you click this option, the newly inserted column has the formatting details exactly as that of the column that is to the left of it. This means, the inserted column has the yellow color background and red color font applied to the cells.

B. Format Same As Right

When you click this option, the newly inserted column has the formatting details exactly as that of the column that is to the right of it. This means, the inserted column has the blue color background and white color font applied to the cells.

C. Clear Formatting

No formatting is applied when you choose this option.

How to insert a row with or without formatting details in Excel 2007?

When you insert a row in Excel 2007, by default the inserted row has the formatting details as that of the previous row. Input the following information to demonstrate this:

1. Click cell A1 and press the SHIFT key and click cell E1. Five cells are now selected.
2. Change the color of the cells to yellow and the color of the text to red.
3. Click cell A2 and press the SHIFT key and click cell E2. Five cells are now selected.
4. Change the color of the cells to blue and the color of the text to white.
5. Enter the information in cells A1 to E2 as shown in the figure below.
6. Click cell A2. On the Home tab, in the Cells group, click the down arrow in Insert and click Insert Sheet Rows.

The Insert Options button appears. Clicking the Insert Options button pops up three values:

A. Format Same As Above

B. Format Same As Below

C. Clear Formatting

A. Format Same As Above

When you click this option, the newly inserted row has the formatting details exactly as that of the row that is above it. This means, the inserted row has the yellow color background and red color font applied to the cells.

B. Format Same As Below

When you click this option, the newly inserted row has the formatting details exactly as that of the row that is below it. This means, the inserted row has the blue color background and white color font applied to the cells.

C. Clear Formatting

No formatting is applied when you choose this option.

What is a column in Excel 2007?

A column is a group of cells that run from the top to the bottom part of the worksheet area or in the vertical direction.
A single column contains 1,048,576 cells.
All columns look alike. For identification purpose, column header is present. Column header is located at the top and is labeled A, B, C, and so on.
To move to the last cell in a column, press CRTL + DOWN arrow. (If data is present then keep pressing CTRL + DOWN arrow keys).

What is a row in Excel 2007?

A row is a group of cells that run from the left to the right part of the screen or in the horizontal direction.
A single row contains 16,384 cells.
All rows look alike. For identification purpose, row header is present. Row header is located at the left and is labeled 1, 2, 3, and so on.
To move to the last cell in a row, press CRTL + END. (If data is present then keep pressing CTRL + END keys).