Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hyperlink to an image on a different sheet and display it f | New Users to Excel | |||
Hyperlink to a location on worksheet and display full image. | Excel Discussion (Misc queries) | |||
Hyperlink to an image in other worksheet, displaying entire image. | Excel Worksheet Functions | |||
How to link an Image to a cell value | Excel Worksheet Functions | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) |