How to Highlight Text in Google Sheets

Google Sheets allows you to create spreadsheets. In spreadsheets, you can store different types of data, including words, numbers and currencies. 

You might only want to highlight a portion of the text in a particular cell. For example, in the image below, the word ‘Urgent’ is highlighted in red. This allows you to emphasize the text. You can also change the formatting of the text in other ways. For instance, you can italicize it or make it bold. The one thing you cannot do is change the background color of only a portion of the text. You will have to change the background color of the entire cell.

You can also highlight text by changing the background color of the cells containing any text. Doing this allows you to distinguish between cells that are empty and cells that have text. Google Sheets allows you to do this as well. 

3 methods of highlighting text in Google Sheets:

  • Using the text box at the top to highlight portions of a text
  • Double-clicking on a cell to highlight portions of a text
  • Using conditional formatting to highlight only cells with text 

Read more

How to insert a Watermark in Google Docs

A watermark is a design that is meant to identify the owner or maker of a document. It is inserted on every page of the document. To make sure that you can read the text in the document, the watermark is transparent. 

You can share the watermarked document with other people. The people you share it with cannot claim that the document is theirs, because of the watermark. Hence, watermarking prevents other people from copying your work. 

Watermarks can also be used on images. For example, the photos on the iStock website are watermarked. This prevents people from downloading the images without paying. 

Google Docs doesn’t have an option that allows you to automatically insert watermarks. However, there are several workarounds that you can use.

2 methods of inserting a watermark in Google Docs: 

  • Inserting a watermark from the Drawing window
  • Inserting a watermark in the header or footer of your document 

Read more

How to extract images from Powerpoint

You may have a PowerPoint presentation with many images. You plan to use some or all the images in another presentation.

2 methods to extract Images from PowerPoint:

  • Extract images one at a time.
  • Extract all the images at a time.

The first option is useful if you have to handle only a few images. If the number of images is high, the second option is a better choice.

We will show you both options. Use these options according to your requirements.

Read more

How to Insert Degree Symbol In Google Docs

Google Docs allows you to insert a variety of symbols in your document. One such symbol is the degree symbol. The degree symbol is used for showing degrees of temperature, hours, arc and more. If you are a math or science student, you will probably be using the degree symbol a lot.

It is easy to insert a degree symbol in Google Docs. There are several methods you can use to do this. In this article, we will be discussing the following.

3 methods of inserting a degree symbol in Google Docs: 

  • Using a keyboard shortcut for the degree symbol
  • Inserting the degree symbol using the special character’s option in the ‘Insert’ menu
  • Automatically inserting a degree symbol by changing your Google Docs preferences

Read more

How to insert em dash in Google Docs

An em dash is a very commonly used punctuation mark. It looks similar to a hyphen, which is why many people confuse it with a hyphen. However, they are both different. A hyphen is shorter than an em dash and is used for connecting words. Some examples of words connected by a hyphen include: bird-watching, high-rise, and life-size. 

On the other hand, an em dash is generally used like a comma. You can use it to add an additional piece of information and for emphasis. Take this sentence as an example: Google Docs – one of the most popular word processing applications – is really useful for students. In this sentence, we used em dashes to provide additional information about Google Docs. 

There are several ways of creating an em dash in Google Docs.

3 methods to insert Em Dash on Google Docs: 

  • Using a keyboard shortcut to create the em dash
  • Using the special character’s option in the ‘Insert’ menu
  • Changing the dash preferences in Google Docs

Note that this article is intended for complete beginners. So, you can follow along even if you have very little to no experience with Google Docs.

With that introduction, let’s learn the 3 methods. 

Read more

How to Use an Image as a Background In PowerPoint

PowerPoint offers a large collection of background images and patterns. You can select from them and insert one in your presentation.

However, if for some reason, you would like to use a different image as a background, you can easily do so. You may use any image you have downloaded in your PC or an image from the Internet.

You must be careful when selecting the image to insert. PowerPoint stretches the image to fill the slide.

Therefore, use an image with a proper aspect ratio to avoid distortions. Also, use an image with a high enough definition, as the details will stand out better.

Let us start.

Read more

How to Rotate a Table in Word

Using tables help make your document look more professional and visually appealing. It makes your text and numbers look neat and well-organized within the main content. Some tables are best presented in a different orientation, especially when it contains a lot of columns.

However, MS Word doesn’t give you a straightforward way to accomplish the task.

Fortunately, we found more than one clever way to get the job done! 

Now, there are about three ways to rotate a table in Word. 

3 Ways to Rotate a Table in Word

  • Using the Text Direction button
  • Using a textbox
  • By converting your table into an image

Without any delay, let’s get right to it! 

Read more