Lesson 5: Managing worksheets

Managing worksheets in Microsoft Excel

This video is a part of free Excel Training Singapore, where I show you how to Managing worksheets in Microsoft Excel from the basics and also cover a lot of advanced Features.

MS Excel is a wonderful Microsoft tool that allows users to constantly switch from one worksheet to other. Excel allows users to work on multiple sheets at a single time and reflect changes done in one sheet on the others as well. When you open the workbook, Microsoft excel provides users with a number of excel sheets already opened to work upon them. Microsoft allows smooth navigation of sheets from one to another by many ways such as by keyboard shortcuts, mouse navigation and others as well.

Major benefits of Microsoft Excel and worksheets are –

• Microsoft Excel allows users to add color to excel sheet tabs.
• Microsoft excel enables users to add numerous sheets at a time and enable multitasking
• Microsoft excel contains the option of chart sheet that contains various types of ready to use charts in which data can be directly filled.
• While excel allows to add numerous sheets so easily it gives the option of easy deleting sheets as well.
• Microsoft excel allows users to view worksheets in various formats such as freezing panes, splitting worksheets into panes and comparing sheets side by side that helps them to work efficiently with complex data.

How to change a worksheet’s name and color?

The already provided names by excel to sheets aren’t very intuitive while you’re working with data and preparing it for professional presentation or any other purpose. Excel gives you the choice to edit the name of the sheet. To learn how it can be done, follow the following mentioned steps –

• All the available worksheets are shown at the bottom of the worksheet you’re currently working on.
• Double click on the sheet name whose name you wish to change.
• The name by default gets highlighted in grey color that indicates that you can start typing your choice of name.
• Type the name and press anywhere on the workspace area. The name gets automatically changed.
• To change the color of the tab, right click on the sheet name. A menu appears, click on tab color option.
• A color box appears, choose the color you like and the current sheet gets the gradient of it. As soon as you click another sheet, the color becomes distinct.

How to move and copy a worksheet?

While working with a number of sheets, you may want to move worksheets from their original location and place them in some other sequence so as to form a chronological order of data. To learn how to do so follow the following mentioned steps –

• Click on any sheet that you want to move. The cursor gets a little icon of a sheet over it along with a black arrow.
• Simply drag the sheet to the desired sequence and drop it there. The location of sheet will get changed.
• Other way to move sheets is to right click on any sheet.
• A menu appears, click on the option move or copy. Click on it and it opens a dialogue box that contains the book name, the sheet name and create a copy. Fill in the details as accurately and your current sheet will be moved to that location.
• To create a copy of the current sheet, press control key on the keyboard and left click on the sheet you want to create a copy. The action has to be done together.
• Drag the sheet to the desired location and release. A copy of the sheet will be created at that location.

How to create a new window –

While working with a complex data set that contains huge data it isn’t easy to be able to view the entire data on the screen at one time. Scrolling left, right, up and down on the screen will not only kill a lot of time but also result in lesser productivity. To learn how to view huge data on multiple screens on excel, follow the following mentioned steps –

• Go to the view tab and click on new window option. The new window option opens up a second window for the same document that you are working on by the name book 1;
• Now you have two windows open. Go to the option arrange all in the view tab. A option appears, click on arrange vertically
• Both the open worksheets get arranged side by side. Any change made to one workbook will be reflected in the other one as well.

Learn Microsoft Excel Training Singapore!

Microsoft Excel holds great utility be it organizing complex data or performing complex functions on it. Learn how to do all these by trained professionals by joining a Skillsfuture Excel courses in Singapore now!

In this Lesson, you’ll learn how to manage worksheets in Excel. This tutorial will teach you more about working with worksheets.

It covers the following topics:

• Navigating through worksheets in Excel
• Changing worksheet name and color
• Adding/deleting worksheets
• Hiding/Un-hiding worksheets
• Moving/copying worksheets
• Comparing worksheets side by side
• Splitting worksheet into panes
• Freeze panes
• Saving and opening workbooks

This video is a part of Excel Training Singapore where I show you how to use Excel from the basics and also cover a lot of advanced topics.