Can I insert 3 blank rows befoe a particular piece of data?

[Dave]

I import class rosters into a transportation log (excel ss).

In this data is the instructor. I want to know, based on the word
"instructor", can I insert 3 blank rows about the instructors row of data.

The purpose is so the instructor stands out when goes to a hotel and
airlines.

Thanks in advance!

BTW Excel 2000 - if a newer version will do this, let me know please..

 

[Max]

The purpose is so the instructor stands out when goes to a hotel and

airlines.

An alternative to consider might be conditional formatting ..

Assume col B is where "Instructor" will be located, amongst
others such as "Student", etc

Select col B

Click Formatting > Conditional Formatting

Make the settings under Condition 1 as:
Formula Is | = =TRIM(B1)="Instructor"
Click Format button > Patterns tab > Grey? > OK

Click OK at the main dialog

 

[Max]

Typo correction, sorry ..:

Formula Is | = =TRIM(B1)="Instructor"

should have read:

Formula Is | =TRIM(B1)="Instructor"

One equal "=" too many ..

 

[Dave]

Thanks for the idea I will let you know the outcome!

Dave

 

[Max]

You're welcome, Dave !