#1
|
|||
|
|||
How to increase the rows from 16 to 36? (file attached)
How to lengthen my table? It stops at 16 rows, but I want 36 rows.
I choose "insert row", it worked, but numberings are gone like this: |
#2
|
|||
|
|||
Use defined Tables. When a whole column of defined Table contains same formula (or same format or Data Validation rule), whenever a new row is added, the same formula (or format or rule) is added into new fields of this column.
|
#3
|
|||
|
|||
I thought this was covered in a previous post?
Put this in cell a2 - =ROWS($A$2:A2)&"." and drag down Its and expanding range that counts rows, =ROWS($A$2:A2) is one, then the next one is =ROWS($A$2:A3)&"." Insert rows and then redrag and it will count down |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find duplicate rows in a huge excel file containing 500000 rows | Stc25234 | Excel Programming | 2 | 06-23-2017 10:51 AM |
Please Help for VBA Code for Attached File.. | krishnaoptif | Word VBA | 3 | 07-17-2012 12:29 AM |
Outlook2003 - how to write attached file to folder | nodari | Outlook | 1 | 05-26-2011 08:51 AM |
Impossible to open or save attached file | Lafayette | Outlook | 2 | 04-29-2011 04:41 PM |
Outlook xp slow when Browsing to attached a file | jmelgar1 | Outlook | 0 | 09-23-2008 01:49 PM |