Microsoft Office Tutorials and References
In Depth Information
Modifying workbooks
5
Enter 2012 , and then press Enter .
6
Right-click the 2013 sheet tab, point to Tab Color , and then, in the Standard Colors
palette, click the green swatch to change the 2013 sheet tab to green.
7
On the tab bar, drag the 2012 sheet tab to the right of the Scratch Pad sheet tab.
1
8
Right-click the 2013 sheet tab, and then click Hide to remove the 2013 sheet tab
from the tab bar.
9
Right-click the 2012 sheet tab, and then click Move or Copy to open the Move or
Copy dialog box.
10
Click the To book arrow, and then in the list, click (new book) .
11
Select the Create a copy check box.
12
Click OK to create a new workbook and copy the selected worksheet into it.
13
On the Quick Access Toolbar , click Save to open the Save As dialog box.
14
In the File name field, enter 2012 Archive , and then press Enter to save the
workbook.
15
On the View tab, click the Switch Windows button, and then click ExceptionTracking
to display the ExceptionTracking workbook.
16
On the tab bar, right-click the Scratch Pad sheet tab, and then click Delete . In the
dialog box that opens, click Delete to confirm the operation.
17
Right-click the 2012 sheet tab, and then click Unhide to open the Unhide dialog box.
 
Search JabSto ::




Custom Search