R ragup New Member Mar 25, 2013 #1 In excel 2013 templates from Microsoft, there is a template for Monthly Mean Planner. It has four tabs for four worksheets. These also show as tabs on the top which can be clicked to access the respective sheet. Can you please let me know how to do it?? Robert
In excel 2013 templates from Microsoft, there is a template for Monthly Mean Planner. It has four tabs for four worksheets. These also show as tabs on the top which can be clicked to access the respective sheet. Can you please let me know how to do it?? Robert
K keymaster New Member Mar 26, 2013 #2 @Robert... interesting find. This is done with drawing shapes & hyperlinks. First you create semi rounded rectangles with inside shadow. Then place them above table and color & shadow as needed in each tab. Then apply hyperlinks to each of them using Insert > Hyperlink feature. For more on hyperlinks see this: http://chandoo.org/wp/2011/03/31/excel-hyperlinks/
@Robert... interesting find. This is done with drawing shapes & hyperlinks. First you create semi rounded rectangles with inside shadow. Then place them above table and color & shadow as needed in each tab. Then apply hyperlinks to each of them using Insert > Hyperlink feature. For more on hyperlinks see this: http://chandoo.org/wp/2011/03/31/excel-hyperlinks/
