Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane
i want to zoom in on a range or number of ranges without altering the zoom on
the upper freeze pain! is this possible? zoom obviously changes the view for the whole page? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane
There's a tool called CAMERA that you can use to take a snapshot of a range
and paste an image of the range at another location in the worksheet. You can then size the snapshot to a size larger that the zoom ratio of the worksheet. Click VIEW, TOOLBARS, CUSTOMIZE. In the CUSTOMIZE dialog box, click the COMMANDS tab. In the CATEGORIES column click TOOLS and in the commands column scroll down until you locate the CAMERA tool, its icon is a camera so it's not hard to find. Drag the icon to the toolbar of your choice. To use the camera select the range you want to take a picture of and click the camera icon. Move the mouse pointer (now a crosshair pointer) to the location where you want to place the picture and click and drag as if you're drawing a text box or rectangle. Use the sizing handles to resize the image to the desired size. The values in the image are not editable, but they do update as data changes at the source range. Hope this helps. -- Kevin Backmann "Atishoo" wrote: i want to zoom in on a range or number of ranges without altering the zoom on the upper freeze pain! is this possible? zoom obviously changes the view for the whole page? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane
Thanks its a great tool I have had a play with it and am having fun!!
Unfortunately I need the range to be editable! damn! I will use the camera tool elsewhere in my project though! I suspect what im trying to achive may not be possible due to coloumns being the same for both upper and lower panes "Kevin B" wrote: There's a tool called CAMERA that you can use to take a snapshot of a range and paste an image of the range at another location in the worksheet. You can then size the snapshot to a size larger that the zoom ratio of the worksheet. Click VIEW, TOOLBARS, CUSTOMIZE. In the CUSTOMIZE dialog box, click the COMMANDS tab. In the CATEGORIES column click TOOLS and in the commands column scroll down until you locate the CAMERA tool, its icon is a camera so it's not hard to find. Drag the icon to the toolbar of your choice. To use the camera select the range you want to take a picture of and click the camera icon. Move the mouse pointer (now a crosshair pointer) to the location where you want to place the picture and click and drag as if you're drawing a text box or rectangle. Use the sizing handles to resize the image to the desired size. The values in the image are not editable, but they do update as data changes at the source range. Hope this helps. -- Kevin Backmann "Atishoo" wrote: i want to zoom in on a range or number of ranges without altering the zoom on the upper freeze pain! is this possible? zoom obviously changes the view for the whole page? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze pane
Atishoo
A kludgy workaround could be............... WindowNew Window. WindowArrangeHorizontal. Size the upper window so's you have just the freezepanes rows visible. Lower window sized below. Select the lower window and Zoom on that window only. Gord Dibben MS Excel MVP On Fri, 11 Jul 2008 02:22:01 -0700, Atishoo wrote: Thanks its a great tool I have had a play with it and am having fun!! Unfortunately I need the range to be editable! damn! I will use the camera tool elsewhere in my project though! I suspect what im trying to achive may not be possible due to coloumns being the same for both upper and lower panes "Kevin B" wrote: There's a tool called CAMERA that you can use to take a snapshot of a range and paste an image of the range at another location in the worksheet. You can then size the snapshot to a size larger that the zoom ratio of the worksheet. Click VIEW, TOOLBARS, CUSTOMIZE. In the CUSTOMIZE dialog box, click the COMMANDS tab. In the CATEGORIES column click TOOLS and in the commands column scroll down until you locate the CAMERA tool, its icon is a camera so it's not hard to find. Drag the icon to the toolbar of your choice. To use the camera select the range you want to take a picture of and click the camera icon. Move the mouse pointer (now a crosshair pointer) to the location where you want to place the picture and click and drag as if you're drawing a text box or rectangle. Use the sizing handles to resize the image to the desired size. The values in the image are not editable, but they do update as data changes at the source range. Hope this helps. -- Kevin Backmann "Atishoo" wrote: i want to zoom in on a range or number of ranges without altering the zoom on the upper freeze pain! is this possible? zoom obviously changes the view for the whole page? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
freeze pane for more than one row anyone??? | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions | |||
Freeze pane | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions |