Display section of worksheet

  • Thread starter Thread starter Grammie
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically add a column to summary sheet if another worksheet i 2
using worksheet name in a formula but not current worksheet 3
linking worksheets 9
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formula to auto calculate based on other variables 8
Match worksheet Function displays wrong data on calculation 1
add data in column related to cell in another column - see full de 1
Calculate total metric based on sum of metric over specific time f 1

Back
Top