ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   solution wants (https://www.excelbanter.com/excel-discussion-misc-queries/198877-solution-wants.html)

shoyeb2045

solution wants
 
what is the freeze panes

scott

solution wants
 
It is the ability to freeze the worksheet above the cell that is referenced
when the "freeze panes" option is clicked. It is good for tasks that involve
scrolling through worksheets while needing to reference data at a portion of
the spreadsheet that is at the top.

Go to Window -- Freeze Panes to try it. Just remember that the sheet
will be frozen above the cell that is referenced when the option is clicked.

"shoyeb2045" wrote:

what is the freeze panes


David Biddulph[_2_]

solution wants
 
What did Excel help tell you when you asked it about "freeze panes"? Which
parts of that didn't you understand?
--
David Biddulph

"shoyeb2045" wrote in message
...
what is the freeze panes




JLatham

solution wants
 
It will also freeze columns to the left of the cell selected.

So if you choose A2 and then freeze panes, row 1 will always be visible as
you scroll down the sheet.

If you were to choose B2 and then freeze panes, row 1 and column A would
remain visible as you scroll down/across the worksheet.

"scott" wrote:

It is the ability to freeze the worksheet above the cell that is referenced
when the "freeze panes" option is clicked. It is good for tasks that involve
scrolling through worksheets while needing to reference data at a portion of
the spreadsheet that is at the top.

Go to Window -- Freeze Panes to try it. Just remember that the sheet
will be frozen above the cell that is referenced when the option is clicked.

"shoyeb2045" wrote:

what is the freeze panes


Gord Dibben

solution wants
 
See help on "freeze panes"


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 11:49:01 -0700, shoyeb2045
wrote:

what is the freeze panes




All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com