Pivot Tables - and entering data corresponding to that row

  • Thread starter Thread starter KimC
  • Start date Start date
K

KimC

I'm very very new to pivot tables - and i was wondering if it is possible to
have an empty cell next to the information that I can enter stuff in to
correspond with the item showing.
 
Pivot tables are great, but you can not enter info into them directly. You
need to enter info into the source data of the pivot table and then refresh
the table.

You can put formulas and such in cells next to or below the pivot table but
as if the pivot table expands in size it may overwrite your formulas. It will
ask you first but it does not insert columns or rows, it just overwrites...

Not sure if that answers your question but the question is a littel vague...
 
Thankyou, that did answer my question. I thought that might be the answer I
was hoping it wasnt.

Thankyou again
 
You must log in or register to reply here.

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

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Help 1
Adding to an existing Pivot Table 7
Pivot Table - Changes 5
Pivot table filter list - listing irrelevant subcategorys 1
Pivot tables problem 1
Pivot table consolidation 1
Pivot Table Columns 3

Back
Top