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
looping macros

ResolvedVersion 2007

Mark has attended:
Excel Advanced course

Looping Macros

How can I insert a page break above a specific cell everytime I find a piece of text in a range of cells if my worksheet is a few hundred rows long?

RE: Looping Macros

Hi Mark

Thanks for getting in touch. You can only really do this in a macro with a little knowledge of the VBA language behind the scenes.

To try and make a life a little easier without programming, I would record performing a Find action (CTRL F) and Inserting a page break. Assign this macro to a shortcut key and you can press this over and over to insert your breaks.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Looping Macros

That's a great tip and will save me loads of time. Thanks Gary!

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

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