Microsoft Word 2003 or 2007 Table Columns

Did you know...

If you have a column in a table that goes off the edge of the page, there is a simple way to get it back on the page?

See how the column disappears off the right side of the page?

Here is what you do...

1. Put the cursor right above the column you need to get back onto the page until you get a little black down arrow.

2. Now, put the cursor between the last two columns until you get the little resizing arrow. It is a double line with an arrow pointing left and an arrow pointing right. DOUBLE CLICK.

The last column now fits on the page.

Give it a try.

Doesn't work for you?

Email me at grandberry@gmail.com

We help you like your computer.

Comments welcome.

Excel 2003 and 2007 -- Edit formulas

Did you know...

You can edit formulas in 2 different places?

Anything you enter into a cell will show up not only in the cell, but also in the formula bar. Here is a picture of a formula entered into a cell and showing in both the cell and the formula bar. The result is in the cell the formula is in the formula bar.

If you look at the formula bar (next to the fx) you will see the actual formula. If you look in the cell you see the results.

Now, if you double click in the cell you will get a blinking cursor and be able to edit your formula right in the cell. It will look like this:

If you double click in the formula bar (next to the x √ fx) you will get a blinking cursor there and you will be able to edit in that box as well.

Give it a try.

Doesn't work for you? Email me at grandberry@gmail.com

We help you like your computer.
Comments welcome.

Excel 2007 -- Freeze Pane

Did you know...

That you can make the top line on your Excel Spreadsheet visible all of the time no matter how far down the sheet you have to go.

You can do this in other versions of Excel, but as we all move from Excel 2003 to 2007, it can be confusing trying to find the command.

In Excel 2007 the "Ribbon" at the top changes based on what you are doing. Excel has no way of knowing when you want to freeze panes, so you have to go to the correct Ribbon to find it.

You will find it on the View Riboon. Here is what you do...

• Place your cursor on the row below the row you want to show up all the time
  AND
• if you have a column on the left you need visible all the time, place the cursor in the column just to the right of the one you want always visible. Like this:

• Click on the View Ribbon


• Click on Freeze Pane


• Select the option you want, I have selected the top options

In this illustration the first row and the first column will be visible all of the time no matter how far down on the sheet you go. Above you see Rows 1-7 and Columns A-E. If I move to Row 27 you will still be able to see the top row as shown below if the spread sheet grows and I need to add information in all the columns through Z, the first column of names will always be visible:

This feature has no effect on printing, it is strictly a viewing feature to make working in the Excel spreadsheet easier.

To turn off this feature, simply go through the steps listed above and select "unfreeze pane" rather than "freeze pane" (the option changes based on what you have done).

Doesn't work for you?

email me at grandberry@gmail.com

We help you like your computer.
Comments welcome.