Here is what will happen. Test this in a blank new workbook:

Enter in the following cells.
A1: You're the
B1: stupidest
C1: man !

Rightclick columnheader B. Choose Hide. Now it says "You're the man !",
which is far nicer. Go menu Tools Protection, protect the sheet with a
long complex password, mixed case, numbers and letters, at least 10
characters long. This is as safe as you possibly get. Celebrate with a
coffee.

Now Select cells A1:C1 with your mouse. Click the Copy button.
Go to another worksheet. Click any cell. Click the Paste button.

HTH. Best wishes Harald


"Fern" skrev i melding
...
Is it possible to restrict the view of several columns to one user? I have
a
spreadsheet that the whole team enters data into. The manager wants
columns
in the same spreadsheet where she can enter confidential information about
each project, so she should be the only person who can view or unhide or
ungroup those columns or something. Any suggestions?