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.

Microsoft Word 2003 and 2007--White space

Did you know...

Microsoft 2003 and 2007 will allow you to hide the white space at the top and bottom of your document?

Here is a sample of a document in Word with the bottom of one page showing and the top of the second page showing:

When you put your cursor right on the edge of either piece of paper, you get the "hide white space" option. It will look like this:

Once you have the cursor in position so you see the "Hide White Space" option, click one time and the top and margins will be hidden. Like this:











The margins are still there, they are just hidden. This view will help you align text, graphics, tables, etc. by hiding the white space temporarily. To get it back, simply click again in the same place.



Didn't work for you?

Send me an e-mail at grandberry@gmail.com and I will be glad to help you and answer your questions or post a question in the comments here.



We help you like your computer