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

excel rows

ResolvedVersion 2007

hayley has attended:
Excel Intermediate course
Multiple applications course

Excel rows

how do you insert many rows rather than insert a single row into a list of exsiting data on a work book rather than insert at the end of the list of data

RE: Excel rows

Hello Hayley,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding inserting rows.

The fastest way to insert multiple rows is to highlight the number of rows you want to insert and then, on the INSERT MENU, chose INSERT, then ROW.

That should automatically insert the number of rows you have selected.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Trainer

Mon 1 Oct 2012: Automatically marked as resolved.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

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.1 secs.