For those of you who have made the move over to MS Excel 2007 and have found familiar features or tricks difficult at times to find or execute, this quick tip might be helpful. When I use the group and outline feature, I like to (almost always) set the group brackets to have a top-down […]
Category: Excel
Categories
Same cell, different sheet
Looking to reference a specific cell in all of the worksheets and display the results in separate cells on one summary sheet …? Enter the “sheet name” in a cell & use the fill handle to drag across all sheet names (however they are named – so long as you have the tab names in […]
Categories
Modeling Links
Over time I have collected a solid list of Excel tips and tricks websites. Some are better than others but all are worthy of a perusal to find what they have to offer. Excel Add-InsAnalytics / Excel BlogExcel Modeling HelpExcel ChartsEnroll in daily Excel tipsMore Excel Tips Do you have any more to add?