You could create a blank row on row 4, create a duplicate column header on
row 5 (ie A5: =A1) and hide both rows 4 and 5
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Bill Sturdevant" wrote in
message ...
Don't know if this is the right section of the newsgroup, but...
I have a worksheet with column headers in row 1.
I want to put instructions for each column in row 2 of every column
describing what to put in the cells below (instead of using pop-up
comments
in the header row).
I want to put an example in row 3 of every column.
I want to protect rows 1 through 3.
Finally, I need a way for the user to sort the entire worksheet using
column
headers of their choice WITHOUT causing rows 2 and 3 to move out of place.
Any suggestions? (Macros, Buttons with VB code, etc.)