Frames

W

WStoreyII

I have a Ledger with 6 fields
date, method,payee,confirm,status,amount

I have the window frozen so that the header will stay stil

how ever my problem is that to the right of the data i have some totals and other infor in cells

but when i select an auto filter it hides them.

So i was wondering if there was a way to set up a seperate sheet next to it like a fram in html so that i could add the totals there?

WStoreyII
 
K

keepITcool

When rows are filtered.. the unselected rows are and remain invisible.
But when you move your data to a location BELOW or ABOVE the filtered
range.. then here comes a trck to make it visible in the top of your
window...


Right click a toolbar and select customize

TAB : Commands
Category : Tools
Command : CAMERA tool... (almost at the end)
Drag it to a visible toolbar... :)

Close toolbar edit mode.



Move your data somewhere where it will not be filtered
(for demo put m on row 10000. :)

Select your data.. press the camera tool.
Click a cell in row 1... and the picture of the range
is yours..

HTH



--
keepITcool

| www.XLsupport.com | keepITcool chello nl | amsterdam



WStoreyII wrote :
 
Top