Panes for Sheets - possible??

VenturSum

Board Regular
Joined
May 23, 2010
Messages
137
Team,
I'd like to view several sheets at the same time. Is it possible to (via an add-on or maybe in version 2010) to view several sheet in separate 'panes'.

Consider MS Access, how tables can be opened either with tabs across the top or with overlapping panes.

In a model I'm building I'd like to have an [Inputs] sheet appear in a pane, and the [Output] graph appear in another pane, with both panes visible at the same time.

Thoughts???

Thanks,
John,
In Annapolis, MD
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

VenturSum

Board Regular
Joined
May 23, 2010
Messages
137
Akashwani,

That is AWESOME... And just what I was looking for. Excel just became substantially MORE functional. Not just 2, but I've opened up several sheets: the inputs, the calculations, and the outputs. I can see immediately the changes to the output affected by the inputs.

Thanks again,

John,
In Annapolis.
 

energman58

Well-known Member
Joined
Oct 25, 2010
Messages
553
You can also acheive a similar effect by pasting a picture of the cells you want to look at:

Copy the cells

Select where you want them to appear Paste as Picture - Paste As Picture Link

Then as the cells change they will change in the picture "live"

This is good if you want to see what is happening at different places in a single sheet at the same time in one view as you can paste lots of different pictures in a single window (it works with charts too)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,845
Messages
5,638,682
Members
417,042
Latest member
kshipp91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top