Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display data in different worksheet in excel | Excel Discussion (Misc queries) | |||
How do I display the file name in the worksheet? | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
insert picture in header section of excel worksheet | Excel Discussion (Misc queries) | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) |