Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
How does one freeze two rows I.E. a1 and a23?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
You do not.
Freeze Panes works only once per window. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost wrote: How does one freeze two rows I.E. a1 and a23? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
Thank you for that answer.
So is there a way to hide information until it is scrolled up to the reading area? Example I have a worksheet that has 12 weeks on it each week has 16 rows. while viewing one week can the other 11 weeks be hidden? "Gord Dibben" wrote: You do not. Freeze Panes works only once per window. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost wrote: How does one freeze two rows I.E. a1 and a23? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
Maybe you could
Select the range data|filter|autofilter and then use the dropdown arrows to show/hide what you want. Old_skills_lost wrote: Thank you for that answer. So is there a way to hide information until it is scrolled up to the reading area? Example I have a worksheet that has 12 weeks on it each week has 16 rows. while viewing one week can the other 11 weeks be hidden? "Gord Dibben" wrote: You do not. Freeze Panes works only once per window. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost wrote: How does one freeze two rows I.E. a1 and a23? -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
ps. Debra Dalgleish has lots of info about autofiltering:
http://contextures.com/xlautofilter01.html Old_skills_lost wrote: Thank you for that answer. So is there a way to hide information until it is scrolled up to the reading area? Example I have a worksheet that has 12 weeks on it each week has 16 rows. while viewing one week can the other 11 weeks be hidden? "Gord Dibben" wrote: You do not. Freeze Panes works only once per window. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost wrote: How does one freeze two rows I.E. a1 and a23? -- Dave Peterson |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing
Not too easily but here are a couple of ways to do it.
Resize rows and columns so's only one week shows on the screen Create a named range for each week............week1, week2, week3 etc. Select the name from the Namebox to jump to that range. OR you can create 12 Custom Views for each week with other rows and columns hidden. Then drag the Custom Views button to your toolbar and click on it to choose your view.......week1, week2, week3 etc. Don't forget to add a name for the full view first. Gord On Tue, 15 Jan 2008 15:54:00 -0800, Old_skills_lost wrote: Thank you for that answer. So is there a way to hide information until it is scrolled up to the reading area? Example I have a worksheet that has 12 weeks on it each week has 16 rows. while viewing one week can the other 11 weeks be hidden? "Gord Dibben" wrote: You do not. Freeze Panes works only once per window. Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost wrote: How does one freeze two rows I.E. a1 and a23? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezing cells | Excel Worksheet Functions | |||
freezing a row | Setting up and Configuration of Excel | |||
Freezing panes | Excel Discussion (Misc queries) | |||
Freezing Autofilters | Excel Worksheet Functions | |||
Freezing panes | Excel Discussion (Misc queries) |