What is File tab and its uses?
File tab contains the basic required options such as New, Open, Save, Save as, Print, Share, Export, and Close options. Other than the aforementioned options, we can find account and Excel options tab, too.
a) Info: - With this option, we can get the information about the particular Excel file. Created date, last modified date, Author name, Properties, versions etc.
b) New: - We use this option to open the new Excel file. We can open new file using shortcut key, Ctrl+N or by Clicking on File tab > New > Blank workbook. If Excel file is not opened, then Press Window+R and type Excel, New Excel file will open.
c) Open: - We use this option to open the existing file (shortcut Ctrl+O). “Open” option appears and you can choose to open the file.
Alternatively, File tab > Open > choose the file
We can set the page according to our requirements. G) Share: - We use this option to share the file with multiple users and send it over email. To share the file we can follow the steps: - Click on File tab Share. H) Export: - We use this option to export the file in PDF or XPS document and we can change the file type as well. The code samples that read schema information from Excel files require an additional reference in the script project to the System.Xml namespace. Set the default scripting language for the Script component by using the Scripting language option on the General page of the Options dialog box. For more information, see General Page.
d) Save: - We use this option to save the current file.
Shortcut: - Ctrl+S
- In some cases, you can set how frequently these AutoRecover files are saved. For example, if you set AutoRecover to save every 5 minutes, you may recover more information in the event of unexpected shutdown — such as from a power outage — than if it's set to save every 10 or 15 minutes.
- From this screen, you can create PDFs, set the general settings, define how certain elements are transferred into the PDF, set the default print quality, and set the page range. Click Create File to create a file with the defined settings. Click OK to save the settings without creating a file. Click Cancel to discard the changes and return.
- Note: Sheet views are currently limited to Excel 2007 or later files stored in OneDrive, OneDrive for Business, and SharePoint.If you save a local copy of a file that contains sheet views, the sheet views will be unavailable until the file is saved to SharePoint and opened from that environment.
Path: - Click on File tab >Save
The Microsoft Excel File In General Is A Set Of Events
e) Save as: - We use this option to make another copy or save the file at another place. F12 is the shortcut key to save as the file or we can save the file following these steps: - Click on File tab > Save as and then choose the location.
f) Print: - We use this option to print the current file. Ctrl+P is the shortcut key to print, or we can follow these steps: - File > Print and then we will have the page setup option. We can set the page according to our requirements.
g) Share: - We use this option to share the file with multiple users and send it over email. To share the file we can follow the steps: - Click on File tab >Share.
h) Export: - We use this option to export the file in PDF or XPS document and we can change the file type as well. To Export the file, we can follow the steps: - Click on File tab >Export. And then we can export it as per our requirement.
i) Close: - We use this option to close the file. Ctrl+W is the shortcut key to close the workbook or we can follow the steps: - Click on File tab >Close, active file will be closed. When we close the file, we get the confirmation message to save the file or not or cancel the command.
j) Account: - We use this option to sign in to our office account and we can change office theme, too. We can follow the steps: - Click on File tab >Active, Active window will appear.
k) Options: - It was in the tool menu of the previous versions of 2007 MS. We use this option to add extra and advanced features, like Developer tab, Power pivot, Analysis toolpak and many more. Also, we can change default settings, like font size, font style, number of sheets etc. In Excel options, we have 10 categories:-
1) General
2) Formulas
3) Proofing
4) Save
5) Language
The Microsoft Excel File In General Is A Set Of One
6) Advanced
7) Customize Ribbon
8) Quick Access toolbar
9) Add Ins
10) Trust Center
Ezip 1 7 3 x 4. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at [email protected]
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at [email protected]
Excel is used to conduct calculation, research, data visualization in charts, data management, data analytics. It is widely used in work and study. If you do not create a backup of Excel files, accidental deletions or changes to a file can ruin your day.
How to create auto backup for excel file
Go to File > Save As.
For Excel 2016, click 'More options…' under the save location. Earlier versions of Excel: skip this
Click the Tools button then General Options in the Save As dialog window.
Check the box next to 'Always create backup'
Be noticed that the backup copy saves in the same folder as the original one, if you meet hard disk failure or virus attack, you may lose the two filed simultaneously. Therefore, it is better to backup Excel file in different location. If one copy is lost, at least you have another one to recover it to the previous state.
Next, I will introduce you two ways to backup Excel file in different location, one is using Macro, the other is using a third party tool – AOMEI Backupper.
Backup excel file in different location with Macro
An Excel macro is a set of programming instructions stored in what is known as VBA code. It can be used to eliminate the need to repeat the steps of commonly performed tasks over and over again.
To begin, you need to enable Macro. Open Excel, click File ->Option ->Customize Ribbon ->check the Developer box in the list on the right. Click OK, and you’ll see the developer tab at the end of your tab list.
After enabling Macro, press Alt + F11 keys to open Microsoft Visual Basic for Applications window.
Click Insert > Module and paste below code to the Module script. See screenshot:
Sub SaveToLocations()
'UpdateByExtendoffice20160623
ActiveWorkbook.SaveCopyAs 'C:UsersDT168Documents' + ActiveWorkbook.Name
ActiveWorkbook.SaveCopyAs 'C:UsersDT168' + ActiveWorkbook.Name
ActiveWorkbook.Save
End Sub
Tips: in the macro code, you can change the saving paths as you want.
Press F5 key to run the code, and the active workbook has been saved to the locations you specified in the code.
Backup Excel file in different location by AOMEI Backupper
There is also another easy way to Backup Excel file in different location.
AOMEI Backupper is a reliable software designed for your data security. You can use it to backup system, partition, hard drive, files and folder to external hard drive, cloud drive, NAS, CD/DVD, internal hard drive, etc.
You are allowed to backup specific files or folders with File Backup feature, and the Filter settings allow you to backup a certain type of files. The best part is you can schedule an automatic backup based on five modes, Daily, Weekly, Monthly, Event Triggers, Real-time Sync respectively.
This software is available to Windows system including Windows 10/8/9/XP/Visa, and it supports almost all File Systems like NTFS, FAT32, FAT16, EX2, EXT3 and other File Systems.
To backup Excel file, download AOMEI Backupper and this software first. Take USB drive as an example, let’s see how to backup excel files to a flash drive.
Step 1. Open AOMEI Backupper, at the main interface, click Backup, and select File Backup.
Step 2. At the next window, click Add File or Add Folder.
Step 3. Then it will pop up a new window, just choose Excel file that you want to backup.
If you choose Add Folder, you can click Filter settings, it will show the details for you to set a certain file extension. Type the file extension *.xls in File Inclusion Mask.
There are also File Exclusion Mask and Folder Exclusion Mask. You can use the two boxes as you want. After all the settings, click OK to go back to the File Backup interface.
Step 4. Select USB drive as the destination path. To prevent data loss from catastrophic events like hard disk failure or system crash, you can backup Excel file in different location from the original one. It is recommended to backup Excel files to external hard drive or backup to NAS.
Step 5. To backup Excel file automatically, click Schedule and choose a backup mode.
Tips:
① By default, it will perform incremental backup which is space-saving. If you want to create full backup or differential backup, click Advanced at Schedule to change the way to perform the scheduled backup.
The Microsoft Excel File In General Is A Set Of The Following
② There are also Options and Scheme that you can click to have more advanced settings.
- Options: you can encrypt your backup and enable email notification by clicking Options.
- Scheme: to make sure your backup drive will not run out of space, you can click Scheme to set auto delete old backups when the number of backup reaches a certain value.
Step 6. After all these done, click Start Backup.
If you want to real-time monitor the change and create continuous data protection, you can use the Real-Time Sync feature under Sync.
Conclusion
The Microsoft Excel File In General Is A Set Of Operations
Creating an auto backup for Excel file is necessary to protect your files from mistaken deletion or changes. However, if you want to protect your files from disasters like hard disk failure or system crash, you should backup Excel file in different location from the source one.
As mentioned above, AOMEI Backupper supports many storages devices, you can feel free to choose one based on your practical situation.