Excel 2011 for Mac/ Pivot table / tabular layout how to "fill down?"
14,216
In Excel 2010 for Windows (and later) the Pivot Table Design ribbon contains a drop-down called "Report Layout". Selecting "Tabular Layout" and "Repeat all item labels" will show a tabular layout with no blank cells.
Unfortunately, this setting is not available in Excel 2011 for Mac. You may need to copy the pivot table and use formulas to fill in the blanks.
Related videos on Youtube
17 : 39
Thành thạo Pivot table excel trong 17 phút
03 : 24
Excel 2011 for Mac Pivot Tables Step 1
04 : 49
Excel for Mac 2011: Creating a Pivot Table
08 : 02
PivotTables - Set Default Layouts & Formatting And SAVE TIME!
02 : 27
Tách riêng cột trong Pivot Table với kiểu Tabular Layout
07 : 53
EXCEL PRO TIP: Outline & Tabular PivotTable Layouts
Author by
Maggie
Atlanta reporter learning, gulp, computer-assisted reporting. One day I'll know enough to answer questions, not just ask them. I appreciate your help and understanding!
Updated on September 18, 2022Comments
-
Maggie almost 2 years
I've got a great pivot table in tabular layout, but how do I "fill down" values in column A?
A10 should also read "Alpaha Police"
A15:A18 should also read "Atkinson Co Sheriff"