1. New: Create a new Excel workbook.
2. Open: Open an existing Excel workbook.
3. Save: Save the current Excel workbook.
4. Save As: Save the current Excel workbook with a new name or in a different location.
5. Print: Print the current Excel workbook or customize print settings.
6. Share: Share the current Excel workbook with others.
7. Export: Export the current Excel workbook to a different format, such as a PDF or CSV file.
8. Options: Access Excel settings and customization options.
9. Account: Manage your Microsoft account and subscription options.
10. Close: Close the current Excel workbook.
The File tab also provides access to recent files and displays information about the current Excel workbook, such as the file name, author, and properties.
1. How Open an existing Excel workbook
To open a file in Microsoft Excel, follow these steps:1. Launch Microsoft Excel on your computer.
2. Click on the File tab at the top left corner of the screen.
3. Select "Open" from the options listed on the left-hand side of the screen.
4. Navigate to the location where the file is saved using the file explorer window.
5. Click on the file you want to open to select it.
6. Click on the "Open" button at the bottom right corner of the screen.
Alternatively, you can also double-click on the file in the file explorer window to open it directly in Microsoft Excel.
2. Save
To save the current Excel workbook, follow these steps:
1. Open the Excel file you want to save as.
2. Click on the File tab at the top left corner of the screen.
3. Select "Save As" from the options listed on the left-hand side of the screen.
4. In the "Save As" dialog box, choose the location where you want to save the file.
5. In the "File name" field, type a new name for the file, if desired.
6. Choose the file format you want to use from the "Save as type" dropdown menu. Note: Excel files are typically saved as .xlsx or .xlsm files.
7. Click on the "Save" button at the bottom right corner of the screen to save the file with the new name and/or in the new location.
Alternatively, you can also use the keyboard shortcut "Ctrl+Shift+S" to quickly access the "Save As" dialog box.
1. Open the Excel worksheet or workbook you want to print.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Print" option on the left-hand side of the screen.
4. The Print pane will appear on the right-hand side of the screen.
5. Choose your desired printer from the drop-down menu.
6. Choose the number of copies you want to print.
7. Choose the pages you want to print under the "Settings" section.
8. Set any other print options, such as the paper size and orientation, margins, and page layout.
9. Click on the "Print" button to print the worksheet or workbook.
Alternatively, you can use the keyboard shortcut "Ctrl+P" to quickly access the Print pane.
1. Click on the File tab at the top left corner of the screen.
2. Click on the "Save" option on the left-hand side of the screen.
3. If the file is being saved for the first time, the "Save As" dialog box will appear. Choose the location where you want to save the file, and give it a name.
4. If the file has already been saved previously, it will be saved automatically with the same name and in the same location.
5. Alternatively, you can use the keyboard shortcut "Ctrl+S" to quickly save the current Excel workbook.
3. Save As:
To save an Excel file with a new name or in a different location, you can use the "Save As" option in Microsoft Excel. Here are the steps:1. Open the Excel file you want to save as.
2. Click on the File tab at the top left corner of the screen.
3. Select "Save As" from the options listed on the left-hand side of the screen.
4. In the "Save As" dialog box, choose the location where you want to save the file.
5. In the "File name" field, type a new name for the file, if desired.
6. Choose the file format you want to use from the "Save as type" dropdown menu. Note: Excel files are typically saved as .xlsx or .xlsm files.
7. Click on the "Save" button at the bottom right corner of the screen to save the file with the new name and/or in the new location.
Alternatively, you can also use the keyboard shortcut "Ctrl+Shift+S" to quickly access the "Save As" dialog box.
4. Print
To print a Microsoft Excel worksheet or workbook, follow these steps:1. Open the Excel worksheet or workbook you want to print.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Print" option on the left-hand side of the screen.
4. The Print pane will appear on the right-hand side of the screen.
5. Choose your desired printer from the drop-down menu.
6. Choose the number of copies you want to print.
7. Choose the pages you want to print under the "Settings" section.
8. Set any other print options, such as the paper size and orientation, margins, and page layout.
9. Click on the "Print" button to print the worksheet or workbook.
Alternatively, you can use the keyboard shortcut "Ctrl+P" to quickly access the Print pane.
5. Share
The "Share" option in the File tab of Microsoft Excel allows you to share your Excel workbook with other people. Here are the steps to use this feature:
1. Open the Excel workbook you want to share.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Share" option on the left-hand side of the screen.
4. The Share pane will appear on the right-hand side of the screen.
5. Choose how you want to share the file. You can share via email, OneDrive, SharePoint, or other online storage services.
6. Enter the email addresses of the people you want to share the file with.
7. Add a message, if desired.
8. Choose the permission level you want to grant to the people you are sharing with, such as "Can edit" or "Can view".
9. Click on the "Share" button to send the sharing invitation.
1. Open the Excel workbook you want to export.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Export" option on the left-hand side of the screen.
4. Choose the file type you want to export the workbook as, such as PDF, CSV, or XPS.
5. Choose the location where you want to save the exported file.
6. Give the exported file a name, if desired.
7. Click on the "Export" button to export the workbook in the selected file type.
Alternatively, you can also use the "Save As" option to save the workbook in a different file format or type. This option provides more file types than the "Export" option, and you can also choose the Excel file type you want to save the workbook as.
1. Open the Excel workbook you want to share.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Share" option on the left-hand side of the screen.
4. The Share pane will appear on the right-hand side of the screen.
5. Choose how you want to share the file. You can share via email, OneDrive, SharePoint, or other online storage services.
6. Enter the email addresses of the people you want to share the file with.
7. Add a message, if desired.
8. Choose the permission level you want to grant to the people you are sharing with, such as "Can edit" or "Can view".
9. Click on the "Share" button to send the sharing invitation.
6. Export
The "Export" option in the File tab of Microsoft Excel allows you to save your workbook in a different format or file type. Here are the steps to use this feature:1. Open the Excel workbook you want to export.
2. Click on the File tab at the top left corner of the screen.
3. Select the "Export" option on the left-hand side of the screen.
4. Choose the file type you want to export the workbook as, such as PDF, CSV, or XPS.
5. Choose the location where you want to save the exported file.
6. Give the exported file a name, if desired.
7. Click on the "Export" button to export the workbook in the selected file type.
Alternatively, you can also use the "Save As" option to save the workbook in a different file format or type. This option provides more file types than the "Export" option, and you can also choose the Excel file type you want to save the workbook as.