"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.
  • Excel 2007 save as dialog box

  • 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.
  • Excel 2007 save 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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!

PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007

What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.