How to rename a column in Google Sheets

by

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

How to sum a column in Google Sheets

by

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

by

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

by

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

by

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

by

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 remove the border from text box in MS Word

by

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