Is there a way to select multiple worksheets within a workbook and appl
a freeze pane or split to the same line in all?

(I'm using Excel 2002

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Yes,

Yes,

Select the first sheet you wish to format, then hold the CONTROL key down
while you click the tab of each additional sheet you wish to freeze panes
on. When all sheets are selected, go to Window|Freeze Panes to freeeze all
of the panes... and then right click on any selected sheet and choose
UNGROUP. It is very important to ungroup or any additional changes will be
sent to every selected sheet.

HTH,

ryanb.


"bbparker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Is there a way to select multiple worksheets within a workbook and apply
> a freeze pane or split to the same line in all?
>
> (I'm using Excel 2002)
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

Grouping sheets did not work for me (in Excel 2000) not sure but it
may have been implied in the question. So if it is really needed, it
would require a macro, or to have them already that way to
begin with using templates for new workbooks (book.xlt) and for
new worksheets (sheet.xlt).
http://www.mvps.org/dmcritchie/excel/template.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ryanb." <rblazeiN0!!!@SPAMidimn.com> wrote in message news:(E-Mail Removed)...
> Yes,
>
> Yes,
>
> Select the first sheet you wish to format, then hold the CONTROL key down
> while you click the tab of each additional sheet you wish to freeze panes
> on. When all sheets are selected, go to Window|Freeze Panes to freeeze all
> of the panes... and then right click on any selected sheet and choose
> UNGROUP. It is very important to ungroup or any additional changes will be
> sent to every selected sheet.
>
> HTH,
>
> ryanb.
>
>
> "bbparker" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >
> > Is there a way to select multiple worksheets within a workbook and apply
> > a freeze pane or split to the same line in all?
> >
> > (I'm using Excel 2002)