ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I insert a row in a pivot table? (https://www.excelbanter.com/excel-worksheet-functions/130592-how-do-i-insert-row-pivot-table.html)

Deanna

how do I insert a row in a pivot table?
 
i need to insert a row with the date into a pivot table. any ideas? please
help!

Fred Smith

how do I insert a row in a pivot table?
 
Give us more information.

If you simply want to print the date on the same page as the Pivot table, use
Page Setup.

Another option is to enter the date in the column adjacent to the Pivot table.

Otherwise, tell us why you would want to insert a row in a Pivot table.

--
Regards,
Fred


"Deanna" wrote in message
...
i need to insert a row with the date into a pivot table. any ideas? please
help!




Deanna

how do I insert a row in a pivot table?
 
I am sorry, I meant data. I need to insert a row in the pivot table and am
unable to do so... thanks!!!

"Fred Smith" wrote:

Give us more information.

If you simply want to print the date on the same page as the Pivot table, use
Page Setup.

Another option is to enter the date in the column adjacent to the Pivot table.

Otherwise, tell us why you would want to insert a row in a Pivot table.

--
Regards,
Fred


"Deanna" wrote in message
...
i need to insert a row with the date into a pivot table. any ideas? please
help!





Fred Smith

how do I insert a row in a pivot table?
 
But why isn't the data in the source table? Isn't that the best place for it?

You still haven't given us any idea of what data you want to insert, where in
the table, etc.

If you want a brute force solution, copy the pivot table, and paste special
values. Now you can modify the table to your heart's content.

--
Regards,
Fred


"Deanna" wrote in message
...
I am sorry, I meant data. I need to insert a row in the pivot table and am
unable to do so... thanks!!!

"Fred Smith" wrote:

Give us more information.

If you simply want to print the date on the same page as the Pivot table, use
Page Setup.

Another option is to enter the date in the column adjacent to the Pivot
table.

Otherwise, tell us why you would want to insert a row in a Pivot table.

--
Regards,
Fred


"Deanna" wrote in message
...
i need to insert a row with the date into a pivot table. any ideas? please
help!







Deanna

how do I insert a row in a pivot table?
 
Thanks a lot - I'll try it at work on Tuesday.

"Fred Smith" wrote:

But why isn't the data in the source table? Isn't that the best place for it?

You still haven't given us any idea of what data you want to insert, where in
the table, etc.

If you want a brute force solution, copy the pivot table, and paste special
values. Now you can modify the table to your heart's content.

--
Regards,
Fred


"Deanna" wrote in message
...
I am sorry, I meant data. I need to insert a row in the pivot table and am
unable to do so... thanks!!!

"Fred Smith" wrote:

Give us more information.

If you simply want to print the date on the same page as the Pivot table, use
Page Setup.

Another option is to enter the date in the column adjacent to the Pivot
table.

Otherwise, tell us why you would want to insert a row in a Pivot table.

--
Regards,
Fred


"Deanna" wrote in message
...
i need to insert a row with the date into a pivot table. any ideas? please
help!








All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com