Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / July 2007

Tip: Looking for answers? Try searching our database.

How to repeat the same cells under each row

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TheMonimey - 10 Jul 2007 09:20 GMT
I regularly make reporting sheets and begin with a number of single rows.  
Under those rows I need to insert 2 more rows (1 at height 55 and one at
12.75) . Each of the two rows are merged into one column each.

Currently, I first go down the pages inserting two rows under each entry
then copy and paste the two rows required into the two blamk rows I have
previously inserted.

As each report has between 200 and 500 single entries, this is a very
tedious way of going about the task.

Is there any way I can select the two rows I want and have them
automatically inserted under each entry.

example
START WITH THIS
1234    abcd    hgghtgsf    jushsydr    kkkkk     hystvgdvbnbdfndn
2536    djnfc    djsiufdn     mmhbgu   mjkh      mjghb,dsfkbdbfvdj
5342    dhdh    hfdhdfg     hdhjghgs   hdgd      dhshgtdhvdsyhghs

END UP WITH THIS
1234    abcd    hgghtgsf    jushsydr    kkkkk     hystvgdvbnbdfndn
--------------------------------------------------------------------------
_____________________________________________________
_____________________________________________________
2536    djnfc    djsiufdn     mmhbgu   mjkh      mjghb,dsfkbdbfvdj
--------------------------------------------------------------------------
_____________________________________________________
_____________________________________________________

5342    dhdh    hfdhdfg     hdhjghgs   hdgd      dhshgtdhvdsyhghs
--------------------------------------------------------------------------
_____________________________________________________
_____________________________________________________

Any help would be appreciated.

Thank you
Signature

themonimey

CLR - 10 Jul 2007 13:12 GMT
ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will insert blank rows......

Vaya con Dios,
Chuck, CABGx3

> I regularly make reporting sheets and begin with a number of single rows.  
> Under those rows I need to insert 2 more rows (1 at height 55 and one at
[quoted text clipped - 34 lines]
>
> Thank you
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.