Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Relative Cell Positions?
Thanks to help here I was able to do 'Name a Range' to make sure that
hyperlinks to a vertical range of cells in a column was maintained even if I extended that range of cells with new entires (e.g. the range starts at B100:B150 and then I add several rows so it is now B100:B160, the hyperlink still selects the whole range). I had a tab near B100 in A100 though. So if I add 10 rows about B100, even though the hyperlink will now find B110 to B170, A100 has not moved to A110. Adding and pasting in A is not really efficient or intuitive based on what I am doing. So can I say to A100 'always stay to the left of B100'? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
How can I sort a column by the last positions of each cell | Excel Discussion (Misc queries) | |||
Copying charts and their data with relative cell positions | Charts and Charting in Excel | |||
Testing positions in a cell | Excel Discussion (Misc queries) | |||
How do I sum using relative cell positions? | Excel Worksheet Functions |