Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a row to a data table?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a row to a data table?
You need to re-do it via the menu command: Data Table.
Re-select the table, inclusive of your extended row, then click Data Table, and do the steps .. -- Max Singapore http://savefile.com/projects/236895 Downloads:18,000 Files:359 Subscribers:56 xdemechanik --- "Scarlet.pirate" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a row to a data table?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a row to a data table?
.. 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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |