Learn to organize your worksheets effectively by storing them
in workbooks. Also learn to share data within a workbook, from
workbook to workbook, and with other users.
Are you currently saving every Excel spreadsheet in a separate
file? Did you know you can have multiple pages in a one Excel
file called a "workbook?" Did you know you could create
formulas that span multiple worksheets? Did you know you could
share workbooks with other users?
-
Learn how to keep related spreadsheets in one workbook file.
-
Name worksheet pages for easy retrieval.
-
Change the color of worksheet tabs.
-
Insert, delete, and move worksheets to where you want them.
-
Change the default number of worksheets in new workbooks.
-
Copy or move a worksheet within a workbook or to another
workbook (to use as a template for new data).
-
Copy or move a range of cells within a workbook or to another
workbook.
-
Group worksheets and simultaneously edit or format the data
on all the worksheets.
-
Create formulas that span multiple worksheets.
-
Hide worksheets to reduce the number of worksheet tabs and
prevent undesired viewing.
-
Print workbooks or selected sheets within the workbook.
-
Assign a password to prevent unauthorized people from reading
and/or editing the workbook.
-
Protect specific cells in a worksheet so they can't be modified
until unprotected.
-
Hide formulas from others using the workbook.
-
Share workbooks with other users for simultaneous updates.
-
Send a workbook as an e-mail attachment.
-
Save a workbook to Windows Live SkyDrive.
-
Import and export XML data.
