Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Creating Sticky PivotTable Formatting.mp4

5.08K subscribers

9.5K views 13 years ago

One of the more frustrating aspects of working with PivotTables is the seeming inability to format a PivotTable so that the formatting remains intact when you refresh the PivotTable. By using utilizing the two simple techniques contained in this tip, you will create PivotTable formats that are "sticky" and remain in place even when you refresh the PivotTable.

...more

...more

Address Maintaining Column Widths and a Pivot Table

Pivot Table Options

Preserving Cell Formats

Creating Sticky PivotTable Formatting.mp4

18Likes

9,525Views

2011Dec 21

One of the more frustrating aspects of working with PivotTables is the seeming inability to format a PivotTable so that the formatting remains intact when you refresh the PivotTable. By using utilizing the two simple techniques contained in this tip, you will create PivotTable formats that are "sticky" and remain in place even when you refresh the PivotTable.

Address Maintaining Column Widths and a Pivot Table

Pivot Table Options

Preserving Cell Formats

Transcript

Follow along using the transcript.

K2 Enterprises

5.08K subscribers

A Better Way To Generate NPV And IRR Calculations In Excel

K2 Enterprises

How Excel Handles Dates

K2 Enterprises

Changing How PivotTables Display Blank Cells

K2 Enterprises

Enabling Iterative Calculations In Excel.mp4

K2 Enterprises

Calculating The Principal And Interest Associated With A Single Loan Payment.mp4

K2 Enterprises

Performing Fuzzy Lookups In Excel.mp4

K2 Enterprises

Recovering Un-Saved Info In Microsoft Office Documents.mp4

K2 Enterprises

The Fastest Way To Create Defined Names In Excel.mp4

K2 Enterprises

Filtering Excel Data To The Top 10 Items.mp4

K2 Enterprises

Creating An Excel Chart With Conditional Formatting.mp4

K2 Enterprises

Using Search Filters In Excel 2010.mp4

K2 Enterprises

Creating New QuickBooks Data Files From Templates.mp4

K2 Enterprises

Marking Up And Adding Comments To PDF Documents.mp4

K2 Enterprises

Entering Data and Formulas Into Multiple Excel Cells Simultaneously.mp4

K2 Enterprises

Speeding Data Entry With Excel's Auto Fill Options.mp4

K2 Enterprises

Working With Column Headers in Excel Tables.mp4

K2 Enterprises

Finding The Information You Really Want Using Google.mp4

K2 Enterprises

Changing The Look Of A Column Chart.mp4

K2 Enterprises

Managing The Auto Complete Option In Outlook 2010.mp4

K2 Enterprises

Handling Rounding Issues In Excel.mp4

K2 Enterprises

Creating Sticky PivotTable Formatting.mp4

K2 Enterprises

Advanced SUMIF and SUMIFS Formulas.mp4

K2 Enterprises

Creating A Chart With Two Vertical Axes.mp4

K2 Enterprises

Using Two Minus Signs In Excel.mp4

K2 Enterprises

Creating A PDF Portfolio.mp4

K2 Enterprises

Using Excel To Identify Entries That Add To A Specific Value.mp4

K2 Enterprises

Emailing A Single Excel Worksheet.mp4

K2 Enterprises

Creating And Using Custom Styles In Excel.mp4

K2 Enterprises

Creating A Period Copy Of A QuickBooks Data File.mp4

K2 Enterprises

Changing How Excel PivotTables Display Subtotals.mp4

K2 Enterprises

Solving Excel Formatting Problems With Accounting Underlines.mp4

K2 Enterprises

Customizing The Appearance Of A Bar Chart.mp4

K2 Enterprises

Ranking Data In Excel Without Sorting.mp4

K2 Enterprises

Restricting Access To An Excel Workbook Using Passwords.mp4

K2 Enterprises

Protecting Specific Cells In An Excel Worksheet.mp4

K2 Enterprises

Preventing Unauthorized Changes To An Excel Workbook.mp4

K2 Enterprises

Tracking QuickBooks Inventory In Multiple Warehouses.mp4

K2 Enterprises

Linking Excel Data Into Word Documents.mp4

K2 Enterprises

Applying Conditional Formatting To PivotTables.mp4

K2 Enterprises

Employing New PivotTable Options In Excel 2010.mp4

K2 Enterprises

Working with Two QuickBooks Files at the Same Time

K2 Enterprises

Libraries - One of the Best New Features in Windows 7.mp4

K2 Enterprises

Predicting The Future With Trendlines In Excel.mp4

K2 Enterprises

Taking Advantage Of The Windows 7 User Experience.mp4

K2 Enterprises

Using Excel's Fill Justify Tool

K2 Enterprises

Getting The Green Light Conditional Format In Excel Worksheets.mp4

K2 Enterprises

Creating Many PivotTables From One.mp4

K2 Enterprises

Pinning a Folder to the Explorer Jump List in Windows 7.mp4

K2 Enterprises

Customizing the Ribbon in Office 2010.mp4

K2 Enterprises

Working With Quick Steps In Outlook 2010.mp4

K2 Enterprises

The Fastest Way To Create Charts In Excel.mp4

K2 Enterprises

Creating User Defined Keyboard Shortcuts In Windows

K2 Enterprises

Getting More Than Just Sums With Excels AutoSum Tool

K2 Enterprises

Using Words Building Blocks And Quick Parts Tools

K2 Enterprises

Adding Date And Time Stamps To Excel Worksheets.mp4

K2 Enterprises

Using Excels SUMPRODUCT Function To Multiply Values And Sum The Results.mp4

K2 Enterprises

Removing Duplicate Records In Excel.mp4

K2 Enterprises

Viewing Underlying Debit And Credit Entries In QuickBooks.mp4

K2 Enterprises

The Fastest Way To Copy Excel Formulas.mp4

K2 Enterprises

Creating Custom Lists In Excel.mp4

K2 Enterprises

Using The Problem Steps Recorder Tool In Windows 7.mp4

K2 Enterprises

Viewing Noncontiguous Days In Your Outlook Calendar.mp4

K2 Enterprises

Using Tables As Dynamically Expanding Ranges.mp4

K2 Enterprises

Selecting Cells In Excel With Special Characteristics.mp4

K2 Enterprises

Sorting Subtotaled Excel Data.mp4

K2 Enterprises

Introducing PowerPoint 2010s Animation Painter.mp4

K2 Enterprises

Sorting Data By Cell Color In Excel.mp4

K2 Enterprises

Creating ODBC Connections With Peachtree And Excel

K2 Enterprises

Consolidating Data With Excel.mp4

K2 Enterprises

Using Cell( ) to Display a Worksheet Name in a Worksheet Cell.mp4

K2 Enterprises

Creating Videos from PowerPoint 2010 Presentations.mp4

K2 Enterprises

Creating Workspaces In Excel.mp4

K2 Enterprises

Using QuickBooks Toggle Feature.mp4

K2 Enterprises

Taking Charge Of Word's Full Screen Reading Layout.mp4

K2 Enterprises

Grouping PivotTable Data By Weeks.mp4

K2 Enterprises

Formatting Month Axis Labels In Excel Charts.mp4

K2 Enterprises

Adding Formulas To Word Documents.mp4

K2 Enterprises

Creating An Email Merge In Outlook.mp4

K2 Enterprises

Creating A Reconciliation Report In QuickBooks.mp4

K2 Enterprises

New PivotTable Options In Excel 2010.mp4

K2 Enterprises

Gaining Better Insight With The QuickBooks Company Snapshot.mp4

K2 Enterprises

A Sneak Preview Of Quick Steps In Outlook 2010.mp4

K2 Enterprises

Working In Excel's Page Layout View.mp4

K2 Enterprises

Enabling Windows 7 GodMode.mp4

K2 Enterprises

Using Checkboxes To Select Items In Windows 7 And Windows Vista.mp4

K2 Enterprises

A Quick Peak At Excel Sparklines.mp4

K2 Enterprises

A Sneak Peek At Excel 2010s Slicer Function.mp4

K2 Enterprises

Charting In Microsoft Office Word.mp4

K2 Enterprises

Using Dates As The Horizontal Axis On PivotCharts.mp4

K2 Enterprises

Printing QuickBooks Financial Statements Without Account Numbers.mp4

K2 Enterprises

Using Data Subtotal To Get Monthly Subtotals On Daily Data.mp4

K2 Enterprises

A PivotTable Trick For Filtering Data

K2 Enterprises

Creating Multiple Calculations With Excel's Data Subtotal Functions

K2 Enterprises

Consolidating Items In QuickBooks

K2 Enterprises

Using Excel To Identify Duplicate Values

K2 Enterprises

Explore Excel's Horizontal Sorting Capabilities

K2 Enterprises

Improving Excel Accuracy with the Evaluate Formula Tool

K2 Enterprises

Comparing Multiple Documents for Changes In Word

K2 Enterprises

Creating Reversing Journal Entries in QuickBooks

K2 Enterprises