Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
inserting rows

ResolvedVersion 2007

Charlene has attended:
Excel Intermediate course

Inserting Rows

Hi,


If I have a long list of information on excel and would like to inset 1-2 rows after each 50th row, is there a quick easy way t do this?

Thanks
Charlene Metcalfe

RE: Inserting Rows

Hi Charelene

Thanks for your post, a couple of us have look at what you are trying to do and we expected we would be able to reach a quick solution.

However whilst we are confident there is a solution, we will need to look at your files and spend some time on this. Naturally this will go beyond the scope of our support forum and may incur some costs.

If you do wish us to investigate further please contact us direct.

Thanks

Jacob

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.