Excel – Multiple Sheets, Add ‘Em Up on a Summary Sheet

Keeping track of a budget by department or ledger number using Excel? And you want to put each department or ledger category on separate worksheets? Now how do you add up all that information by department on a summary sheet?

Knowing how to rearrange, copy and delete sheets, group them together so that what you do to one sheet you do to all will make finding and tracking those numbers easier.  Then summarize the information on all the sheets by adding a Summary sheet and create linking and 3-D formulas. You can even create hyperlinks to the individual sheets from the summary sheet so you don’t have to scroll across the bottom of the Excel windows to find just the sheet for which you are looking.

Want to know more? Watch a video, attend a workshop or request a consultation.

• Video:
  Mac Excel 2011 Multiple Sheet Overview*
  PC Excel 2010 Multiple Sheet Overview *
  PC Excel 2013 3-D Formula
• ITS Workshop Schedule: Current Class Schedule
• Consulting: Contact the ITS Help Desk (x3333 or helpdesk@etown.edu)

*Atomic Learning Video, login with your college username and password.