Here is a great tip I learned from Excel TV on how to create absolute cell references in Tables in Excel:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
This tip came from an episode of Excel TV with Zack Barresse as a guest. It’s a great series and well worth subscribing to. You can view the Zack Barresse tip on Excel TV by clicking here.