RE: Excel question

Subject: RE: Excel question
From: bryan -dot- westbrook -at- amd -dot- com
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Thu, 22 Mar 2001 14:55:32 -0600

It should be noted that you can't freeze rows in the middle of the table.
What you can freeze is limited to:

*the first row
*a range of rows beginning with the first row
*the first column
*a range of columns beginning with the first column
*an "L" shaped combination of legal rows and columns

To freeze a row, you select the row AFTER the last row you want to freeze.
Therefore, if you wanted to freeze the first row (to have the header on the
screen at all times), you would select row 2 and then select Freeze Panes.
If you select row 1, all you will freeze is the non-existent row 0 (in other
words: no effect at all).

To freeze a column, you select the next column.

To freeze both, you select the next single cell after the intersection of
the two axes. For example to freeze rows 1-9 and columns A-D, you would
select cell E10.

-----Original Message-----
From: Lyn McNairn [mailto:lyn -at- infointeractive -dot- com]
Sent: Thursday, March 22, 2001 2:35 PM
Subject: RE: Excel question

You can freeze certain panes. That way they will stay while you scroll
down, add new rows, etc. I think that is what you want. If so: Select the
rows you want to stay at the top of your viewing screen all the time. Then
select Window/Freeze Panes.


*** Deva(tm) Tools for Dreamweaver and Deva(tm) Search ***
Build Contents, Indexes, and Search for Web Sites and Help Systems
Available 4/30/01 at or info -at- devahelp -dot- com

IPCC 01, the IEEE International Professional Communication Conference,
October 24-27, 2001 at historic La Fonda in Santa Fe, New Mexico, USA.

You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: RE: Greetings, and a question (or two)...
Next by Author: RE: Search inside a PDF?
Previous by Thread: RE: Excel question
Next by Thread: Found the book

What this post helpful? Share it with friends and colleagues:

Sponsored Ads