Display section of worksheet

G

Grammie

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
 
G

Gord Dibben

First have Tools>Options>View "Windows in Taskbar" enabled.

Second Window>New Window.

Window>Arrange>Vertical.

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
 
Top