How do I add a row to a data table?

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.
 
S

Scarlet.pirate

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.
 
M

Max

.. 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
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
Add a Subtotal Row to an Existing Table? 3
Excel Pivot Table row heading (blank) with no data in it 3
Last row on spreadsheet is row # 65536. How can I add more rows? 3
Conditional SUBTOTAL in XL210 Table 7
How do I add extra data to a pivot table? 3

Top