How to change column width in Google Sheets

by

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 apply a formula to entire 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. 

To perform complex calculations, we use formulas. Usually, you would want to apply the formula to more than one row. If there are a lot of rows, it can be a cumbersome process.

This article will give you an insight into the different ways you can apply a formula to an entire column.

5 methods to apply a formula to an entire column

  • Using the Autofill suggestion
  • By dragging the cell’s handle
  • Using the shortcut Ctrl + D
  • Using Ctrl + Shift + Down Arrow”
  • Using Array Formula

Read more

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