inserting row throughout whole

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Inserting a row throughout a whole workbook | Excel forum

Inserting a row throughout a whole workbook | Excel forum

resolvedResolved · Urgent Priority · Version 2003

Liz has attended:
SharePoint course

Inserting a row throughout a whole workbook

how do I do this please

RE: inserting a row throughout a whole workbook

Hi Liz

Thank you for your question. It sounds like you are looking to insert a row in the same place on each sheet within a workbook.

I am not aware of a feature built into Excel that would do this for you. Rather you would need to develop some VBA (Visual Basic for Applications) code that would automate the process for you.


Do let us know if you have any further questions.

Kind regards,
Andrew

Fri 16 Apr 2010: Automatically marked as resolved.


 

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


Server loaded in 0.08 secs.