Placing a Pivottable in A1

K

kittronald

Using Microsoft Excel 2007, how can you place a Pivottable in cell A1
where the Row Labels are in row 1 ?

When I attempt to place a Pivottable in A1, the Report Filter field is
put in row 1, then there's a blank row in row 2 and then the Row
Labels of the Pivottable are put in row 3.

How can I move or hide the Report Filter field row and blank row ?



- Ronald K.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top