ReePrime
Blog DMC
Learn Excel from MrExcel - "Pivot to Range": #1456

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Learn Excel from MrExcel - "Pivot to Range": #1456

B
Bill Jelen

3 Views • Nov 02, 2011

Description

Two Pivot Table questions from my Power Excel Seminar in Detroit, MI. First, when I drill down on a pivot table in Excel 2007, I'm getting the Table Format, not just a Range. How can I get the Range? Second, when I convert a Pivot Table to Values...

Keywords & Tags

#2007 2010 accounting Bill Jelen business Data Excel Formatting formulas MrExcel Pivot Table Range spreadsheets technology tutorial Worksheet

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

00:57

Professional Excel Templates And Spreadsheets

CFOTemplates

00:42

MS Excel Setting Passwords in Existing Spreadsheets

Smoke Studios

02:31

How to print multiple excel spreadsheets (& worksheets) at once

HotHotSoftware1

02:56

How to Extract Data and Text from Multiple Excel Spreadsheets at once

HotHotSoftware1

01:14

How to print multiple excel spreadsheets at once (including active sheets)

HotHotSoftware1

03:12

Excel Pivot Table Tip - Make Cell Value Formatting Stick In A Pivot Table

Chudikenny