Hiding Data

C

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
 
A

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.
 
C

Carl Hilton

That works for me... Thanks

Andy B said:
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.
Click to expand...
 
G

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
 
Top