How to Create an Organizational Chart in MS Word

An organizational chart serves as a visual tool to show the reporting relationships within an organization. Such charts are very useful for inducting new employees. They are also good for illustrating managerial functions and the functions of employees in a large organization.

MS Word has easy to use pre-built templates for creating an organizational chart. We will show you how to create organizational charts in simple, easy, step-by-step instructions.

Let us begin.

Read more

How to Ungroup Worksheets in Excel

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

How to Center Worksheets Horizontally in MS Excel

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

How to Duplicate a Worksheet in MS Excel

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

How to Lock a Worksheet in MS Excel

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

How to Count Unique Values in MS Excel

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

How to Create Postcards in MS Word

Postcards are an alternative way to communicate a message attractively. They are fun to make, and creating them in MS Word is easy.

2 ways to create Postcards in MS Word

  • Using templates
  • Using labels

We will show you both methods in simple, step-by-step instructions.

Let us begin.

Read more

How to Enable Dark Mode Microsoft Word

If you work during the day and night, staring at a bright screen in a dark room leads to eyestrain.

The latest versions of MS Word have a remedy for this. You can choose to switch MS Word to a dark mode. The palette will transform into darker colors, reducing eye strain in low ambient light settings.

2 ways to enable MS Word Dark Mode

  • From the Account panes;
  • From the Options dialog box.

In dark mode, you can toggle the background of a document from light to dark or reverse.

We will show you how to switch to a dark mode in MS Word in easy, step-by-step instructions.

Let us begin.

Read more

How to Set Custom Tab Stops in MS Word

In an MS Word document, you can turn on invisible characters. These invisible characters have different purposes. For example, a dot represents a single space. A pilcrow represents a new paragraph, while an arrow represents a tab stop.

A tab stop allows you to start (or end) text at a specified point on your page. You can read more about it in our ‘What are Tab Stops?’ article.

2 ways you can set invisible, custom, tab stops:

  • Using the horizontal ruler.
  • Using the Paragraphs menu.

We will show you in simple, step-by-step instructions how to set custom tab stops using both methods.

Let us begin.

Read more