How to remove duplicates in Google Sheets

Google Sheets offer a couple of methods you can use to remove duplicates in a sheet.

solve this problem. You can either use the Remove duplicates command or the UNIQUE function.

  1. An example of a worksheet that contains unique records

2 Ways to Remove Duplicates in Google Sheets

  • Removing duplicates using the Remove duplicates command
  • Removing duplicates using the UNIQUE function

Let’s get started!

Read more

How to Remove Watermark in Word Document

A watermark is a text or picture that is superimposed over a significantly large section of each page of a document.

It is usually laid over in light gray color so that both the content and the watermark are acceptably visible and readable.

This is sometimes called the “ghost text”.  

We often see the company logo, the company name, or words like “Confidential” or “Draft” laying around in the background of documents.

What if you want to remove the watermark?

In this tutorial, I will discuss two methods for removing watermarks from a word doc.

Read more

How to Add Watermark in MS Word

Simply put, a watermark is a text or image that spans over a significantly large portion of each page of a document.

In this tutorial we will share a couple of methods for adding a watermark to a word document

2 Ways to Add Watermark in MS Word

  • Using predefined watermark 
  • Using custom watermark

Read more

How to change the language in MS Word

The default language of your MS Word depends on the configuration of your computer or device.

Sometimes, you might want to change it to suit your preferred language. MS Word provides different methods on how you can achieve this, depending on your reasons.

Using pre-installed features, you can either change the display or editing language of your MS Word program.

2 Ways to Change the Language in MS Word

  • Changing the Authoring Language
  • Changing the Display Language

MS Word uses two language settings—authoring and display.

Authoring Language: It manages the proofreading options, such as the spelling and grammar of your documents.

Display Language: It pertains to the language of the menus and controls of MS Word.

Let’s get started!

Read more

How to merge table cells in MS Word

Mergagin table cells allow you to join two or more cells into one larger cell.

Here is an example of a table with merged cells.

Word makes it easy to merge cells in a table.

3 Ways to Merge Table Cells in MS Word

  • Using the Layout Tab in the Ribbon
  • Using the Context Menu 
  • Using the Table Eraser Tool 

Important note: Merging cells will combine and delete the data of certain cells. By default, the top-left most cell’s information will be retained and used in the new merged area. Keep this in mind as this may delete the information of some cells without you meaning to do so.

Read more

How to add custom fonts in MS Word

In this tutorial we will share technique to add custom fonts in MS Word

Now, there’s only one way that you can do this but it involves certain complicated steps.

How to Add Custom Fonts in MS Word

  •  Downloading and Installing custom fonts

Let’s get started!

Read more

How to Remove a Hyperlink in MS Word

Sometimes, you might notice that there are clickable links within your documents. These links are commonly known as hyperlinks.

MS Word has an automatic feature that adds hyperlinks to words, especially when you type in or paste URLs.

Yet, there are instances wherein you having these works hyperlinked is unnecessary.

In this article, we’ll guide you through the different methods that you can use to remove hyperlinks.

3 Ways to Remove Hyperlinks in MS Word

  • Using the Right-click + Remove Hyperlink command
  • Using the Keyboard shortcut
  • Using the AutoCorrect dialog box

Let’s get started!

Read more

How to insert a hyperlink in MS Word

Hyperlinks provide an easy way of navigating to different sources or sections in your document. With this feature, you can redirect your readers to an outside source or a certain place within your file. This feature helps you format your document into a more organized and easy-to-navigate form.

3 Ways to Add a Hyperlink in MS Word

  • Using the Link command from the Insert tab
  • Using the Keyboard shortcut
  • Using the Right-click + Link command

Read more