Using Mac Air. El Captitan.. Excel 2011.. for Mac
When I set up a spreadsheet.. and I group rows. ... I have a set of hyperlinks above a series of grouped rows Ex. one for 2016, 2015, 2014. And the rows for each year are grouped together. Above the groups of rows, I placed a list of the years and set up a hyperlink to jump to each set of grouped lines that represent sets of rows for each particular year.
My problem is when I add rows above my hyperlinks the hyperlinks no longer go to the same set of data but the same cell. The data is all lowered by the number of rows I added. I need to make it so the hyperlink always goes to the same set of grouped rows for a particular year.
Appreciate your assistance.
Bookmarks