Centering on image when link is clicked
 

Hello,
I have a simple workbook that consists of two worksheets, first with
data and second with maps relating to that data. I have links
throughout the first sheet that take the user to the second sheet, my
problem being that these sometimes display with the linked cell near
the bottom of the screen (causing a totally different map to be
displayed in the center). Are there any ways to make the linked data
display centered on the screen?

Centering on image when link is clicked
 

Hi Faerigirl,

You can set your link as a range. This will display the selected range on
the displayable area. Eg if the map covers cells a1 to j10 set your link as
a1:j10. This will 'select' the area between a1:j10 and assuming the map you
want displayed is over that area, it will 'display' the map in the viewable
area.

The reason why sometimes the linked cell appears at the bottom/top of the
page is that excel simply scrolls the worksheet up/down until the cell first
appears in the viewable area and then it stops.

" wrote:

Hello,
I have a simple workbook that consists of two worksheets, first with
data and second with maps relating to that data. I have links
throughout the first sheet that take the user to the second sheet, my
problem being that these sometimes display with the linked cell near
the bottom of the screen (causing a totally different map to be
displayed in the center). Are there any ways to make the linked data
display centered on the screen?