How do we add one or more rows manually( by typing row numbers). ?

		Microsoft Office Forums > Microsoft Excel > Excel
How do we add one or more rows manually( by typing row numbers). ?

FAQ

Thread Tools

Display Modes

01-02-2016, 12:32 PM

NoSparks

Windows 7 64bit How do we add one or more rows manually( by typing row numbers). ?

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

That definitely doesn't explain anything.
Between which two rows?
Where are you typing those row numbers?

Here's what I'd do to quickly insert 25 blank rows between the existing rows 3 and 4.

Alt + F11 to bring up the VBA environment
Ctrl + g to bring up the immediate window
Type in

Code:

Rows(4).Resize(25).Insert

Hit Enter.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
manually defined port numbers are gone and defaults are loaded.	gcnivas	Outlook	0	09-26-2014 08:28 AM
Trying to autofilter 8-10 rows of numbers to sort in a group	Jack-P-Winner	Excel	0	11-25-2013 10:55 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Changing formats manually??	Flabbergaster	Word	1	11-03-2010 02:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 AM.