Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding ROWS
is there a way to auto add rows in a work sheet when there are no more empty
ROWS to be filed and there is more work space rows needed? i have a row with different colums with text to be filed in. what i want to do is when i am typing in the texts and reach the end of the last row it auto add a new ROW of the same settings as the last and if possible have my documentation continued there. |
#2
|
|||
|
|||
You can use DataForm to add new records to an existing table. It will
automatically add the formulas to the new rows. Colin2u wrote: is there a way to auto add rows in a work sheet when there are no more empty ROWS to be filed and there is more work space rows needed? i have a row with different colums with text to be filed in. what i want to do is when i am typing in the texts and reach the end of the last row it auto add a new ROW of the same settings as the last and if possible have my documentation continued there. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Adding summaries, rows and pre-population | New Users to Excel | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Adding rows to an array | Excel Worksheet Functions |