How do I add a row to a data table?

  • Thread starter Thread starter Scarlet.pirate
  • Start date Start date
S

Scarlet.pirate

I am trying to add a row to a data table, but it gives me the error message
"cannot change part of a table." How do I add a row? Using a blank cell at
the bottom of the worksheet won't work, based on how the data is set up.
 
I'm not sure if that would work. I use it for accounting stuff, and so there
are multiple sections on the worksheet, and this new row needs to go
somewhere in the middle.
 
.. this new row needs to go somewhere in the middle.

Then you have to clear the data table first*,
insert the row, then reconstruct the table

*select any cell within the table, ie any cell with the data table's
"formula", eg: {=TABLE(,B1)}, then press CTRL + "/" key to select the full
extent of the data table
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0
How do I add extra data to a pivot table? 3
Excel Moving data to sheet2 from sheet1 0
Add Row to end of Table with a Macro Button 7
Excel Help to copy information from one row at a time to another sheet 1
How can I insert rows BELOW, in Excel 1
Adding to an existing Pivot Table 7

Back
Top