freeze row AND column simultaneously
Hi,
And if you find this useful, you can add a Freeze Panes toolbar button to
any of your toolbar. Right-click any toolbar and choose Customize. Select
the Commands tab, and then the Windows & Help Category. Scroll down the
Commands list on the right until you find Freeze Panes. Drag it to any one of
your toolbar and drop it. This is a toggle button and very useful.
--
Thanks,
Shane Devenshire
"Chris Cornell" wrote:
How do I freeze a row and a column simultaneously? No matter how far and
away one scrolls, I want the 'client's title' row and date column to be
frozen at the same time. I can only freeze one at a time, because by wanting
to freeze the second I must unfreeze the other.
Here's a visual in case I'm not clear.
Visual...
Static/Frozen Row 1 = Different Client Names
Static/Frozen Column B = Date
_______CLIENT__________________ (Row 1 Hold Static)
(Column l
A l C
Hold l E
Static) D L C
A L E
T S L
E L
l S
l
Thanks
--
Chris Cornell
No... not that one.
|