How to sum a column in Google Sheets

Google sheet allows you to use many functions on a data set. Functions are convenient mathematical operations that can convert raw data into usable information. One such function is the SUM function, which lets you sum up numeric data in a column.

Formula for the SUM Function

The SUM Function totals the values of specific cells, a particular row or column. To use the SUM function, you may use the following formula:

= SUM(A1: A5): Sums cells A1 through A5

OR

=SUM(A1, A5): Sums cells A1 and A5

Here are a few things you should remember while using the SUM function:

1. The word SUM denotes the function name. The bracket () encapsulates the cells in a row or a column that contain the numeric data.

2. The cell reference before the ‘:’ denotes the cell from which the summation begins.

3. ‘:’ allows you to input a range of adjacent cells, and ‘,’ allows you to input non-consecutive cells.  

4. The cell after the semicolon denotes the cell where the summation ends.

3 ways to sum a column in Google Sheets

  • Method 1: Manually type the formula in the cell
  • Method 2: Using the Insert Function Option
  • Method 3: SUM a Column on a Cellular Device

Read more

How to make a table smaller in Google Docs

A table is a vital component of Google Docs core functions. It helps to display information concisely, something that paragraphs cannot replicate.

In this tutorial, we’ll see an easy method to resize your Google Docs table. 

First, I’ll illustrate the procedure to make the complete table smaller than the default view. Afterward, we’ll see the effect of this process on some individual cells.

The process includes selecting the cells and then tinkering with Column width and Minimum row height inside Table properties

Let’s do it step-by-step. 


Read more

How to create a text box with rounded corners in MS Word

Text boxes within a document in MS Word can help to point out important points. With a text box, you can draw the attention of your readers. Place the important information inside the text box. This gives you the freedom to orient it any way you want. You can also change several aspects of the box and the text inside the box.

By default, when you insert a text box, MS Word adds a rectangular box with sharp corners. If you do not like this, use a box with rounded corners. You may already have a rectangular text box in your document. Word has the tools to change it to one with rounded corners.

2 ways to create a text box with rounded corners

  • Start with a predefined rounded corner text box
  • Change a rectangular text box to one with rounded corners

Our simple, step-wise instructions will cover both.

Let us begin.

Read more

How to make a transparent text box in MS Word

You can emphasize certain text in your document by enclosing them in text boxes. Creating headlines becomes easier with text boxes. It is possible to add a text box anywhere in the document. You can insert text boxes at any angle, font color, background color, and orientation. You can even use various fonts in a text box.

When inserting a text box, Word uses a white background by default. This background is opaque and hides anything behind it. You can change the background of the text box and make it transparent.

2 ways to make transparent text box in MS Word:

  • By changing the Shape Fill
  • By modifying the Format Shape

Here, we will show you both methods of how to make the text box transparent in simple steps. 

Let’s begin.

Read more

How to have different headers on each page in Google Docs

The header is the first thing we see in a document.

Most of the time, having a single header is adequate for the entire document.

But, what will you do if you want to have a unique header for each page?

This short article will discuss one surefire way to solve this issue for any google docs file.

In a nutshell, this process includes putting section breaks on each page and then changing headers on each one of them.

Let’s jump into it to look at the details.

Read more

How to Merge Cells in a Google Docs Table

Google Docs is an all-powerful alternative to the expensive Microsoft Office. It’s getting feature-rich by the day. It empowers us to do a lot of things. And, one of them is putting a table in our documents. 

In this simple tutorial, I’ll show you how to merge different cells in a Google Docs table.

Let’s do it step-by-step.

Read more

How to remove the border from text box in MS Word

You can insert a text box at any point in your document. Text boxes are a great way to create headlines. You can also use them to make certain text stand out. It is possible to insert them in any angle, color, orientation, and in different fonts.

When inserting a text box, Word places a border around it by default. You can customize the border to show a thick or thin line, continuous or dotted line, and in select colors. But in some cases, you may not want a border at all.

2 ways to remove the border from the text box in MS Word:

  • By modifying the Outline
  • By changing the Format Shape

Here, we will show you both methods of how to remove the border from a text box in simple steps. 

Let us begin.


Read more

How to lock a text box in MS Word

You may have an enclosed text box within the content in your MS Word document. By default, the text box moves with the content. If you do not want it to move with the content, you must lock the text box.

If you are sharing your document with others, you may not want them to change the content within the text box. Again, you can lock the text box.

Word allows you to lock the text box for the above cases. Thus, by locking the text box, you can:

  • Prevent the text box from moving with the content.
  • Protect the contents of the text box.

We will explain both methods stepwise. Let us start.

Read more

How to remove table lines in MS Word

When creating a new table in MS Word, you can specify the number of rows and columns that the table must contain. But the table that appears has internal and external lines or borders. Borders make it easy to enter data in the cells. But you may want to print or display the table without some or any border showing up.

Word has many options that allow customizing the appearance of your table. You can change the styling of the borders. One of the styles includes suppressing the display of borders.

Removing the table borders or lines in MS Word does not disturb the data or the layout of the data. You only remove the lines that identify the rows and columns.

2 ways to remove table lines in MS Word

  • Using the Borders Menu
  • Using the Borders and Shading Dialog Box

We will show you in steps how to remove the table lines in your MS Word document.

Let us begin.

Read more