Display section of worksheet
 

I put together a small worksheet to make calculation for estimates. I
use this several times an hour. I wanted to have it appear something
like the "calculator" that located in "Accessories", where just that
small (45 cells - 3 x 15) section comes up instead of the whole
worksheet.

Can anyone help

Display section of worksheet
 

First have ToolsOptionsView "Windows in Taskbar" enabled.

Second WindowNew Window.

WindowArrangeVertical.

Resize the window with your small portion of cells.

Minimize that window.

Resize the other window to full size........do not maximize it.

To see your small window click on it in the taskbar. It will appear and be
active.

You can change sheets or workbooks in the larger window without losing the small
window.

Or just ignore all the above and use the Windows Calculator.


Gord Dibben MS Excel MVP

On 31 Jan 2007 11:25:47 -0800, "Grammie" wrote:

I put together a small worksheet to make calculation for estimates. I
use this several times an hour. I wanted to have it appear something
like the "calculator" that located in "Accessories", where just that
small (45 cells - 3 x 15) section comes up instead of the whole
worksheet.

Can anyone help