How to Open, Close, Delete and Hide Worksheet in Excel

Last updated on Sep 27 2021
Ravinder Patil

Table of Contents

How to Open, Close, Delete and Hide Worksheet in Excel

Hiding Worksheet in Excel

Hiding Worksheet

Here is the step to hide a worksheet.

Step − Right Click the Sheet Name and select the Hide option. Sheet will get hidden.

How to Perform Copy & Paste, Find & Replace in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Unhiding Worksheet

Here are the steps to unhide a worksheet.
Step 1 − Right Click on any Sheet Name and select the Unhide... option.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Step 2 − Select Sheet Name to unhide in Unhide dialog to unhide the sheet.
Press the Ok Button.
Now you will have your hidden sheet back.

Delete Worksheet in Excel

Delete Worksheet

Here is the step to delete a worksheet.

Step − Right Click the Sheet Name and select the Delete option.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Sheet will get deleted if it is empty, otherwise you’ll see a confirmation message.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Press the Delete Button.

Now your worksheet will get deleted.

Close Workbook in Excel

Close Workbook

Here are the steps to close a workbook.
Step 1 − Click the Close Button as shown below.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

You’ll see a confirmation message to save the workbook.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Step 2 − Press the Save Button to save the workbook
Now your worksheet will get closed.

Open Workbook in Excel

Let us see how to open workbook from excel in the below mentioned steps.

Step 1 − Click the File Menu as shown below. You can see the Open option in File Menu.

There are two more columns Recent workbooks and Recent places, where you can see the recently opened workbooks and the recent places from where workbooks are opened.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Step 2 − Clicking the Open Option will open the browse dialog as shown below. Browse the directory and find the file you need to open.

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

Step 3 − Once you select the workbook your workbook will be opened as below −

How to Open, Close, Delete and Hide Worksheet in Excel
How to Open, Close, Delete and Hide Worksheet in Excel

So, this brings us to the end of blog. This Tecklearn ‘How to Open, Close, Delete and Hide Worksheet 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 Open, Close, Delete and Hide Worksheet in Excel"

Leave a Message

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