How to increase the rows from 16 to 36? (file attached)

		Microsoft Office Forums > Microsoft Excel > Excel
How to increase the rows from 16 to 36? (file attached)

FAQ

Thread Tools

Display Modes

06-29-2020, 09:12 AM

Purfleet

Windows 10 How to increase the rows from 16 to 36? (file attached)

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

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

Attached Files

Dummy Excel_purfleet.xlsm (15.3 KB, 6 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 PM.