ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Picture problem (https://www.excelbanter.com/excel-discussion-misc-queries/263630-picture-problem.html)

dwake

Picture problem
 
I want to have a picutre stay in the frame even while scrolling through the
worksheet. Is this possible?

Tom Hutchins

Picture problem
 
The easiest way is to freeze panes below the picture. Position the picture in
the upper left part of the screen (either by placing the picture there or
scrolling). Then select a cell below and to the right of the picture. In
XL2003 select Window Freeze Panes. In XL2007 select the View ribbon
Window section Freeze Panes.

Hope this helps,

Hutch

"dwake" wrote:

I want to have a picutre stay in the frame even while scrolling through the
worksheet. Is this possible?



All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com