Tuesday, February 23, 2010

How to save a workbook in Excel 2010?

To save a workbook in Excel 2010, click on the File menu and click on Save. If you are saving the file for the first time, you will see the Save As dialog box. From the next time, you may click on the Save button from the Quick Access Toolbar (or) click on the File menu and click on Save (or) press Ctrl + S (or) press Alt + F + S. The following is the summarization of the save operation in Excel 2010.
1. Click File menu and click Save (or) click the Save button from the Quick Access Toolbar.
2. The Save As dialog box will appear with the default settings unless you have changed the settings.
a. The workbook will be saved in the Documents folder. Change the location to save the workbook.
b. The workbook will have the name Book1. Save it under a name that best describes the workbook.
c. The workbook will be saved as Excel Workbook in the Save as type section. You can change the type section by clicking on the Excel Workbook and clicking a type from the dropdown box.
3. Click Save.

Please note that by default, Excel 2010 will save in a format that will be recognized by Excel 2007 or Excel 2010. For making your file to be recognized by an early version of Microsoft Excel, perform step 1. In step 2, in section c, click Excel Workbook and select Excel 97-2003 Workbook from the dropdown box.
/* */