graphic2
graphic1

Create a Summary Sheet, cont.

4. Delete Column C and D

Select Column C and D.

Go to Home->Cells->Delete.

Click on Delete Sheet Columns.

 

What Do You See? The equations in the Revenue column now read: #REF!. The equation doesn’t have the data for Net and Quantity anymore. It has nothing to reference, hence the error message.

 

Go ahead: select those cells and hit the delete key to clear the busted equations.

graphic3

Home ->Cells -> Delete ->Delete Sheet Columns