Mirroring cells
One way is to right click the tab name at the bottom of the screen, and
in the window that pops up choose Move or Copy. In the next window
check the Create a Copy box and press OK. This makes an exact
duplicate of the sheet with all formats, headers, footers, etc. From
there you can delete all the information that came with the original
sheet, and apply your formulas.
|