Setting a custom view

  • Thread starter Thread starter Marty H
  • Start date Start date
M

Marty H

I want to send someone one of my worksheets, but I don't want to send them
all of the cells. How can I set a custom view that will only show a select
range of cells without having to highlight them all, and the hiding them.
Thanks
 
First, if that data that you're hiding is proprietary (or just shouldn't be
viewed by others), then hiding the ranges (columns or rows???) isn't secure.
You'd have to protect the worksheet and that kind of protection is easily
broken.

But if you're hiding columns/rows just to make the worksheet easier to use by
the recipient, you can set up the worksheet the way you like (call it Normal).
Then view|custom views|add (in xl2003 menus)

Then hide the columns you want and do the same thing--but give it a different
name.

Then you can toggle the view by choosing from the custom view dialog.

Again, if it's data that the recipient shouldn't see, don't put it into excel.
If you have to put it into excel, don't share the workbook.
 
Back
Top