Archive

Archive for October, 2005

“Freezing” Rows and Columns in Excel

October 21st, 2005 Mannie No comments

When you are editing a large spreadsheet, you may want to lock the row or column headings into place so that they don’t scroll when you scroll the other cells in the worksheet. Excel calls this freezing panes. You can freeze any number of rows at the top of the screen or any number of columns on the left side of the screen, or both.

To keep row and/or column headings visible as you scroll:

  1. To freeze one or more rows, select the row below the row you want to freeze.
  2. To freeze one or more columns, select the column to the right of the column you want to freeze.

    To freeze both rows and columns, click the cell below and to the right of the cells you want to freeze.

  3. Select Window | Freeze Panes.

To remove “Freeze Panes” so that the worksheet scrolls normally:

  1. Select Window | Unfreeze Panes.

When panes are frozen, you typically move in the bottom or lower right pane. However, you can click into any frozen pane and scroll around it.

Categories: MS Excel Tags:

Excel Quiz Question

October 21st, 2005 Mannie No comments
Categories: MS Excel Tags:

Create a Photo Album Presentation in PowerPoint

October 19th, 2005 Mannie No comments

Black Out or White Out the Screen during a PowerPoint Presentation

October 19th, 2005 Mannie No comments
Categories: MS PowerPoint Tags:

Create a PowerPoint Presentation with the AutoContent Wizard

October 19th, 2005 Mannie No comments
Categories: MS PowerPoint Tags:

Compacting and Repairing a Database

October 19th, 2005 Mannie No comments
Categories: MS Access Tags: ,

Four Important Tips for Designing Databases in Access

October 18th, 2005 Mannie No comments
Categories: MS Access Tags: ,

“Splitting” a Database

October 18th, 2005 Mannie No comments
Categories: MS Access Tags: ,

Editing Images with Photoshop from within Dreamweaver

October 16th, 2005 Mannie No comments

Splitting Text into Different Columns

October 15th, 2005 Mannie No comments
Categories: MS Excel Tags: