Thread: How do I add a row to a data table?
View Single Post
  #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 With QuoteReply With Quote