B
bigboy
how can i archive worksheets within a workbook without starting a new workbook?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DL
you cannot
workbook?bigboy said:how can i archive worksheets within a workbook without starting a new
H
Harlan Grove
DL wrote...
Depends on what OP means by 'archive'. If he means saving a copy of
given worksheets in their current state, those worksheets can be copied
WITHIN the workbook. There are various ways to freeze values in those
copied worksheets, ranging from selecting all cells, Edit > Copy, Edit
you cannot
Depends on what OP means by 'archive'. If he means saving a copy of
given worksheets in their current state, those worksheets can be copied
WITHIN the workbook. There are various ways to freeze values in those
copied worksheets, ranging from selecting all cells, Edit > Copy, Edit
A
Another Brian
Or the OP could right-click on the worksheet name tab and select MoveHarlan Grove said:DL wrote...
Depends on what OP means by 'archive'. If he means saving a copy of
given worksheets in their current state, those worksheets can be
copied
WITHIN the workbook. There are various ways to freeze values in
those
copied worksheets, ranging from selecting all cells, Edit > Copy,
Edit
or Copy. Then being sure to check the Save a Copy box, create a new
worksheet that is a copy of the original.
Brian