Skip navigation

# Laying out your PivotTable

Join for an in-depth discussion in this video Laying out your PivotTable, part of Excel 2007 Essential Training.

Resume Transcript Auto-Scroll
##### Author
5h 13m
2,999,381
###### Views
Show More Show Less

#### Q: When trying to apply the techniques from the “Relative and absolute referencing” video to a worksheet other than the exercise file included with the title, the formulas did not work for the entire worksheet. The formulas would only work when going through the worksheet row by row. What could be causing this to happen?

A: When trying to apply formulas to a whole workshee, here is a tip to try:

If you want to always refer to the same cell then use an absolute reference. For example, always pulling the value from cell A3 would be referenced as \$A\$3. This will never change no matter where you copy it to in the spreadsheet.

If you want to reuse the same formula, but with values in different cells,  use the relative reference, A3. This way formula =A3*B3 will become =A4*B4 as you copy it down a column.

#### Q: In the chapter 7 video "Sorting and Grouping" at approximately 4:05, the author says to go to cell 5 on the worksheet and click on Subtotal to subtotal the grouping. My screen will not allow me to click on the Subtotal option at the top of the page. Is this an issue with my version of Excel?

A: It seems that there is an error in the instructions in this video. The video should have instructed users to do the subtotaling first, then create the table.

#### Q: Where can I learn more about Excel formulas?

A: Discover more on this topic by visiting Excel formulas on lynda.com.

##### Skills covered in this course
Business Spreadsheets

#### Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

#### Start My Free Month

Start your free month on LinkedIn Learning, which now features 100% of Lynda.com courses. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.