Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Inserting a row throughout a whole workbook

Resolved · Urgent Priority · Version 2003

Reply Thu 8 Apr 2010, 11:33Delegate Liz said...

Liz has attended:
SharePoint course

Inserting a row throughout a whole workbook

how do I do this please

For upcoming training course dates see: Pricing & availability

Reply Fri 9 Apr 2010, 18:03Trainer Andrew said...

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 articles

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Sorting Out Your Data In Excel
· Discover The PMT, IPMT And PPMT Functions In Excel
· Discover The Difference Between Line And XY Scatter Charts In Excel
· Microsoft Excel provides the building blocks of shared information

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips