Prev: no respond/answer from formula entry
Next: Using Mid Function with Pivot Table Calculated Item
From: goadk123 on 21 Mar 2010 19:22
what is the function to set (lock in or freeze) the first column and / or top
row
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
(so you can add more columns..yet keep the main information in the first
column/row)
From: Dennis Tucker on 21 Mar 2010 21:20
Freeze Panes.....

In older versions of Excel, it is under Window.
In 2007 version of Excel, it is under View.

You first select a cell, then activate the command. Excel uses the selected
cell's upper left corner to define the freeze point.

Play with it. You can also Unfreeze panes that were frozen before.

Dennis

"goadk123" <goadk123(a)discussions.microsoft.com> wrote in message
news:4D9C35BE-5C79-4C00-9093-84C1BCE27720(a)microsoft.com...
> what is the function to set (lock in or freeze) the first column and / or
> top
> row
> of a spreadsheet, so the words and numbers remain in the same place as you
> scroll the other columns and rows.
> (so you can add more columns..yet keep the main information in the first
> column/row)

From: Teethless mama on 21 Mar 2010 21:36
Select B2 > Window > Freeze Panes


"goadk123" wrote:

> what is the function to set (lock in or freeze) the first column and / or top
> row
> of a spreadsheet, so the words and numbers remain in the same place as you
> scroll the other columns and rows.
> (so you can add more columns..yet keep the main information in the first
> column/row)
 | 
Pages: 1
Prev: no respond/answer from formula entry
Next: Using Mid Function with Pivot Table Calculated Item