After completion of each work is necessary to save or archive the finished work. So after working in Excel, we need to save our data and, if necessary, close Microsoft Excel 2013. If you are an absolute beginner, I'll show you how you can save and archive your work in Excel and quit Excel 2013.
How to Save the Workbook in Excel 2013
Saving Excel documents can be done in several ways. First we have to decide on several elements before recording our work.
Various situations when saving workbooks
- Did you create a new workbook so that we would easily save in a folder (directory)
- Did you make changes to an existing workbook, and we want to save our work without renaming the workbook
- Did you make changes to an existing workbook, and you want to save your work but under a different name workbook
Once we take into account the above three parameters (depending on the situation and our intention) can access saving and archiving our workbook in Excel 2013
If you are in a situation as in the first and second parameter (see list above situation) then we can access you save the workbook so that:
Save the Workbook via Quick Access Toolbar
Simply click on the icon (button) to capture workbook in the toolbar for quick access or press the key combination on your keyboard CTRL+S. If a brand new workbook to be recorded will provide us with the Save As dialog box (see the continuation of this tutorial). If the book is already created and filmed then nothing will happen, but will simply take a picture Excel workbook.
Save the workbook through the Backstage View window File menu
Another way in this situation is through the File menu and Backstage view window. After opening the Backstage View window is necessary to choose the location where you want to save the workbook. Take for example that we want to save the workbook on the C partition our hard drive in the Temp folder and sub-folder excel-2013.
Then we click on the Browse option in the Backstage View window. We'll find a destination folder and type in a new name for the workbook (this name will be identical to the name of the Excel file with the extension or extension depending on the type of file). So you see in the picture below you can save a workbook for older versions of Excel (*. xls) choice in the 'Save as type'. In the field 'File name' will enter the new name for the workbook.
How to display file extension when saving workbook
If you look at the image above, you will notice that when you save the workbook, you do not see the file types or file format extensions. To see the file extension, then do the following:
Instructions for how to turn on file extension display in Windows OS:
Uncheck 'Hide extensions for known file types'
"Show extensions for known file types"
- In Windows 7, click 'Start' -> 'Documents' and in the toolbar, click 'Organize' and then select 'Folder and search options'
(In older Windows, this could be: 'Start' -> 'My Documents' and in the toolbar select 'Tools' -> 'Folder Options')
-In the new 'Folder Options' window, click on the 'View' tab and uncheck 'Hide extensions for known file types' then press the 'OK' button.
Speaking of saving the workbook I want to mention one important option that allows us to Excel program. This option is called automatically record every few minutes or periodically. This option is necessary to include the settings for saving workbooks or Save AutoRecover information every. When we this option is enabled Excel automatically saves our work at set periodic intervals and allows us to think we can keep all the steps up to the last autosave (e.g. in case there is no electricity while working on the computer)
Closing the workbook and Excel programs
After finishing work in Excel workbook or worksheet can finish work and close the program. If you have recorded a workbook and want to quit, do the following:
Click the Close button on the title bar and will close Excel workbook.
Another way of closing the workbook via keyboard combinations ALT+F4 or click on the Excel icon in the title bar at the top left corner of the window that is always visible, and then the Close command. After clicking closes the Excel worksheet window and the active workbook but not the entire Excel program if you have multiple open workbooks
Close the Workbook and Worksheet without closing the Excel program
The third way of closing the Excel workbook via File menu and Backstage View window. In the window, click the Close option. If you have multiple open workbooks will then click on the Close option to close the entire operating window and Excel workbook or worksheet. In case you have only one active Excel worksheet window will then close the workbook but not close Excel 2013 program.
That's it, let's go to the next tutorial.