When you want to perform the same task on multiple worksheets in a workbook, you might have grouped them. Ungrouping is as easy as grouping them. If you’re struggling to ungroup the worksheets, you’re at the right place. 

3 Methods of ungrouping worksheets in Excel:

• Click on any unselected sheet
• Keyboard keys and click on the grouped worksheets
• Select Ungroup Sheets

Let us begin.

Read more

If you print a page in Microsoft Word, the content gets centered on the printed page automatically. But that is not the case with Microsoft Excel, as Microsoft Excel, by default, prints from the top-left corner of the page.

Why does Microsoft Excel do this? It is because, like most people, you enter data into the worksheet from cell A1. As a result, Excel replicates that into the printout. However, you can change that printing orientation. This article will discuss three methods of centering worksheets horizontally.

3 Methods of centering your worksheet horizontally in Microsoft Excel:

• Center the worksheet horizontally from the Print menu
• Center the worksheet horizontally using Custom Margins
• Center the worksheet horizontally using the Page Setup launcher tool

Let us begin.

Read more

If you want to create a new worksheet, you don’t have to start afresh. You can duplicate an existing worksheet and make changes to it.

For example, let’s imagine you want to make an invoice. Since it is time-consuming to write the document from scratch, you can instead duplicate an existing invoice and fill the copy with new details. In this article, we will discuss five methods of duplicating worksheets in Excel.

5 Methods of duplicating worksheets in Microsoft Excel:

• Duplicating worksheets within a workbook using the Format option
• Duplicating a worksheet to a different workbook
• Duplicating worksheets by right-clicking the worksheet tab
• Duplicating worksheets using the CTRL key
• Duplicating worksheets using VBA Macros

Let us begin.

Read more

Spreadsheets often contain sensitive data. If you share an unprotected spreadsheet with others, they may alter its contents. Sometimes, people may change the content of worksheets without intending to do so. 

Both these scenarios will have unintended consequences. To prevent unwanted changes to a worksheet, you should be wise enough to lock it. This article will discuss five methods of protecting worksheet data in MS Excel by locking it.

5 Methods of locking worksheets in Microsoft Excel:

• Make the workbook read-only
• Lock the entire workbook
• Protect workbook structure using the Protect Workbook option
• Protect workbook structure using the Review tab
• Lock cells using the Format cells option

Read more

You might find yourself in a situation where you need to count the unique values in an MS Excel spreadsheet. This can be useful, especially when you have tons of data and there’s no way you can count them manually.

6 Methods to count unique values in MS Excel:

• Using the UNIQUE function
• Using the COUNTA function
• Using a pivot table
• Using SUM and COUNTIF function
• Using SUMPRODUCT and COUNTIF function
• Using the Remove Duplicates option

Read more