How to Save Workbook in Excel

Last updated on Sep 27 2021
Hitesh Doshi

Table of Contents

How to Save Workbook in Excel

Saving New Sheet

Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet −
Step 1 − Click the File tab and select Save As option.

microsoftExcel 16
microsoftExcel

Step 2 − Select a folder where you would like to save the sheet, Enter file name, which you want to give to your sheet and Select a Save as type, by default it is .xlsx format.

microsoftExcel 17
microsoftExcel

Step 3 − Finally, click on Save button and your sheet will be saved with the entered name in the selected folder.

Saving New Changes

There may be a situation when you open an existing sheet and edit it partially or completely, or even you would like to save the changes in between editing of the sheet. If you want to save this sheet with the same name, then you can use either of the following simple options −
• Just press Ctrl + S keys to save the changes.
• Optionally, you can click on the floppy icon available at the top left corner and just above the File tab. This option will also save the changes.
• You can also use third method to save the changes, which is the Save option available just above the Save As option as shown in the above screen capture.
If your sheet is new and it was never saved so far, then with either of the three options, word would display you a dialogue box to let you select a folder, and enter sheet name as explained in case of saving new sheet.

Rows & Columns in Excel

Row and Column Basics

MS Excel is in tabular format consisting of rows and columns.
• Row runs horizontally while Column runs vertically.
• Each row is identified by row number, which runs vertically at the left side of the sheet.
• Each column is identified by column header, which runs horizontally at the top of the sheet.
For MS Excel, Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns.

Navigation with Rows and Columns

Let us see how to move to the last row or the last column.
• You can go to the last row by clicking Control + Down Navigation arrow.
• You can go to the last column by clicking Control + Right Navigation arrow.

microsoftExcel 18
microsoftExcel

Cell Introduction

The intersection of rows and columns is called cell.
Cell is identified with Combination of column header and row number.
For example − A1, A2.

microsoftExcel 19
microsoftExcel

So, this brings us to the end of blog. This Tecklearn ‘How to Save Workbook in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI
• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources
Power BI Workflow
• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships
Power Query for Data Transformation
• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations
Filters and Drill Down Report
• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report
Power Pivot for Data Modelling
• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions
Data Analysis Expression – DAX Queries
• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features
Power BI Desktop & Administration
• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters
Introduction to Power Q & A
• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

 

 

0 responses on "How to Save Workbook in Excel"

Leave a Message

Your email address will not be published. Required fields are marked *