Hiding Data

[Carl Hilton]

I want to have a spread sheet that when printed will have some of the data
hidden...

I thought the most effective method would be to have two almost identical
sheets in a workbook, with the "private" data not copied to the second
sheet. This would be similar to an invoice sheet. Is there an easy way I can
copy a sheet and then when I paste it to another sheet, it will link the
data back to the first sheet?

Carl

 

[Andy B]

Hi

Quick and dirty? On the new sheet, cell A1, type = and then click on A1 in
your existing sheet. You can then autofill this across and down the new
sheet, and then hide the rows/columns you don't want to print.

 

[Carl Hilton]

That works for me... Thanks

Hi

Quick and dirty? On the new sheet, cell A1, type = and then click on A1 in
your existing sheet. You can then autofill this across and down the new
sheet, and then hide the rows/columns you don't want to print.

 

[Gord Dibben]

Carl

View>Custom Views

Make two views of the worksheet(including print settings) and just switch from
one to the other when printing.

Gord Dibben Excel MVP