Use absolute cell reference in % of total formula

Here are the steps to follow in this lesson:

  1. Make the right side of your formula – the reference to the “Total” – an Absolute Cell Reference.
  2. Change =C2/G1 to =C2/$G$1 by using the F4 Shortcut key.
  3. To reveal all Formulas in a worksheet, use CTRL + ~ (This is a toggle.)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.