Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
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
Using 2 cells in a table to retrieve data from another table Andy G Excel Worksheet Functions 0 March 19th 08 11:12 PM
Convert Pivot table back to Data Table Samaa Excel Discussion (Misc queries) 2 March 21st 07 10:02 AM
convert Pivot table back to Data table Samaa Excel Discussion (Misc queries) 2 March 21st 07 09:22 AM
Convert Pivot Table to Normal Data table ashish128 Excel Discussion (Misc queries) 2 May 2nd 06 09:34 AM
Excel Pivot Table Plugin? (crosstab to data table) HoMoon115 Excel Discussion (Misc queries) 0 February 22nd 06 08:20 PM


All times are GMT +1. The time now is 09:00 PM.

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

About Us

"It's about Microsoft Excel"