"Save a Workbook? And Backup Copy…"

Do you know how to save a workbook in Microsoft Excel 2007?

Yes, you can either save the workbook in your computer hard drive or other device such as diskette or handy/flash drive.

If you never save the file, you will be unable to view the file in the future. Once saved, you can re-open the file for viewing or editing.

Although Excel AutoRecover feature may recover your unsaved file, you should never rely on Excel AutoRecover feature. Saving your work frequently is a good idea.

To save a workbook (first time)

• From Office Button, click Save OR

Click the Save button on the Quick Access Toolbar.
• From the Save As dialog box displayed, ensure that you browse to the folder/disk drive that you would like to save the file.

• Enter the file name in the File name: text box. The file name can be up to 255 characters in length.
• Click on the Save button.

To save a backup copy (subsequent times)

• From the Office Button, point to Save As and click Excel Workbook.
• Enter a name in the File name: text box.
• Click on the Save button.

Note: By default, Excel saves a copy of your work automatically every ten minutes. To adjust this setting (or turn if off), use the Save tab of the Excel Options dialog box (Office Button - Excel Options).

To close a file

• From the Office Button, click Close.
• You will be asked if you wish to save any changes you have made to the file.

• Click Yes to save the workbook

OR click No to ignore (without saving) the changes
OR click Cancel to cancel the operation

To conclude, you have two choices for saving a spreadsheet file:

• Save As - this choice allows you to save your spreadsheet file with a new name and choose the location to save the file.
• Save - this option updates the spreadsheet file with your most recent changes. If you use Save on a new file that hasn't been saved before, it has the same effect as Save As.

Related Topics:

Getting Started with Excel 2007
Excel 2007 Screen Elements
The New Excel 2007 Ribbon
Excel 2007 Status Bar
How to Enter Data into the Excel 2007 Worksheet?

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the save a workbook info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb