Saving your Workbook

How to insert rows, columns, and cells

How to save the workbook

• Click on the Microsoft Office button.
• Select and click on Save or Save As.

• Save As allows you to name the file and choose a location to save the spreadsheet. Choose Save As if you would like to save the file for the first time or if you would like to save the file as a different name.
• Select Save if the file has already been named.

Workingwith Different Page Views in Microsoft Excel 

The two most common ways of saving a workbook are;

There are many ways of saving but the two common ones are saving with a 2007 file extension, or as an Excel 97-2003 Workbook, which saves the file in a compatible format so that people who have earlier versions of Excel can open the file. 

Compatibility mode

There may be need to work with workbooks that were created using earlier versions of Microsoft Excel sometimes, such as Excel 2003 or Excel 2000. 

When you open these kinds of workbooks, they will appear in Compatibility mode.

Compatibility mode disables certain features, so you will only be able to access commands found in the program that was used to create the workbook. 

For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

• You will want to access all features of Excel 2007, you can save the workbook in the Excel 2007 file format.

How to exit Compatibility mode

• Click the Microsoft Office button.
• Select Save As Excel Workbook.

How to modify columns, rows, and cells