How To Add Underline Format in Google Sheets? – Underline Cells, Rows, Text in Spreadsheet

The underline formatting option in Google Sheets is one of the most important formatting features that make users read the dataset without any difficulty. In Google Sheets, the underline formatting option is mostly used to highlight important terms in a dataset.

Google Sheets allows users to underline an entire row or even a portion of the text in a specific row. We can use the format options or keyboard shortcuts to underline any given dataset in the spreadsheet. In this article, we will look at various ways to underline a dataset on a spreadsheet using Google Sheets Tips. Continue reading to learn more.

Table of Contents

Keyboard Shortcut To Underline Text In Google Sheets

Keyboard shortcuts are one of the best options if we want to underline a text in Google Sheets. The steps to underline a text using a keyboard shortcut are given below:

  • 1st Step: Open the Google Spreadsheet.
  • 2nd Step: Now select the text that needs to be underlined.
  • 3rd Step: Use the keyboard shortcut “Cntrl+U“.

underline format in google sheets

That’s it. This action enables the required dataset to have the underline formatting.

We can also underline the entire row in the given dataset by selecting it and by pressing the keyboard shortcut key “Cntrl+U“.

Underline Format in Google Sheets Shortcut Key – Cntrl+U

How to Underline Rows in Google Sheets using the Format Option?

Apart from underlining the text using the keyboard shortcut, one can also underline the rows in the spreadsheet using the Format option. The steps to underline using the formatting option are given below.

  • 1st Step: Open the Google Spreadsheet.
  • 2nd Step: Select the row which needs to be converted into the underline format.
  • 3rd Step: Now on the homepage, click on the “Format” tab.
  • 4th Step: Choose “Text” from the drop-down menu.
  • 5th Step: Now from the Text sub-drop down menu, choose the “Underline” option.

underline format in google sheets

That’s it. This step also enables the underline format for the multiple rows on the spreadsheet. if multiple rows are selected.

How to Underline Cells in Google Sheets?

Google Sheets allows users to underline a range of cells simply by using the Format tab or by using keyboard shortcuts. The steps to underline the range of cells in the spreadsheet are given below:

  • 1st Step: Launch the spreadsheet where you need to perform underline formatting.
  • 2nd Step: Select the range of cells that need to be underlined.
  • 3rd Step: Click on the “Format” tab and choose “Text” from the drop-down menu.
  • 4th Step: From the “Text” sub-drop down menu, choose “Underline“.

underline format in google sheets

This underlines the range of cells selected. Alternatively, you can select the range of cells and press “CNTRL+U” on your device to underline the text.

How to Underline Particular Text in Google Sheets?

We can also underline particular text in Google Sheets. The steps to get this done are outlined below.

  • 1st Step: Open the Google Spreadsheet.
  • 2nd Step: Now choose the text that needs to be underlined in the spreadsheet.
  • 3rd Step: Press “Cntrl+U” on your keyboard. Alternatively, you can also follow the Format option to underline the text in Google Sheets.

underline format in google sheets

Following the above steps enables an underline format for specific text.

How to Remove or Undo Underline Formatting in Google Sheets?

We can easily remove or undo the underline formatting in Google Sheets by either using the “Format” option or a keyboard shortcut. The detailed steps for removing underline formatting from links or text in the spreadsheet are given below:

Method 1: Remove Underline Format Using Keyboard Shortcuts

  • 1st Step: Select the text or cell range where the underline format needs to be removed.
  • 2nd Step: Press “CNTRL+U” on your device.

This removes the underline formatting in Google Sheets.

Method 2: Using The Format Option To Remove The Underline Format

  • 1st Step: Open the Google Spreadsheet.
  • 2nd Step: Select the text or cell range from which the underline format needs to be removed.
  • 3rd Step: Click on the “Format” option and choose “Text” from the drop-down menu.
  • 4th Step: Now from the text sub-drop down menu, choose “Underline“. This removes the underline formatting in the spreadsheet.

underline format in google sheets

Simple formatting techniques like underlining make our data a lot easier to read and understand. With the help of the various methods provided above, start formatting your data by adding and removing the underline format to your dataset.

How To Change Font Size in Google Sheets – Shortcut Key To Increase/Decrease Font Size

Font size in Google Sheets plays a major role when it comes to reading the dataset. By default, Google Sheets comes with a font size of 11 px. However, this font size does not go well with all the spreadsheet users. Thus, Google Sheets allows users to change the default font size and fonts based on the spreadsheet user’s requirements.

So, if you are a user who is looking to change the font size in Google Sheets, then this page is for you. This page outlines various methods through which we can increase or decrease font size in the spreadsheet using Google Sheets Tips. Scroll down to find out more.

Table of Contents

Can You Change the Default Font Size in Google Sheets?

Yes, we can easily change the default font size in Google Sheets. There are various methods with the help of which we can change the font size in Google Sheets. Let us discuss the following 3 easy methods with the help of which we can change the font size.

Sheets Tips

What Is the Shortcut Key to Increase Font Size in Google Sheets?

We can easily increase or decrease the font size in Google Sheets using keyboard shortcuts.

  • To increase the font size in Google Sheets, press Ctrl + Shift + .
  • To reduce the font size in Google Sheets, press Ctrl + Shift + ,

Open the spreadsheet and perform the above actions, and you will see the changes in font size.

How to Change Font Size in Google Sheets Using the Menubar?

Follow the steps as outlined below to change the font size in Google Sheets using the menubar:

  • 1st Step: Launch the Google spreadsheet on your device.
  • 2nd Step: Select the dataset for which you want to change the font size.
  • 3rd Step: On the menubar, click on the font size drop down.
  • 4th Step: Choose the font size from the drop-down menu.

How To Change Font Size in Google Sheets

Now you will see the size of the font changing based on the choice made.

Pro Tip: To change the entire sheet font size, select the entire sheet by placing your cursor on the grey line and start changing the font size from the menubar.

How To Change Font Size in Google Sheets

How To Change Font Size in Google Sheets using Format Option?

Google Sheets allows the user to change the font size using the format option. The steps to change the font size using the format option in the spreadsheet are given below:

  • 1st Step: Launch the Google Spreadsheet on your device and select the dataset for which the size of the font needs to be changed.
  • 2nd Step: Click on the Format option from the drop-down menu.
  • 3rd Step: Choose the font size from the drop-down menu.
  • 4th Step: Now select the font size as per your requirements and you will see the font is being changed.

How To Change Font Size in Google Sheets

Changing font size plays a major role in making the dataset readable. With the help of the above methods listed, one can choose the easiest method and change the font size of the dataset.

How to Make a Line Chart in Google Sheets: Setup/Edit/Customize Line Graph

Google Sheets Line Graph is one of the useful features which helps us to understand any dataset’s analysis within a fraction of seconds. Most people rely on line charts when it comes to store and review the informational changes from time to time. Any individual can easily create a Google Sheets Line chart within few clicks. However, if you have no idea about how to make a line chart in Google Sheets, then this article is for you. On this page, we have provided step by step procedure for making a line graph with Google Sheet tips. Read on to find more.

Table of Contents

  1. Google Line Chart Parameters
  2. Types of Line Chart in Google Sheet
  3. How to Make a Line Graph in Google Sheets with Multiple Lines?
  4. Setting Up Line Chart in Google Sheets
  5. Customizing the Line Graph in Google Sheets
  6. Editing Line Graph in Google Sheets

Google Line Chart Parameters

The important parameters of the line graph in Google Sheets are explained below:

  1. The Y-Axis (vertical axis)
  2. The X-Axis (horizontal axis)
  3. Chart Title
  4. Markers
  5. Grid
  6. Y-Axis Label
  7. X-Axis Label
  8. Legend

Types of Line Chart in Google Sheet

Before creating a line chart, let’s understand the types of line charts available in Google Sheets.

  1. Regular Line chart
  2. Smooth line chart
  3. Combo line chart

How to Make a Line Chart in Google Sheets

A regular line graph will appear spiky, whereas a smooth line graph will appear to have flowing lines. A combo line graph combines the features of a line graph and a bar graph.

While you have complete control over how your graph appears, the most popular option is a normal line graph, which displays data more directly and precisely. However, the combo line graph works only when you have two series of data.

How to Make a Line Graph in Google Sheets with Multiple Lines?

Let’s consider we have the following dataset and want to create a line chart for the same.

How to Make a Line Graph in Google Sheets with Multiple Lines

The steps to create a Line Chart in Google Sheet are given below:

  • Step 1: Select the dataset.
  • Step 2: Click on the “Insert” tab and select “Chart” from the drop-down menu. You can also make use of the Chart icon in the toolbar to create a Chart.

How to Make a Line Graph in Google Sheets

 

  • Step 3: Now the Chart Pane will open towards the right side of the screen.
  • Step 4: Under the “Chart Type” select “Line Chart” from the drop-down menu.
  • Step 5: Now your Line Graph will be generated as shown below.

How to Make a Line Graph in Google Sheets

Setting Up Line Chart in Google Sheets

  1. Data Range: This defines the range of selected cells. You can also change the cell range by entering the cell ranges manually.
  2. X-Axis: This is the range of cells in your spreadsheet that make up the X-Axis of your chart. Under the X-Axis, you will have the option to check or uncheck the Aggregate box. By checking the Aggregate box, You can combine all values that have the same X-Axis key. The aggregate dropdown box for your series or lines will give you the choice of showing the data such as average, count, max, median, min, sum and so on.
  3. Series: A “series” is a term that refers to each line in your graph. You can edit the series bar by clicking the 3 dots to add or delete the labels.
  4. Switch Rows/Columns Box: When you check this box, you can switch the rows into columns and columns into rows.
  5. Use Row 1 as Headers: When you select this section, the data entered in row 1 will act as headers. Unchecking this section will consider all the data as non-headers.

How to Make a Line Graph in Google Sheets

Customizing the Line Graph in Google Sheets

Once the line graph is inserted in Google Sheets, you can customize the chart by moving to the Customize pane as shown below.

  • Chart Style: Here you can set up the chart background color and border color. Also, you can reset the layout from the list of options.
  • Chart and Axis Title: Under chart and axis title,  you have the option to change the chart title, chart subtitle, X-axis title, Y-axis style. Apart from this, you can customize your chart title by changing the font type, color, size and text format.
  • Series: You can change the style of your lines here. You may construct the chart that most clearly depicts the information you want to convey by altering the thickness of each line, the marker point size, and the marker point shape. The aggregate dropdown menu in this area allows you to choose the type of aggregate you want your chart to display. Under “format data point” you can click on “add,” where you may even specify a specific marker on your chart. You can also choose whether or not to show elements like error bars, data labels, and trendlines.

How to Make a Line Graph in Google Sheets

  • Legend: This menu allows you to move your legend to the desired location, as well as adjust the font, size, format, and text colour of the legend.
  • Horizontal Axis & Vertical Axis: This section comes with plenty of choices, where you resize the font, change the font types, color, format and much more.
  • Gridlines: When showing data, gridlines might be useful. They give viewers a new viewpoint that allows them to better understand the information presented.

Editing Line Graph in Google Sheets

To edit the line chart in Google Sheets, just click on the chart. The “Chart Editor” opens towards the right side of the screen, where you can edit your chart.

How to Make a Line Graph in Google Sheets

How to use IFS Function in Google Sheets: Testing IF Condition with Multiple Statements

With the help of the Google Sheet IFS Function, we can test multiple conditions and draw the results based on the condition with the same formula. The main difference between the IF function and IFS function is that the IFS function allows us to test multiple conditions at the same time. Whenever the IFS condition is found to be TRUE, the corresponding value is returned.

On this page, we have provided all the necessary information on how to use the IFS function with multiple conditions and important Google Sheet Tips. Read on to find out more.

Table of Contents

    1. Google Sheet IFS Function Syntax
    2. Using Excels IFS Function with Example
    3. Example 1 – Calculate Student’s Grade From Score Using IFS Function
    4. Example 2 – Calculate Commission Based On Sale Value Using IFS Function
    5. Highlights of IFS Condition in Google Sheet
    6. IF Vs IFS Function

Google Sheet IFS Function Formula

The IFS function syntax which needs to be used in Google Sheet is given below:

=IFS(Condition1, Value1, [Condition2, Value2],…)

  • Condition1: This is the first condition that the function examines.
  • Value 1: If the first condition is TRUE, Value1 is the value to return.
  • [Condition2…Condition127]: You can use up to 127 optional parameters using Condition2 to Condition127. Additional conditions might also be specified here. There must be a value returned in the event that the condition is TRUE for each condition you specify.
  • [Value2…Value127]: These are optional arguments. Each value is associated with a condition and is returned if that condition is the first to be TRUE.

Using Excels IFS Function With Example

As discussed above, we can use the IFS function to test multiple conditions. Let’s understand how to use IFS Function in Google Sheets for multiple conditions with examples.

Example 1 – Calculate Student’s Grade From Score Using IFS Function

Let’s understand how to use the IFS function with the help of the following dataset. Now we have students marks and want to map the grades according to the marks scored by the students according to the data entered in Cell “E” and “F“.

How to use IFS Function in Google Sheets

Follow the steps listed below to map the student’s grades according to marks with the help of the Google Sheet IFS function.

  • Step 1: Since I want to map grades in Cell “C“, I am hovering in the “C” cell. Like-wise, you can select the cell where you would like to apply the IFS condition.
  • Step 2: Now enter the formula as “=IFS(B2<$E$3,$F$2,B2<$E$4,$F$3,B2<$E$5,$F$4,B2<$E$6,$F$5,B2<$E$7,$F$6,B2>$E$7,$F$7)
  • Step 3: Click on the “Enter” button. Now drag the same formula to all the cells.

You will see the results as shown below.

How to use IFS Function in Google Sheets

Example 2 – Calculate Commission Based On Sale Value Using IFS Function

Now let’s see how to use the IFS function with another example. In the following dataset, let’s calculate the commission which will be added to the employee salary based on the sales they made as per the data mentioned in Cell “E” and “F”.

How to use IFS Function in Google Sheets

Follow the steps listed below to map the commission percentage against the employee name with the help of the IFS function in Google Sheet.

  • Step 1: Select the cell where you would like to apply the IFS formula in Google Sheets.
  • Step 2: Now type the formula as “=IFS(B2<$E$3,$F$2,B2<$E$4,$F$3,B2<$E$5,$F$4,B2<$E$6,$F$5,B2<$E$7,$F$6,B2>$E$7,$F$7)*B2“.
  • Step 3: Click on “Enter”. Now drag the formula to all the cells.

You will see the commission percentage against the employee name as shown below.

How to use IFS Function in Google Sheets

Highlights Of IFS Condition In Google Sheets

  • The value of the first TRUE condition would be returned by the IFS function. As a result, it’s possible to have many TRUE conditions. However, only the first one’s value would be returned.
  • The IFS function must return either TRUE or FALSE for all of its conditions. The formula will return an error if it does not.
  • The result of the formula would be a #N/A error, if all of the conditions in the IFS function return FALSE. Because the #N/A error isn’t very useful in determining what happened, set the last Condition to TRUE and the value to FALSE or a descriptive phrase like “No Match.”

IF and IFS Function in Google Sheet

The most significant distinction between the IFS and the IF functions is that the IF function allows you to define what value to return if the condition is FALSE. This feature is not available in the IFS function.

However, when you have several conditions, then the IFS condition would be a great help to get the results.

How to Create a Dependent Drop Down List in Google Sheets: Multiple Drop Down List

Dependent Drop Down List in Google Sheets: Usually a drop down list in Google Sheet is used to create a list of options where users can choose from. Drop down list is one of the most helpful functions in G-Suite since it helps us to save more time by avoiding spelling mistakes. However, in some instances, we feel like adding multiple drop down lists in Google Sheets. In this article, let’s understand how to create a dependent drop down list in Google Sheets for multiple rows in detail with important Google Sheet Tricks. Read on to find more.

Table of Contents

What is Multiple Dependent Drop Down List Google Sheets?

Firstly, let’s understand what a dependent drop-down list is with an example. Let’s say we have two columns, where Column A consists of a dataset of Fruits and column B with Vegetables. Now if we select Fruits in Column D, Column E should show only Fruits name in the drop-down list dataset. Similarly, if we select the Vegetable name in Column D, Column E in the spreadsheet should show only Vegetable names as shown below.

How to Create a Dependent Drop Down List in Google Sheets

How to create a Named Ranges in Google Sheet?

In order to update the cell values based on the selection in the drop down list in the Google Spreadsheet, we should first create named ranges.

The steps to create named ranges in Google Sheet are explained below:

  • Step 1: Select the cell where you would like to create a drop down list.
  • Step 2: On the homepage, click on “Data” and select  “Named Ranges“.

How to Create a Dependent Drop Down List in Google Sheets

  • Step 3: Now “Named Ranges” pane will open on the Google Sheets. Now click on “Add a range
  • Step 4: Mention the name for this “Named Ranges” and mention the cell range.
  • Step 5: Click on “Done“. This will create first-named ranges.

How to Create a Dependent Drop Down List in Google Sheets

Step 6: Now click on Add rule and follow the same steps mentioned above to create a Name range “Vegetable“. Like-wise you can create the number of ranges that you want to create.

How to Create a Dependent Drop Down List in Google Sheets

Note: Only a single word should be used to name the range. When defining the named range, use underscores to unite the words if there are more than one. For instance, if the category is ‘Seasonal Fruits’ rather than ‘Fruits,’ label the designated range Seasonal_Fruits.

How to create Dependent Drop Down List in Google Sheets?

Now, it’s time to create drop-down list in the selected cell. Here we are selecting Cell D3 and follow the steps given below.

  • Step 1: Click on “Data” and select “Data Validation” from drop down menu.
  • Step 2: Select “List from a Range” under “Criteria” and enter the cell range.
  • Step 3: Check the “Show Dropdown list in Cell” and click on the “Save” button.

How to Create a Dependent Drop Down List in Google Sheets

  • Step 4: Now you will see the drop down created in cell D3.

How to Create a Dependent Drop Down List in Google Sheets

Step 5: Now, before we create the second drop-down, enter the formula =INDIRECT(D3) into an empty cell in the worksheet, or create a new worksheet if necessary. This would bring up a list of all the products in the category chosen in Drop Down 1. This is a dynamic dependant drop-down list, so if you change the drop-down in cell D3 from Fruits to Vegetables, the list will change to show the vegetables.

How to Create a Dependent Drop Down List in Google Sheets

  • Step 6: Now the next step is to create a dependent drop down list in E3. For this place, the cursor in the E3 cell and select “Data Validation” from “Data“.
  • Step 7: Select the ‘Criteria‘ as ‘List from a range‘ in the Data Validation dialogue box, and then define the cells that contain the INDIRECT function result. It’s possible that various lists have varying numbers of items.

How to Create a Dependent Drop Down List in Google Sheets

Step 8: Click on “Save

Now you will see the dependent drop-down lists as shown below.

How to Create a Dependent Drop Down List in Google Sheets

How to Set Print Area in Google Sheets: Page Setup, Print Layout in Google Sheets

Setting Print Area in Google Sheet: You can utilise the Print function to transmit information or data from a Google Spreadsheet to a printed piece of paper. Unlike Excel files, we don’t have the permanent settings option in Google Sheet. Thus one will have to define the Print area to print the data into the Paper.

When you define the Print area in Google Sheets using the Print function, the function says how to print the data from the spreadsheet to the paper. On this page, let’s discuss how to format Google Sheets for Printing along with important Google Sheet Tips. Read on to find more.

How to Print Range of Cells in Google Sheets?

Let’s assume, we have more than hundreds of cells and we just need to print only the first 20 cells. We can define the cell range which needs to print from the Google Sheet to the paper by following the steps listed below:

  • Step 1: Select the cells until till where you would like to print the data into the sheet. Here I am selecting the first 20 cells.
  • Step 2: Now click on “File” and select the “Print” function from the drop-down menu as shown below. You can also use the keyboard shortcut CNTRL + P (“CMD+P” on Mac).

how to set print area in google sheets

  • Step 3: A Print menu will open on the screen. Click on “Current Sheet” from the Print icon.
  • Step 4: Now select “Selected Cells” from the Print icon menu.
  • Step 5: Here click on the “Next” icon.
  • Step 6: Check the “Preview” section and hit on “Print” button.

how to set print area in google sheets

The selected range of cells will be printed into the physical paper.

How to Set Print Area to Print Everything on Google Spreadsheet?

You can just print everything on the spreadsheet with 3 steps which are explained below.

  • Step 1: Click on “File” and select the “Print” option or just simply click the Print icon from the toolbar.

how to set print area in google sheets

  • Step 2: Select “Current Sheet” from the Print menu.
  • Step 3: Click on “Next” and send it to the printer by using the print management programme included with your operating system.

how to set print area in google sheets

How to Print Headers Rows on each Page?

One can make use of the Google Sheets Print header rows to contextualise the cell data. This will help us to have the fixed headers on all the pages which will further help us to view the paper without any confusion.

  • Step 1: Click on the “View” menu and select “Freeze” from the drop-down menu.
  • Step 2: Now select the 1 Row from Freeze.

how to set print area in google sheets

  • Step 3: Now click on the “Print” icon.
  • Step 4: Here you will see the fixed headers for all the pages.

how to set print area in google sheets

  • Step 5: Click on “Next” and select the “Print” icon.

Setting Custom Page Breaks in Google Sheets

Google Sheets allows you to customize the print area on a per-page basis. This can be extremely beneficial when it comes to data curation.

For example, you might want to display 20 rows of data per page from a spreadsheet with 100 lines, but Sheets only displays 23 rows per page by default. You can change Sheets to utilize more logical page breakpoints.

Follow the steps listed below to set the custom Page Breaks in Google Sheets:

  • Step 1: Select the cells and click on the “Print” icon.
  • Step 2: In the “Print Settings” window, move to the “SET CUSTOM PAGE BREAKS” section.

how to set print area in google sheets

  • Step 3: Here you can resize the page numbers by dragging the dotted cell as shown below.
  • Step 4: As soon as you have chosen the page breaks, click on “Confirm Breaks“.

how to set print area in google sheets

  • Step 5: See the preview link and Click on “Next“.
  • Step 6: Click on the “Print” icon and the required data will be printed as per the page breaks.

You can also edit your Page break as and when required from the Print Settings.

how to set print area in google sheets

Adjusting Scale and Margin to Fit in Google Sheets

Setting the print range isn’t usually the end of your job. Google Sheets will hardly default to a printing configuration within the preset range which results in a poor print experience. Thus to overcome this issue, one can use the Scale and Margin settings.

Margin Settings in Google Sheets

  1. Normal: This is one of the default settings which goes with all the printing options.
  2. Narrow: This setting will make each page take up more space. As a result of this option, fewer printed pages are produced, but each page contains more information.
  3. Wide: When this option is selected, extra whitespace is created around the contents on each page. On each page, it can show fewer columns and rows.
  4. Page Orientation: You may also change the page orientation between landscape and portrait to better match your data.

Scale Settings in Google Sheets

  1. Fit to Height: This reduces the size of the cells so that all rows can fit on a single page. This is handy for printing data that has a lot of columns but not a lot of rows.
  2. Fit to Width: This option shrinks the cells to fit all columns on one page. This comes in handy when printing data with a lot of rows but few columns.
  3. Fit to Page: If this option is selected, the full selected range will be displayed on a single page. It’s useful for narrowing down data ranges.

how to set print area in google sheets

How to Strikethrough in Google Sheets: 3 Easy Shortcut Methods

Strikethrough function is one of the important features which we widely use in the text editors such as Google Docs, MS Words and so on. Using the Strikethrough in Google Sheets will help us to format the required text by adding a line in the middle of the text.

Suppose if you have a list of to-do tasks and if you want to strike one after the other once the task is done, you can make use of the Strikethrough feature. On this page, we have provided how to use the Strikethrough function in Google Sheets along with important Google Sheet Tips and Shortcuts. Read on to find out more.

How do you Strikethrough Text in Google Sheets?

One can make use of any of the following methods in Google Sheets to Strikethrough a Cell.

Strikethrough Using Keyboard Shortcuts

One can Strikethrough the cell in Google Sheet with the keyboard shortcuts by following the steps listed below.

  • Step 1: Select the cell where you would like to apply the Strikethrough function.
  • Step 2: Now hold the “ALT+SHIFT” button and Press 5.

How to Strikethrough in Google Sheets

You will see the selected cells with the Strikethrough function as shown below.

Strikethrough function shortcuts in various devices:

  • Windows: Alt + Shift + 5
  • macOS: Command (⌘) + Shift + X
  • ChromeOS: Alt + Shift + 5

Strikethrough Using Google Sheets Toolbar

This is the easiest method of all. Follow the steps listed below to Strikethrough the cell with the help of a toolbar from Google Sheet:

  • Step 1: Select the cell to which you want to apply the Strikethrough function.
  • Step 2: Click on the Strikethrough function from the toolbar as shown below.

How to Strikethrough in Google Sheets

You will see the results as shown above.

Strikethrough the Cell Using Menu Options

Striking through the text in a particular cell using menu options is a bit long method. Follow the steps given below to draw a line in between the text in Google Sheets.

  • Step 1: Select the cells.
  • Step 2: Click on the “Format” option.
  • Step 3: Select “Strikethrough” from the drop-down menu.

How to Strikethrough in Google Sheets

You will see the results as shown below.

How to Strikethrough in Google Sheets

Google Sheets Strikethrough If Checkbox

We can use the Strikethrough feature as a checkbox when a certain task or work is completed. Consider the following dataset, where we have listed out the list of to-do tasks. Now we want the text to be striked out as soon each stage of the task is completed. Let’s understand how to do this with the help of the steps given below:

  • Step 1: Select the cell range.
  • Step 2: Click on the “Format” option and select “Conditional Formatting” from the drop-down menu.

How to Strikethrough in Google Sheets

  • Step 3: Now in the “Conditional Formatting” pane, click on the “Add new rule“.
  • Step 4: Select “Custom formula is” from the “Format rules“.
  • Step 5: Now type the formula as =B2=“Completed” and select the “Strikethrough” option as shown below.

How to Strikethrough in Google Sheets

 

  • Step 6: Click on “Done“.

Now you will see the results as and when you update Completed in the B cell.

How to Strikethrough in Google Sheets

How to apply Strikethrough Function to Particular Text in Cell?

When you apply the Strikethrough Function to a cell, the entire text inside the text will be striked out. However, you want to strike only particular text inside the cell, then follow the steps listed below.

  • Step 1: Select the cell where you want to apply the Strikethrough Function.
  • Step 2: Now double click the cell or press F2.
  • Step 3: Now you will be able to edit the text inside the cell. Here select the text which would like to strikeout.
  • Step 4: Click on the Strikethrough function from the menu or toolbar. The selected text will be striked out.

How to Strikethrough in Google Sheets

How to Remove Strikethrough Function in Google Sheets?

In some instances, we might accidentally apply the Strikethrough function or there will be a need where we should remove the Strikethrough functions. To remove the Strikethrough functions, follow the steps given below:

  • Step 1: Select the cell where you have already applied the Strikethrough function.
  • Step 2: Click on the “Strikethrough” function from the toolbar.

How to Strikethrough in Google Sheets

The Strikethrough function which was applied will be removed now.

 

How do I Undo Strikethrough in Google Sheets for Entire Sheet?

If you want to remove the Strikethrough function which has been applied in the entire Google Spreadsheet, just select the Grey rectangle box as given below and hit the Strikethrough button in the toolbar. The Strikethrough function which was applied earlier for the entire sheet will be removed.

How to Strikethrough in Google Sheets

How to Create a Drop Down List in Google Sheets: Add/Remove/Customize Drop Down Menu

Drop Down List in Google Sheets are one of the useful features which allow the user to choose the options from the set of pre-defined options. Using the drop down function on Google Sheets will ensure that the user is not making any mistakes while typing such as spellings and so on. With the help of Google Spreadsheets drop down lists, one can also do many things such as building charts, to-do lists, dashboards and so on. On this page, let’s explore how to insert drop down menu in Google Sheets with important Google Sheet Tips. Read on to find more.

How to Create Drop Down Menu in Google Sheets?

Let’s consider we have the following dataset where need to create a drop down list.

how to create a drop down list in google sheets

There are multiple methods to create a drop down list in Google Sheets which are explained below.

Creating Drop Down List Using Cell Range

Make sure you are having a dataset to create a drop down menu in Google Sheets and follow the steps listed below:

  • Step 1: Select the Cell Range to create the drop down list.
  • Step 2: Click on the “Data” tab in the menu.
  • Step 3: Select “Data Validation” from the drop-down menu.

how to create a drop down list in google sheets

  • Step 4: Now cross-check the cell range.
  • Step 5: Select List from a Range from Criteria.
  • Step 6: Now again select the data range.
  • Step 7: Now check the “Show dropdown list in cell” checkbox.
  • Step 8: Under “On Invalid data” select “Show warning” if you want the cell to show a warning if something is mistyped. Else choose the “Reject Input” which does not accept the input.
  • Step 9: Click on “Save“.

how to create a drop down list in google sheets

Create Drop Down List by Manually Specifying Items

In the above method, we saw how to create a drop down list on Google Sheets with the help of the List from Range option. Suppose if you want to manually specify the items in the drop-down menu, then follow the steps listed below:

  • Step 1: Select the Cell Range where you would like to create a dropdown menu.
  • Step 2: Now click on the “Data” tab and select “Data Validation“.
  • Step 3: Now under “Criteria” select “List of Items” from the drop down menu.
  • Step 4: Presently, in the field next to it, type the items which you would like to include separated by commas.

how to create a drop down list in google sheets

  • Step 5: Check the “Show dropdown list in Cell“.
  • Step 6: If you want the cell to show a warning if something is mistyped, select “Show warning” under “On Invalid data.”
  • Step 7: Otherwise, select “Reject Input,” under “On Invalid data” which rejects the input.
  • Step 8: Click on the “Save” button.

You will see the results.

how to create a drop down list in google sheets

Copying Drop Down List

You can easily copy the drop-down list from one cell to another cell in Google Sheets. Follow the steps listed below, if you only want to copy the drop-down list from a cell and not the formatting (such as colour, border, or number format):

  • Step 1: Select the cell from where you have to copy the drop down list.
  • Step 2: Now use the keyboard shortcut (CNTRL+C) to copy the cell or Right-click and select the copy button.
  • Step 3: Now move to the cell where you have to paste the copied drop-down list.
  • Step 4: Right click and hover your mouse towards the “Paste” option.
  • Step 5: Click on the “Paste Special” and hit on “Paste data validation only“.

how to create a drop down list in google sheets

  • Step 6: The copied drop down list will be pasted to the selected cell.

How to Change a Drop Down List?

In case you have drop down list in Google Sheets that needs to be modified, then you can simply follow the steps listed below:

  • Step 1: Select the cells where you would like to remove the drop-down list.
  • Step 2: Click on the “Data” option and select “Data Validation” from the drop down menu.
  • Step 3: Now in the “Data Validation” pane, correct the details under “Criteria“. Also, you have multiple options to modify the cell.
  • Step 4: Click on “Save“.

how to create a drop down list in google sheets

The drop down list will be updated.

How to Remove Drop Down List in Google Sheets?

To remove the drop down lists in Google Sheets, follow the steps listed below:

  • Step 1: Select the cells, where you would like to remove or delete the drop down lists.
  • Step 2: Click on “Data” and select “Data Validation” from the drop down menu.
  • Step 3: Now click on the button “Remove Validation“.
  • Step 4: Hit on the “Save” button. The Google Sheets drop down list or menu will be deleted.

how to create a drop down list in google sheets

How to Insert Bullets in Google Sheets: Adding Bullets in MAC, IOS, Android

Adding Bullets in Google Sheets: Bullets are usually a type of symbol used to highlight the items in the list. Though Google sheets come with hundreds of features, the Bullets or numbering feature is missing out. Thus one needs to add the bullets manually in order to insert bullets in Google sheets.

In this article, we have provided all the necessary information on how to add bullets in Google sheets in Android, MacBook with important Google Sheet Tricks.

How To Add Bullets in Google Spreadsheets?

There are multiple ways to add bullets in Google sheets and they are explained with detailed steps below.

Keyboard Shortcut to Insert Bullets in Google Sheets

  • Step 1: Select the cell where you would like to insert the bullets
  • Step 2: Double click the cell or press F2 to edit the cell.
  • Step 3: Press the 7 number by holding the ALT button.

how to add bullets in google sheets

You will see the bullets being inserted automatically now as shown below

How to Insert Bullets for Multiple Lines in the Same Cell?

To insert multiple bullets in the same cell, follow the above-mentioned steps to insert a bullet for the first line.

  1. Press ALT + Enter to move to the next line.
  2. Hold the ALT button and Press 7.

Follow the above steps to which line you need to insert the bullets.

Insert Bullets in Google Sheets using CHAR Function

To insert the bullets in Google Sheets using the CHAR function, follow the steps listed below:

  • Step 1: Select the cell where you want to insert the bullets.
  • Step 2: Now type the CHAR function as “=CHAR(8226)
  • Step 3: Click on the “Enter” button on your keyboard.

You will see bullets enabled in the selected cell as shown below.

how to add bullets in google sheets

This method is easy when you have to insert bullets for more than 1 cell. To insert bullets at 1 go in multiple cells, follow the steps as listed below.

  • Step 1: Select the cells, where you would like to insert the bullets.
  • Step 2: Now type the formula as “=CHAR(8226)&” “&A1“.
  • Step 3: Now drag the formula to all the cells.

You will see bullets applying to all the cells as shown below.

how to add bullets in google sheets

Copy Pasting Bullets from Web to Google Sheets

This method is for you if you don’t want to apply formulas or use keyboard shortcuts. Follow the steps listed below to insert bullets just by copy-pasting.

  • Step 1: Open any Google application such as Google Docs, Powerpoint or any text editing application.
  • Step 2: Type the text and insert bullet bullets in the text editor.

how to add bullets in google sheets

  • Step 3: Now copy the text and paste the content in the required cell.
  • Step 4: You will see the bullets enabled.

You can copy-paste various types of bullets such as ⇒, →, •, ∗, », ♦, ◊ and so on.

How to Make Bullets in Google Sheets on MAC or IOS?

Follow the steps as listed below to add bullets in Google sheets in MacBook:

  • Step 1: Select the cell where you would like to insert the bullets
  • Step 2: Double click the cell to edit the cell
  • Step 3: Press the number 7 number by holding the “Option” button.

how to add bullets in google sheets

Another way to enable bullets in Google Sheets using MacBook is to copy the bullets from any text editing application, then select the cell and press the “CMD” button + V. The bullets will be pasted.

How to Color Alternate Rows in Google Sheets: Alternating Colors Every 2 Rows, 3 Rows

Alternating Colors in Google Sheets: The Google Spreadsheets are adding new features from day to day to work efficiently. Sadly, we didn’t have the option to colour the alternate rows, so we had to rely on the Conditional Formatting function in Google Sheets to do so. However, the latest feature of Google Sheets allows us to color the rows alternatively. Within few clicks, we can color the rows alternatively in Google Sheets without any difficulty. On this page, let’s discuss how to select alternate rows in Google Sheets and color them.

Also, don’t miss out to check our article on important Google Sheets Tricks and Tips to work like a Pro in Google Sheets.

Color Alternate Rows in Google Sheets

Let’s consider we have the following dataset and now we would like to color the alternate rows.

Follow the steps listed below to color alternative rows in Google Sheets:

  • Step 1: Select the cells where you would like to color the cells alternatively. (Make sure you are selecting headers as well.)
  • Step 2: Click on the “Format” tab.
  • Step 3: Select “Alternating Colors” from the drop-down menu.

How to Color Alternate Rows in Google Sheets

  • Step 4: Now a new “Alternating Colors” Pane opens towards the right side of the screen.
  • Step 5: In the Alternating Colors pane, select Headers under “Styles“.
  • Step 6: You can select any of the default styles here from the list.
  • Step 7: Alternatively, you can also custom your colors, headers and other cells under the “Custom Styles” window.

How to Color Alternate Rows in Google Sheets

Now you will see the cells or the rows in Google Sheets coloured alternatively as shown below.

How to Color Alternate Rows in Google Sheets

Color Alternate Rows in Google Sheets using Conditional Formatting

This method was used before the “Alternating Colors” feature was added to the Google Sheets. Follow the steps listed below to color the rows with alternative colors using the conditional formatting function.

  • Step 1: Select the dataset, where you would like to color the cells alternatively.
  • Step 2: Click on the “Format” tab and select “Conditional Formatting“.

How to Color Alternate Rows in Google Sheets

  • Step 3: Now cross-check the Cell Range and select the “Add new rule“.
  • Step 4: Under “Format Rules“, select the “Custom Formula is“.
  • Step 5: Now type the formula as “=ISEVEN(ROW())“.
  • Step 6: Under “Formatting Style” select the color under the “Fill Color” function.
  • Step 7: Click on “Done“. You will see the results as given below.

How to Color Alternate Rows in Google Sheets

Google Sheets Alternating Colors Every 2 Rows

If you want to color the rows every 2 rows or the third row, then you will have to use the “Conditional Formatting” function which is explained below.

  • Step 1: Choose the dataset where you’d like to color the third row or color after every 2 rows.
  • Step 2: Select “Conditional Formatting” from the “Format” menu.
  • Step 3: Select “Add new rule” and double-check the Cell Range.
  • Step 4: Select “Custom Formula is” under “Format Rules.”
  • Step 5: Now in the value or formula tab, enter the formula as “=MOD(ROW(),3)=0
  • Step 6: Select the colour from the “Fill Color” function under “Formatting Style.”
  • Step 7: Hit the “Done” button. Now you will see the results.

How to Color Alternate Rows in Google Sheets

Highlights of Alternating Colors in Google Sheets

  • Google Sheets will automatically highlight the alternate rows in the colours you choose if you expand the dataset and add more records at the bottom.
  • If you delete records, the colours will remain and you will have to remove them manually.
  • Google Sheets will automatically update the colours if you add more rows to the dataset.
  • If you already have a colour applied to the cells, it will be replaced by the colours you choose when using the ‘Alternating colors’ feature to highlight them.
  • And when you remove the alternating colours, it will preserve the original colours while removing the alternate colours.

How To Remove Alternating Color in Google Sheets?

Select any cell in the dataset, go to the Format tab, and then to the ‘Alternating colors‘ option to remove the Alternating colour. This will bring up a window where you can ‘Remove alternate colors.’

remove alternating colors

How to Wrap Text in Google Sheets: Expand Cell using Text Wrap

Google Sheet Text Wrap: The main advantage of Google sheets is to store a large amount of data. However, when you are entering the long-form text such as an address, names or other details, the text entered in the particular cell will extend or overflow outside the cell. To format the extended text outside the cell, we need to use the Wrap function on the google sheets. On this page let’s understand how to overcome Google sheets text overflow with the help of the Wrap function along with important Google Sheets Tips. Read on to find out more.

How to Wrap Text in Google Sheets?

Let’s understand how to wrap text in Google sheets with an example. In the following dataset, the address entered has been extended outside the cell.

How to Wrap Text in Google Sheets

Now we should be wrapping the text in the cells so that it doesn’t overflow into other cells is the proper way to go (something as shown below).

How to Wrap Text in Google Sheets

Now let’s understand how to do it in the correct way in Google Sheets by the step-by-step procedure.

How to Wrap Text in Google Sheet Automatically?

Follow the steps as listed below to text warp in Google sheets:

  • Step 1: Select the cells that you want to wrap.
  • Step 2: Click on the “Format” option in the menu bar.
  • Step 3: Go to the “Text Wrapping” Section.
  • Step 4: Click on “Wrap” from the drop-down menu.

How to Wrap Text in Google Sheets

The above steps will instantly wrap the texts as shown below.

How to Wrap Text in Google Sheets

What is the Shortcut for Wrap Text in Google Sheets?

The shortcut to wrap the text in Google sheets are listed below:

  • Step 1: Select the cells which need to be wrapped.
  • Step 2: Click on the “Text Wrapping” icon which is under the menu bar as shown in the image below.
  • Step 3: The selected cells will be automatically wrapped as shown in the image below.

How to Wrap Text in Google Sheets

How does Google Sheet decide to Wrap Text?

Google sheet decides to wrap the text based on the column’s width. When the Text Wrap option is selected, the G-Sheet tries to fit the entered text into the same cell as the column width allows. If your column width is large enough, Google Sheets will fit all of the content on a single line.

However, if the column width of your Google sheet is smaller, then it will fit the content of the cell, by preventing the overflow of text. This means that it wraps the text into multiple lines within the same cell.

Also one of the best features of Google sheets will automatically modify the height of the cell to suit the content when the text is wrapped. So make sure the column width is big enough to wrap the text inside it.

How to Add Text Wrap Manually?

You may not want to wrap text based on column width in some circumstances, but rather want to be able to select where the text should be wrapped. For example, in the following example, you want each part of the address such as House No, Street No, City, State and PIN code in separate lines.

When you use the Google Sheets built-in wrap text function, it wraps the texts based on the column width. Here you have an option where you can define where the line should break manually by following the steps listed below:

  • Step 1: Select the cell, where you have to wrap the text by applying the line breaks.
  • Step 2: Press F2 or double click the cell. Now you can edit the cell and change the content of the cell.
  • Step 3: Move the cursor where you have to apply the line break.
  • Step 4: Now press “Enter” by holding the ALT key.

How to Wrap Text in Google Sheets

Text Wrap not Working in Google Sheets

One of the main reasons for Google sheets, Text Wrap not working is due to the column width. When your column is too broad for the spreadsheet to wrap the text, the text wrapping will not work as planned. This applies even if you have applied the “Text Wrap” function automatically.

If the text in the cell is longer than the cell itself, Google Sheets will wrap it. As a result, after applying “Wrap,” make sure the column is narrow enough for the text to require a new line.

Solution: Try narrowing the column that includes the content to be wrapped to force excess text onto a new line if you attempted enlarging your columns before determining the requirement for wrapping text.