"Chi" wrote:
....
after I insert new row in sheet 1,
the formula in Column C
is not copy down to the new row ..

Think you need a macro to do this, for which other folks are better
positioned to help you (I don't know, sorry).

Ex: The word DEPARTMENT (bold) will become DEPARTMENT (not bold) and
Education Department (not bold) will become Education Department(bold)

Not sure what's happening here, I'm afraid .. but do note that formulas
cannot "carry over" any formatting from the source data.

--
Are you doing all this column re-arrangements
for printing reasons ?

If so, think Jim Cone has a nice Excel add-in "Side by Side"
which could help you.

It's available - free - upon direct request to Jim.

Try this post for details on how to reach Jim: http://tinyurl.com/9dwlv

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--