Here are the steps to follow in this lesson:
- Make the right side of your formula – the reference to the “Total” – an Absolute Cell Reference.
- Change =C2/G1 to =C2/$G$1 by using the F4 Shortcut key.
- 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.
Link to this post!