How to add outline in Google Docs

by

An outline is an important part of any professional document. Without an outline, everything looks muddled, and the vital parts lose significance. 

In addition, a document without an outline is hard to follow and lacks readability. Finally, an outline also serves as a table of contents with anchor links to jump to a specific section of a document.

So, in this tutorial, we’ll see the easiest procedure to convert an untidy document into a formal one by adding an outline. 

Without any ado, let’s begin.

Read more

How to create a Simple drop-down list in Google Sheets

by

Google Sheets is a collaborative tool. Its collaborative nature can lead to incorrect data entry and discrepancies when multiple users use the same sheet. Drop-down lists help people enter correct data from set options. This helps to maintain the integrity of the sheet. It also helps save time by making the data entry process quick. 

Creating and Modifying drop-down lists on Google Sheets

  • Creating a drop-down list using data validation
  • Modifying a drop-down list using data validation
  • Removing data validation 

Read more

How to password protect a Google Sheet

by

Google Sheets don’t have a built-in password-protection feature. However, it allows you to set permissions for each member that has access to your sheet. 

Therefore, the only built-in feature to protect your sheets is by restricting access through the share settings. Members can access documents over the internet, but only those with edit access can make changes. That said, you cannot give a member edit access and hide some of the information on the sheet from that member. 

If you want to encrypt data and password protect your sheet, you can use a third-party app. Alternatively, if you want to hide a specific sheet, you can do that as well.

Methods to protect your Google Sheet

  • Using a third-party tool
  • Controlling access via share permissions and settings by:
  1. Hiding your individual sheet
  2. Hiding your individual cells

Read more

How to copy a sheet in Google Sheets

by

When you’re working on Google Sheets, you might sometimes need to make a copy of your sheet. You might want to copy the sheet into an existing sheet, a new sheet, or even to your current sheet. Google Sheets allows you to copy a sheet easily. 

4 methods to copy a sheet in Google Sheets

  • Using the Duplicate option
  • Using the Existing spreadsheet option
  • Using the New spreadsheet option
  • Using the Make a copy option

Read more

How to encircle a word in Google Docs

by

There are plenty of methods to highlight a special word in your G-docs file. You can use text color, highlight it, italicize, etc.

But the most effective way to make some very important words–like your brand name–stand out is to put a shape around it. 

This tutorial will share a simple method to put a circle (or any regular shape) around any word in Google docs. 

In short, this includes using drawing tools to select the shape and type your special word in it.

Let’s begin.

Read more

How to insert Multiple rows in Google Sheets

by

Sometimes you might need to add an extra row between two others in your spreadsheets. In Google Sheets, you can do it by right-clicking the row and selecting the Insert Row option found in the menu.

In some cases, however, one extra row may not be enough. You’ll need to add multiple rows to enter your data. Google Sheets has met this requirement too with many options to add multiple rows. 

5 Method To Add Multiple Rows

There are many simple methods to accomplish adding as many rows as you want. 

  • Using the Insert Rows option
  • Using keyboard shortcuts
  • Using the Add button at the bottom
  • Using F4
  • Using Macros

Read more

How to group and Ungroup Columns In Google Sheets

by

Sometimes your Google Sheet might contain a lot of information. You may want to group some columns and hide the information in them to make the sheet look sharp and tidy. This is when you can use grouping. 

Grouping columns helps you organize, summarize, and format data neatly. Say you have data about a group of people. You only need the favorite color of each person. Other details about that person are not needed right now. So you group columns B and C in the image below to hide data.

If you want to change or view more details about the person, click the plus sign on top of the column. Now, you can view the other columns as well. 

Grouping and ungrouping columns in Google Sheets

  • Grouping columns in Google Sheets
  • Collapsing and expanding columns
  • Multilayered grouping of columns
  • Ungrouping columns in Google Sheets

Read more