Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 623
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default 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!




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 623
Default 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!






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default 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!








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert formula in a pivot table Nelson Excel Discussion (Misc queries) 5 February 9th 07 06:03 PM
PIVOT TABLE HOW TO INSERT....... drhell Excel Discussion (Misc queries) 2 January 30th 07 01:02 AM
Pivot Table Refresh - Auto insert row Dominic LeVasseur Excel Discussion (Misc queries) 4 September 6th 06 01:03 AM
Insert a row after a pivot table MarkM Excel Discussion (Misc queries) 0 July 19th 06 09:19 PM
Insert column in Pivot Table NewExcel2003User Excel Worksheet Functions 1 November 24th 04 11:20 AM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"