How to increment numbers automatically in excel using macro
Closed
Bhavanim
Posts
2
Registration date
Thursday September 5, 2013
Status
Member
Last seen
September 5, 2013
-
Sep 5, 2013 at 03:57 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 5, 2013 at 08:58 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 5, 2013 at 08:58 AM
Related:
- How to increment numbers automatically in excel using macro
- Transfer data from one excel worksheet to another automatically - Guide
- Spell number in excel without macro - Guide
- How to take screenshot in excel - Guide
- Macros in excel download - Download - Spreadsheets
- How to change author in excel - Guide
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 5, 2013 at 07:47 AM
Sep 5, 2013 at 07:47 AM
in excel 2007
clcik excel icon on top left and click excel options
click advanced
check (put a tick) against
"enable fill handle and cell drag-on ....."
hit ok at the bottom
type in A1
TC001
take the cursor to bottom right of A1
The cursor will become plus sign(+)
click this plus, hold and drag down as many cells as you like.
clcik excel icon on top left and click excel options
click advanced
check (put a tick) against
"enable fill handle and cell drag-on ....."
hit ok at the bottom
type in A1
TC001
take the cursor to bottom right of A1
The cursor will become plus sign(+)
click this plus, hold and drag down as many cells as you like.
Bhavanim
Posts
2
Registration date
Thursday September 5, 2013
Status
Member
Last seen
September 5, 2013
Sep 5, 2013 at 07:51 AM
Sep 5, 2013 at 07:51 AM
I am not able to do this when it is a merged cell. Can u help me in this?
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 5, 2013 at 08:56 AM
Sep 5, 2013 at 08:56 AM
why merge cells? is it for sosmetic purposes. iln that case demerge and do this and merge again. otheriwse post the data. or send the file through speedyshare.com
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 5, 2013 at 08:58 AM
Sep 5, 2013 at 08:58 AM
try at the end of the merged cells. does it work.
