Trending March 2024 # How To Manage Multiple Worksheets In Excel? – Webnots # Suggested April 2024 # Top 12 Popular

You are reading the article How To Manage Multiple Worksheets In Excel? – Webnots updated in March 2024 on the website Moimoishop.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested April 2024 How To Manage Multiple Worksheets In Excel? – Webnots

Related: How to create data validation in Microsoft Excel?

Working with Multiple Worksheets in Excel

Here are few tips and tricks we think can help you in

Coloring sheets

Hide and unhide sheets

Protect worksheet with password

Quick reference from another sheet

Navigating between sheets

Limit number of sheets

Naming worksheets properly

Copy and move worksheets

1. Coloring Worksheets in Excel

By default, all worksheets in a book have same white background color. When you have multiple worksheets, applying different background colors to sheets can help you to remember the type of content you have on each worksheet. You can also use the sheet colors for various other purposes like keeping all completed task in a green sheet while pending tasks under yellow or red sheet.

Coloring Excel Worksheets

You will see a light background change on the sheet when you working on it. However, when you move to next sheet, you can see the full background color for other sheets. You can remove the applied color by again

Color Sheet When HighlightedColored Sheet When Not Highlighted

2. Hide and Unhide Sheets

hide a sheet.

Use “Control” key to select multiple sheets one by one. Alternatively, use “Shift” key to select multiple sheets as a block and the sheet you want to unhide and show.

Unhide Worksheets in Excel

When you select multiple sheets, Excel will combine them in tab.

Related: How to add and subtract date and time in Excel?

3. Protect Worksheet with Password

When you do not want anyone to change the content on your sheet, the good idea is to protect or lock the content with a password. The person viewing the sheet will not know the restriction unless he or she tries to edit the cell data. Go to “Review” tab and choose “Protect Sheet” option. Excel will show you a pop-up where you can type a password and select the actions user can do with that sheet.

Protect Worksheet with Password

After saving your workbook, if you or anyone try to modify the cell data in a protected cell will be prompted with the below message to enter the password.

Locking Worksheet with Password

Remember not to have sensitive data on your sheet though you protect, someone can simply delete the entire sheet.

4. Quick Reference from Another Sheet

When you lot of numbers, you may do mathematical calculations from cells referenced across sheets. Though you can go and select the cell for referring, the easy way is to use the text reference. Let us say, you have data in cells B2 and B3 of sheet 1. You can use the below formula, if you want to sum up these two cell data and show in a cell of sheet 2.

=Sheet1!B2+Sheet1!B3

5. Navigating Between Sheets

You can remove the pain of navigating across multiple worksheets by using keyboard shortcuts.

Control + PageUp to move in left direction

Control + PageDown move in right direction

6. Limit Number of Sheets

Excel does not restrict the number of sheets in a workbook. It depends on the available memory size on your computer at that point of time. We recommend, you to keep the number of sheets within a limit when working with multiple sheets. Otherwise, you may need to end up in using the small arrows located in lower left corner.  

Moving Between Multiple Sheets

You can still use Control + Page Up/Down keys to navigate to next/previous sheet. Alternatively, you can use the following shortcuts.

sheet.

Note that Excel will remember where you are when closing a workbook. Next time when you open, it will go to the same sheet when you were at the time of closing.

Related: How to use VLOOKUP and HLOOKUP in Excel?

7. Naming Worksheets Properly

Naming Excel Sheets

8. Copy, Move and Delete Multiple Worksheets

You can manage moving, deleting and copying worksheets by to select multiple sheets and delete, move or duplicate them at once.

Move or Copy Worksheet in Excel

Remember, in order to move you should drag and drop the selected sheet(s) in the required position. Excel will show you single or move the selected sheet(s) to the end. When you want to copy or duplicate the entire worksheet, ensure to select “Create a copy” checkbox under “Move or Copy” pop-up.

You're reading How To Manage Multiple Worksheets In Excel? – Webnots

How To Manage Notifications In Android Phone? – Webnots

Things move with the speed of light in this digital world. Notifications in your smartphones help you to keep up to date on the happenings. However, you have to be careful with the screen time to keep the focus on your work and health. Frequently looking at the phone’s screen and picking for unnecessary notifications can easily disturb your focus. That is why it is crucial to managing notifications in smartphones. In our earlier article, we have explained hiding notifications in iPhone and in this article, we will explain various notification features come with the default Android operating system.

Why to Stop Phone Notifications?

You get notifications for almost everything like receiving a message, breaking news from your news app, from your financial apps, etc. Though some information is important to know immediately, most notifications are annoying. Below are some of the examples why you should manage your notifications effectively.

Your phone maybe running out of power and receiving hundreds of notifications can drain the battery.

Some notifications come when it is your rest time. For example, receiving many WhatsApp group chat notifications at nighttime will spoil your sleep.  

Anyone can view the notifications on your lock screen that could affect your privacy.

If you do not control the notification, you may get lost with unnecessary notifications while missing the important ones.

Manage Notifications in Android

Notifications Menu in Android

App Settings – Manage App Notifications

As mentioned, you should disable notifications from most of the games and entertainment apps to avoid distractions. Tap on ‘App settings’ to display the list of the apps installed on your phone.

If you want to turn on or off the notification specifically for that app, move the slider to your desired position. When there are too many apps on your phone, use the search to find the desired app by tapping a search icon up in the corner.

If you want to change notification permissions for the system apps, press the three dots line and press ‘Show system.’ Now, the updated list will display all the apps, including system apps.

App Notification Settings

Once you are done with setting app notifications, press the back arrow to go back to the main ‘Notifications’ menu.

Related: How to manage notifications in Windows computer?

Viewing Notification History

Sometimes is necessary to view all notification history to understand the context.

Tap ‘Notification history’ to open its menu. If “Use notification history” option is off, you can turn it on by touching the button in front of it.

The ‘Notification history’ presents all your recent and snoozed notifications.

Notification History Menu

Managing Conversations

Go back to the main ‘Notifications’ menu and tap on “Conversations” option. This will show you two sections – ‘non-priority conversations’ and ‘Recent conversations.’  Tap the conversation you want to set the priority for. You can set various settings like ‘Lock screen’ and ‘Show notification dot’ etc.

Conversations Menu

It is also possible to delete all your recent conversation history from this section.

Bubble Notifications

The “Bubbles” menu will allow you to either enable or disable floating icons for conversations. If you ‘Allow apps to show bubbles,’ some conversations will appear as floating icons on top of other apps.

Bubbles Menu

Related: How to manage notifications in macOS?

Managing Device and App Notifications

‘Device & app notifications’ menu will give you the option to control which apps and devices can read notifications. Tap it to see the list of ‘Allowed’ and ‘Not allowed’ apps. Find an app in the’ Not allowed’ list and tap on it if you want to grant access to reading notifications. It will display another page where you can enable access to this app. When you give access to read notifications, the app will read all notifications, including personal information such as contact names and text messages you receive. The app can dismiss the notifications, act on buttons, answer calls, and turn on or off the ‘Do Not Disturb.’ So, give such access carefully.

Similarly, if you want to take back the access to read notifications from an app, find it in the ‘Allowed’ list. Tap it and turn the access off.

Device and App Notifications

Notifications on Lock Screen

This menu lets you choose from the following three options.

‘Show conversations, default, and silent.’

‘Hide silent conversations and notifications.

Don’t show any notifications.

You can only choose one from the above list.

Managing Sensitive Notifications

This is a critical setting from privacy perspective. If you turn it on, your Android phone will display sensitive content when locked. It means, as soon as you receive the message, it will display on the mobile phone screen even if it is locked. This can affect your privacy and security when you left the phone on the table for a while. Anybody can get a glimpse of the messages because they will display on the screen for a moment.

Do Not Disturb Mode

It is an essential menu to get notified only by your favorite people and apps. Turn it on by tapping on the blue button with the label ‘Turn on now.’

‘People’ menu will let you choose the list of people who can interrupt in do not mode. Go to this menu and tap ‘Conversations’ to display a page with three radio buttons.

All conversation: There is a ‘settings’ button in front of it. You can check the settings as well.

Priority conversations: You can select it if you want. Settings buttons allow you to change the settings.

None: Choose it if you don’t want any conversation to interrupt you.

‘Calls’ menu lets you choose who can make calls and interrupt. There are the following options.

Starred contacts: You can let contacts that have been starred in the contact list interrupt you.

Contacts: You can allow all the contacts stored in your phone to interrupt you.

Anyone: You can allow everybody to call you and interrupt. It includes even the callers who are into your phone contact number.

None: It means no one can make a call or interrupt.

Allow repeat callers: It is a switch that you can turn on or off. If you turn it on, the person who calls you within 15 minutes of the first call can make you a second call.

‘Messages’ menu controls who can interrupt with messages. Its settings are the same as the options given for the ‘Calls.’

Do Not Disturb in Android

Go back to the main ‘Do Not Disturb’ menu.

You have ‘Apps’ and ‘Alarm & other interruptions’ menus assist to set the apps and alarms which can interrupt. Tap it, and the next page will display the slide button to turn on or off the corresponding interruptions.

The ‘Schedules’ menu keeps track of your activities like set your ‘Sleeping’ schedule. You can go to settings and write the days, start time, and end times, etc. You can also do that for ‘Event’ or ‘Driving’ and add more events of your own if required.

‘Duration for Quick Settings’ is a quick menu to apply the setting only for a specific time. You can set it to ‘Until you turn off’ or set the number of hours. You have the option of ‘Ask every time.’

The last option in the list is ‘Display options for hidden notifications.’ This menu displays the following options with a radio button.

No sound from notifications: You will see a notification on your screen.

No visuals or sound from notifications: You won’t see or hear notifications.

Custom: You can set your own preferences by hitting the settings button.

Below are few other settings that you can use:

Final Words

As you can see, notifications in Android phone has large number of customizations to setup based on your need. We recommend using these settings to mute unnecessary apps and distractions. In addition, you can use the timely settings like do not disturb or duration for quick settings to make the most out when needed.  

How To Manage Tasks In Microsoft Outlook? – Webnots

Most of us use Microsoft Outlook for sending emails and calendar meetings/appointments. However, you can also use Outlook for creating tasks and follow up the progress till completion. It is also possible to assign or delegate the tasks to your colleagues and team members. In this article, we will explain how to manage tasks in Microsoft Outlook.

Related: How to fix slow Outlook and speed up your email productivity?

How to Manage Tasks in Microsoft Outlook?

We will cover the following sections in this article:

Creating new task

Converting email to a task

Editing task

Delegating or assigning task

How to Create Tasks in Microsoft Outlook?

Follow the instructions to create a new task.

Outlook will show the mail, calendar and tasks icons on the bottom of the right sidebar. This may vary the three dots button on the bottom of the sidebar navigation and select “Tasks” option.

Open Tasks in Outlook

Alternatively, you can use the search box in Outlook 2024 onwards to find Tasks view for you. Once you are in Tasks view, Outlook will have different menu items in the ribbon.

By default, you can view all your existing tasks and to-do list in tasks view. The to-do list displays all to create a new task.

Creating New Tasks in Outlook

Enter the subject for your new task that Outlook will display in the task list.

Defining Due Date, Status and Priority

In contrast to an appointment, editing a task is not tied to a fixed time and duration. You can, however define a due date for tasks. You can also create tasks without a firm due date.

date” fields. Setup the dates for your task as per your need. You can also enter date descriptions such as Today, Tomorrow or Day after tomorrow in the start and due date fields. Outlook automatically converts these into the far work on the task has progressed.

You can use the “Priority” field to define how important or urgent a task is. By default, the priority of a task is defined as “Normal” in Outlook.

In the “% Complete” field, you can enter the percentage of task completion if required.

If you like, you can have Outlook remind you to complete a task.

In the text area, you can enter additional information on the task or insert elements, which are related to the task.

Related: How to improve productivity when using Outlook?

Setting Up Recurrence Task

If a series of recurring tasks is involved, such as a task to be completed on a weekly basis, enable the “Recurrence” button on the ribbon. You can then define the recurrence pattern.

Setting Task Recurrence in Outlook

Viewing Created Tasks

Now that you have filled out the task details, save and close the task. You can view the new task in the task list with the appropriate due date.

View Created Task

Converting Email to Task

Creating your own new tasks is very easy. However, you may need to convert an email received into a task from time to time. Here is how to convert a received mail into a task.

Switch to email view in Outlook.

You have several options for including an email in your task list. For one email, you have the option of flagging an email for follow up. Such emails are displayed in the to-do task list, but remain email date from “Follow Up” menu.

Follow Up Email

You can also convert an email entirely into a task. Use the “Move” button and select “Tasks” folder to do this.

Moving an Email to Tasks

You now see the new task window with the task subject as same as email subject. Outlook also attach the original email into the text

Convert Email to Task

You have all the options available as you do when creating a new task. After filling out the details, save the task and then switch back to the “Task” view to see the new task in the task list. Remember, Outlook will remove the email from the Inbox folder.

Email Moved to Tasks

Related: How to insert emoji symbols in Outlook using keyboard shortcuts?

Editing Tasks

You can edit any of your tasks after creation. In order to edit, first select a task.

Editing Tasks in Outlook

Delegating Tasks

In Outlook you are also able to delegate tasks to other persons. You can assign new or existing tasks to other people. If you want to assign a task to another person you just have to choose the person from your contacts or enter the email address of the recipient.

Task” button to delegate to another person.

When you have an already created task on your to-do task in the ribbon.

Use the address field in this dialogue window to select the person who is to perform the task.

Delegating or Assigning a Task in Outlook

Also by default, a copy of the task remains in your to-do list for information. Disable this field if the delegated task is no longer to appear in your to-do list.

By default, you will receive a notification when the assigned task has been completed. You can also disable this notification.

After checking the details, send the task to the designated person.

Accepting or Rejecting Delegated Tasks

The icon in front of the task tells you that the task has been assigned to another person. The recipient now has the option of accepting or rejecting the task.

Accept or Reject Assigned Task

Outlook will notify you about the accepted or rejected status. Also you will get information of the progress in completing the task as soon as the recipient of the task enters relevant information.

Check Status of Assigned Tasks

Viewing All Assigned Tasks

can only view the tasks that you have assigned to other people.

View Delegated Tasks in Outlook

You can view the status of the delegated tasks as a separate column in the “Detailed” and “Assigned” views. In the “Active”, “Next 7 Days” and “Overdue” views, there are separate columns for status and progress. You will also find all relevant information in the header of the task window when you open a task.

How To Do Multiple Level Data Sorting In Excel

In this tutorial, I cover how to do a multi-level sorting in Excel. You can watch the video below, or you can read the tutorial below it.

When working with data in Excel, sorting the data is one of the common things you might have to do.

In most of the cases, you need to sort a single column.

But in some cases, there may be a need to sort two columns or more than two columns.

For example, in the below dataset, I want to sort the data by the Region column and then by the Sales Column. This will allow me to see which sales rep has done well in which regions.

While it’s straightforward to sort data by one column in Excel, when it comes to sorting by two columns, you need to take a couple of additional steps.

In this tutorial, I will show you two ways to do a multiple level data sorting in Excel (i.e., sort by two columns)

When you sort data using the sort dialog box, you get an option to add multiple levels to it.

Here are the steps to do  multi-level sorting using the dialog box:

Select the entire data set that you want to sort.

In the Sort Dialogue box, make the following selections

Sort by (Column):

Region

(this is the first level of sorting)

Sort On:

Values

Order:

A to Z

 If your data has headers, ensure that ‘My data has headers’ option is checked.

In the second level of sorting, make the following selections:

Then by (Column):

Sales

Sort On:

Values

Order:

Largest to Smallest

The above steps would give you the result as shown below. This sorts the data first by Region and then by Sales column. Note that since it sorts the Region column first when the Sales column is sorted, the Region column remains unchanged.

In this example, I have sorted the data for two columns. You can have more than two-column sorting as well. All you need to do is add these sorting levels and specify the details.

Note: While this method is longer and takes a few more steps (as compared with the multi-sorting method covered next), I recommend using this as it is less confusing.

Not many people know this way of doing a multiple level data sorting in Excel.

This technique works the same way with a minor difference – you sort the second level first and then move to the first level sorting column.

Here are the steps to do it:

Select the column that you want to be sorted last (in this case, select the Sales data first – C1:C13).

The above step would make a Sort Warning dialog box pop-up. Make sure ‘Expand the selection’ is selected. This makes sure the entire dataset is sorted, and not just data in the Sales column.

Select the Region column.

In the Sort Warning dialog box pop-up, make sure ‘Expand the selection’ is selected.

The above steps would sort the data just like it did in the first method.

While this method works fine, I recommend using the sort dialog bo method.

Sort dialog box makes it less error-prone (as you can see which levels getting sorted in which order).

Also, there are more ways to sort data with the dialog box. For example, you can sort a column based on the cell/font color and you can also use your own custom sorting criteria.

You May Also Like the Following Excel Tutorials:

How To Match Data In Excel

How to Match Data in Excel (Table of Contents)

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Introduction to Match Data in Excel

Microsoft Excel offers various options to match and compare data, but we usually compare only one column in most scenarios. Comparing the data for one or more or multiple columns, various options are available based on the data structure. It’s the most frequent task use in comparative data analysis on tabular row or column data.

Definition of Match Data in Excel

It’s a process to find out or spot a difference between datasets of two or more columns or rows in a table. It can be done by various procedures, depending on the dataset structure type.

Examples of How to Match Data in Excel

Let’s check out the various available option to compare data sets between two rows or columns in Excel & to spot a difference between them.

You can download this How to Match Data Excel Template here – How to Match Data Excel Template

Example #1

How to Compare or Match Data in the Same Row

In the below-mentioned example, I have two columns, i.e., List 1 & 2, which contains the list of student names; now, I have to compare & match a dataset in these two columns row by row.

To check whether the name in List 1 is similar to list 2. There are various options available to carry out.

Method 1 – I can apply the below-mentioned formula in a separate column to check out the row data one by one, i.e., =A3=B3; it is applied to all the other cell ranges.

If there is a data match, it returns a value “True”; otherwise, it will return a “False” value.

Method 2 – To Compare data by using IF logical formula or test

If logical formula gives a better descriptive output, it compares case-sensitive data.

i.e., =IF (A3=B3, “MATCH”, “MISMATCH”)

Suppose the logical test is case-sensitive. It will help out whether the cells within a row contain the same content. I.e., Suppose the name is “John” in one row & “John” in the other row; it will consider it as different & result in Mismatch or a false value.

Here is the result mention below.

Method 3 – To Compare data with the help of Conditional Formatting

Here, suppose I want to highlight the matching data between two rows with some color, say, Green, otherwise no color for data mismatch; then, to perform this, Conditional Formatting is used with a set of certain criterion

To perform conditional formatting, I must select the entire tabular data set.

Go to the Home tab, under the style option, and select a Conditional Formatting option.

Various options under the conditional formatting appear in that select New Rule.

Now, it will highlight all the matching data with green color and no color for the data, which is a mismatch between rows.

You can use the above three methods to compare and match numeric data, date, or time values. The same process can use to compare multiple column data matches in the same row.

Example #2

How to Compare or Match Data between Columns & Highlighting the Difference in the Data

In some cases, the dataset matches may be in different rows (It is not present in the same row); in these scenarios, we have to compare two columns & match the data.

In the below-mentioned example, student list 1 in column B is slightly bigger than student list 2 in column C. and. Also, a few names are there in both student lists, but it is not present in the same row (such as John, Mark, and Edward).

Data match or comparison between two columns can be made through a duplicate option under conditional formatting.

To perform conditional formatting, I must select the entire tabular data set.

In the Home tab, select a Conditional Formatting option under the style option.

Various options under the conditional formatting appear; under the Highlight Cells Rules, you have to select the Duplicate Values.

Once the duplicate values are selected, a popup message appears, where you need to select the color of your choice to highlight the duplicate values; here, I have selected Light Red Fill with Dark Red Text.

After selecting, you can observe that common students present in both columns are highlighted with red color (along with dark red text), while the unique values are not colored.

Note: In Conditional Formatting duplicate values option is not case-sensitive; where it considers the upper or lower case as similar records, it will not highlight them as duplicates.

Example #3

Highlighting the Row Difference with the help of the “Go to Special” Feature

Compared to other methods, with the help of this option, we can perform the task faster. It can also use for multiple columns.

It will highlight the cells with different datasets; now, you can color it green to track a difference in the dataset between rows.

Things to Remember about the Data Match in Excel

Apart from the above methods, various third-party add-on tools perform the textual data match in Excel.

Fuzzy Lookup Add-In tool for Excel

It is most commonly used to match and compare a customer’s name & address data. It will help track the difference in the data table within a selected row. It will also help find various errors, including abbreviations, synonyms, spelling mistakes, and missing or added data.

Recommended Articles

This is a guide on How to Match Data in Excel. Here we discuss How to Match Data in Excel using different methods, Different Examples, and a downloadable Excel template. You may also look at the following articles to learn more –

How To Quickly Close Multiple Tabs In Browser

This will close all the tabs at the right of the current tab. Alternatively, you can also select the option “Close other tabs” which will then close all tabs except for the current one.

Note: The “Close tabs to the right” feature is only available in Firefox 24.0 and above. It is not available for Safari though.

Damien

Damien Oh started writing tech articles since 2007 and has over 10 years of experience in the tech industry. He is proficient in Windows, Linux, Mac, Android and iOS, and worked as a part time WordPress Developer. He is currently the owner and Editor-in-Chief of Make Tech Easier.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

Update the detailed information about How To Manage Multiple Worksheets In Excel? – Webnots on the Moimoishop.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!