How to Enable Dark Mode in Google Docs

Dark mode helps to reduce eye strain and saves the battery from draining quickly. 

While it’s easy to switch to dark mode in smartphones, not all desktop applications have this functionality built-in.

This tutorial will explain the methods to switch to dark mode on your smartphone (Android) and desktop web browsers.

3 Ways to Enable Dark Mode in Google Docs

  • Enable Dark Mode on Chrome
  • Enable Dark Mode on FireFox
  • Enable Dark Mode on Android 

Read more

How to count cells with text in Google Sheets

When you’re working on your Google Sheet, you might sometimes have large amounts of data. Some of the data might be missing or mixed with numbers. You may want to count the number of cells with data, a text, or even a specific text. Here’s how you can do that. 

3 methods to count cells with text in Google Sheets

  • Using the COUNTIF function
  • Using the COUNTA function
  • Using the SUMPRODUCT function

Read more

How to convert text to Numbers in Google Sheets

You often need to import data to Google Sheets from various file formats. The data could contain date, time, or currency values. When imported, these values may be stored as texts and make it difficult to use for calculations. However, you can convert them to numbers to make your work easier. 

5 methods to convert Text to Numbers in Google Sheets

  • Using DATEVALUE to convert a date value imported as text 
  • Using TIMEVALUE to convert time values imported as text 
  • Using MONTH to convert from month names to numbers 
  • Using REGEXREPLACE to convert currency imported as text 
  • Using Format Number to convert text to a number in the same cell 

Read more

How to create a text box with rounded corners in Powerpoint

A text box with rounded corners is more attractive than one with regular sharp corners. So, if you want to create a text box with rounded corners in your PowerPoint presentation, you can easily do so. You may be creating a new presentation, where you can add text boxes with rounded corners. You may already have a presentation where the text boxes are with regular sharp corners.

2 ways to create text box with rounded corners in Powerpoint

  • Change existing text boxes to rounded corners
  • Create new text boxes with rounded corners

Let us start.

Read more

How to insert a list of Figues in MS Word

You may have an MS Word document with many figures and tables. For long documents, it is easier for the reader to have a list of contents at the beginning for reference. In the same way, a list of figures at the start of the document helps in locating them easily.

Note: The publishing industry commonly uses the terms list of figures and list of tables. However, MS Word refers to both the terms as a table of figures.

It is easy to create a list of figures or a table of figures. Provided, you have been using Word’s Caption Tool. The tool is for numbering the tables and figures in your document.

You may add or delete a figure or table in your document. The Caption Tool adjusts the numbering. Likewise, it also helps to adjust the list of figures at the start of your document.

We will show you in simple steps how to insert the list of figures. We will also show you how to update it after modifications.

Let us begin.

Read more

How to insert Image in a cell in Google Sheets

You can neatly arrange pictures in your Google Sheet to correspond to cells in a column. 

Say you have the names of some fruits in a column, and you want to insert images of the fruits in the adjacent cells to increase visual appeal. Google Sheets allows you to insert images in cells.  

2 methods to insert an image in Google Sheets

  • Using the Image in Cell option
  • Using the IMAGE function

Read more

How to change column width in Google Sheets

Google Sheets can do the same thing in multiple ways. For instance, you may want to change the width of a column. This could be for a number of reasons such as trying to fit in all the relevant information within a column.

Changing the column width is fairly easy on Google sheets. However, there is more than one way to do it. The method to choose depends on your requirements. In this guide, we break down everything you need to know about changing column width on Google Sheets. 

3 Methods of Altering Column Width: 

  • Manually Widen or Narrow Column Width 
  • Automatically Widen Column Width   
  • Changing the Width of Several Columns Together 

Read more

How to rename a column in Google Sheets

Google sheets allow you to create spreadsheets that can store various types of data. You can use the stored data to perform complex calculations and create visualizations. It can be tiresome to select the range of cells every time you apply a function or perform a calculation. 

Renaming columns enables you to use your column name instead of the range of cells. This eases your work and saves you time. Sometimes, the header is also included by mistake while performing calculations. 

You can avoid this by separating the column names from the rest of the data. Freezing the header or renaming your column will help you achieve this. Also, note that you cannot rename the first row, i.e., the fixed header set by Google Sheets.

3 methods to rename a column in Google Sheets

  • Using the name box
  • Using named ranges
  • Using the Freeze option

Read more