How to Add Text Rotation and Perform Accounting in Google Sheets?

Text Rotation and Accounting are the two latest features that are new in Google Spreadsheet. Text rotation feature in Google Sheets will help the text to tilt up, down, stack vertically, rotate up, down, and so on. And when it comes to Accounting, this feature in Google Sheets enables us to create a balance sheet and much more.

On this page, let us understand everything about Text Rotation and Accounting with the help of Google Sheet tips. Read further to find more.

How to Use Text Rotation in Google Sheets?

There are basically two methods with the help which we can rotate the text in Google Spreadsheet and they are using Tools and Format options.

The steps to use the Google Sheets text rotation feature using Format Options on the dataset are given below:

  • Step 1: Select the dataset which you would like to rotate in the Google Sheets.
  • Step 2: Now click on the “Format” option in the menubar.
  • Step 3: Here a drop down menu will open and now choose “Text Rotation” from the drop down menu.
  • Step 4: Now a Text Rotation sub menu will appear on the screen.
  • Step 5: Here you will have various options such as Tilt up, Tilt down, Stack vertically, Rotate up, Rotate down, and so on.
  • Step 6: Choose the option based on which you want to rotate the text and the text will be rotated accordingly.

add-text-rotation-and-accounting-in-sheets

Rotating Text using Icons Present in Toolbar

We can also rotate the text using tool icons present in the toolbar. The steps to rotate the text using icons present in the toolbar are given below:

  • Step 1: Open the Google Spreadsheet.
  • Step 2: Now click on the “Text Rotation” icon in the toolbar as shown in the image given below.

add-text-rotation-and-accounting-in-sheets

  • Step 3: As soon as you click on the Text Rotation icon in the Google Sheet, you will see various kinds of text rotation options.
  • Step 4: Choose the best-suited option according to which you would like to rotate the text. This will rotate the selected text based on the rotation option you have chosen.

add-text-rotation-and-accounting-in-sheets

How to Perform Accounting in Google Sheets?

With the help of Google Sheets, we can also perform various accounting operations. However, in order to perform the accounting operations in Google Spreadsheet, we will have to navigate into few options and they are listed below:

  • Step 1: Open the Google Sheets where you want to perform accounting operations.
  • Step 2: Now select the cells where on which you want to perform accounting operations.
  • Step 3: Then click on the Format tab in the menubar.
  • Step 4: Now choose the “Number” from the Format menubar.
  • Step 5: From the Number submenu, choose the “Accounting” option.
  • Step 6: This will account the selected dataset.

accounting in google sheets

How to Remove Text Rotation in Google Sheets?

To remove the text rotation in Google Sheets follow the steps as given below:

  • Step 1: Select the text from which you want to remove the text rotation.
  • Step 2: Now click on the “Text Rotation” option in the menubar.
  • Step 3: Click on the “None” option from the drop down menu. This will remove the text rotation feature which you have enabled previously.

Named Versions in Google Sheets: How to Name Version History in Google Sheets

Google Sheets Named Versions is one of the best features which helps us to name the edit history while working. For example, let us consider you are writing a story in Google Sheets. So the first step is to write a draft, then submit it for review and then move the draft to publish. Thus here we have 3 cycles of versions to complete a story and we can name these edit history cycles using Named Versions in Google Sheets.

In this article, let us understand everything about Google Sheets version history with the G-Sheet tips provided on this page. Read on to find more.

Table of Contents

How to Create Named Versions in Google Sheets?

Follow the steps as given below to create a named version in Google Sheets:

  • Step 1: Open a Google Spreadsheet which is edited multiple times.
  • Step 2: Now simply click on the “Edit History” or use the keyboard shortcut “Ctrl + Alt + Shift + H” to open the edit history of the Google Sheets.

named-versions-in-google-files

  • Step 3: Here a window will open on the screen as shown below. Now click on the “More Actions” icon (3 dots …).

named-versions-in-google-files

  • Step 4: Now you will be given two options – Name this version and Make a copy. Choose Name this version from the drop down menu.

named-versions-in-google-files

  • Step 5: Just enter the name your want to give to that particular version. Once the name is given, press the “Enter” button. That’s it, you have named a version in Google Sheets.

named-versions-in-google-files

How to Rename the Named Versions in Google Sheets?

Follow the steps as given below to rename the named versions in Google Sheets:

  • Step 1: Open the Google Spreadsheet where you want to rename the named versions.
  • Step 2: Now click on the “Edit History” or use the keyboard shortcut “Ctrl + Alt + Shift + H”.
  • Step 3: Here the Version history window will open the screen and this window displays the list of versions in Google Sheets. Now choose the Version history which you want to rename.
  • Step 4: Double click the version name which you want to rename.
  • Step 5: Now rename the version history and press the “Enter” button. This will rename the earlier named versions.

named-versions-in-google-files

How to Show Only Named Versions in Google Sheets?

Google Sheets also allows the user to view only named versions. This feature will serve as a great help since there will be a various number of versions and we can view only the important versions to know what exactly has been changed.

The steps to view or show only named versions in Google Sheets are given below:

  • Step 1: Open the Google Spreadsheet where you want to view only named versions.
  • Step 2: Now click on the Edit History. Alternatively, you can simply use the keyboard shortcut Ctrl + Alt + Shift + H  to access the edit history in Google Spreadsheet.
  • Step 3: Here under the “Version History” tab, you will see an option named “Only show named versions“.
  • Step 4: Just check this option as shown in the image given below.
  • Step 5: Now Google Spreadsheet will start showing only the named versions excluding other unnamed versions in Google Sheets.

named-versions-in-google-files

Auto Suggested Pivot Chart in Google Sheets: Parameters for Creating Pivot Table Using Explore

Google Sheets Pivot Table is one of the best features which helps to summarize or view a large number of data in a simpler format. Also, with the help of the Pivot table in Google Sheets, we can apply filters and perform various operations and view the results without making any changes in the actual data. With these advantages, anyone would like to make use of Pivot tables for analyzing the data. And to help you with it, this page will tell you everything about how to create Pivot Tables with the help of Google Sheet tips. Read on to find more.

Table of Contents

Auto Suggested Pivot Tables in Google Sheets

If you are a person who is looking to create a Pivot Table, then you will have a question “How do I automate a pivot table in Google Sheets?”.

Well, this depends on the dataset you have created. Let us understand about auto suggested Pivot Tables in Google Sheets with the following example.

auto-suggested-pivot-tables-in-sheets

For the above dataset, the Google Spreadsheet will automatically suggest the Pivot Tables. In order to know how to insert the auto-suggested Pivot Tables, follow the suggestions given below:

  • Step 1: Open the Google Spreadsheet and create a dataset as shown in the image above.
  • Step 2: Once the data has been created, click on the “Explore” button which is towards the right bottom side of Google Sheets.
  • Step 3: Now the “Explore” window will open on the screen. Now you will various features suggested based on the data. In the same way, you will see the Pivot Table feature being suggested as shown in the image given below.

auto-suggested-pivot-tables-in-sheets

  • Step 4:  As soon you click on the “Pivot Table” a new window will open the screen as shown below. This screen will show how the Pivot Table will be created on the Google Sheets.

auto-suggested-pivot-tables-in-sheets

  • Step 5: Simply click on the “Insert Pivot Table” button. This will insert the Google Sheets auto suggested pivot tables into the spreadsheet.

How to Manually Insert Pivot Tables in Google Sheets?

What if Pivot Tables are not auto suggested by Google Sheets? Well, you don’t have to worry if Pivot tables are not auto suggested. You can also insert the Pivot Tables manually to the selected dataset by following the steps given below:

  • Step 1: Open the Google Spreadsheet which has the dataset to create Pivot Tables manually.
  • Step 2: Now click on the “Data” tab in the menubar.

auto-suggested-pivot-tables-in-sheets

  • Step 3: Choose “Pivot Tables” from the drop-down menu.
  • Step 4:  Now a Pivot Table window will appear on the screen. Under “Data Range” choose the cell range to which you would like to create a Pivot table.
  • Step 5: Under “Insert to” you have got two options – New Sheet and Existing Sheet.
  • Step 6: Now click on the “Create” button. This will simply create Pivot Tables into the Google Spreadsheet.

auto-suggested-pivot-tables-in-sheets

Also, Check Our Articles:

How to Sync Data From One Google Sheet to Another Spreadsheet?

Sync Data in Google Spreadsheets: While working with Google Sheets which is shared with multiple users, it would be quite difficult to apply filters or perform other operations since it would affect other users as well.  In such instances, most of the Spreadsheet users will simply create a copy and make modifications. However, copying the dataset will not help if there are any new changes made to the actual spreadsheet. To overcome this issue, we can simply sync data from one Google Sheet to another Google Sheets.

So, in this post, let us understand how to Sync Data from one Google Sheets to another sheet with the help of GSheet tips provided on this page. Read further to find more.

Table of Contents

IMPORTRANGE Function Sync Data in Google Sheets

In order to sync data in Google Spreadsheet, we will have to make use of IMPORTRANGE range function. The syntax of IMPORTRANGE function is given below:

IMPORTRANGE(spreadsheet_url, range_string)

  • spreadsheet_url- The spreadsheet URL from which data will be imported. The value for the spreadsheet URL must be either enclosed in quotation marks or a reference to a cell containing a spreadsheet’s URL.
  • range_string – A string of the format specifying the import range.

Note: 

If you don’t provide a sheet name, the formula will assume you need to import data from the Google Sheets document’s first sheet. This text can alternatively be placed in a cell and the cell reference is used as the second argument.

How To Sync Data From One Google Sheets to Another Spreadsheet?

Let us consider a dataset where we have employee details. Now we want to import this data into another Google Spreadsheet. Now the steps to sync data from one Google Spreadsheet to another are listed below:

  • Step 1: First open the Google Spreadsheet from where you want to import the data.
  • Step 2: Now copy the URL of that Spreadsheet.

sync-data-from-one-spreadsheet-to-another

  • Step 3: Now open the Google Spreadsheet where you want to import the data.
  • Step 4: Move to the designated cell to import the data to the current spreadsheet.
  • Step 5: Now enter the formula =IMPORTRANGE(“URL”,”‘Sheet Name’!Cell Range”). In our case the formula is =IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1N4cmvJLQZWIObhF-j-FQ-9MwtVD454V7wmJU7ciG55g/edit#gid=0″,”‘ratings’!B1:C15″).
  • Step 6: Press the “Enter” button.
  • Step 7: Now you will see the #REF! error on the cell from where you want to import the data. Now move to the cell and click on the error, where Google Sheets will show the message asking “Allow Access” to connect the sheets.

sync-data-from-one-spreadsheet-to-another

  • Step 8: Click on the Allow access blue button. You must note that you will be asked to click on Allow Access only once. Once you give this permission, the data will be imported automatically.
  • Step 9: Press the “Enter” button and you will see the results as shown in the image below:

 

sync-data-from-one-spreadsheet-to-another

How To Create Star Rating System in Google Sheets? (With Example)

Google Sheets is one of the great tools that is used by all types of firms right from small-scale traders to large-scale businesses. Thus Google Sheets is one of the most widely used spreadsheet software, where we can various kinds of mathematical operations, organize and store data, and much more. With plenty full of functions in Google Sheets, we can also create a Star Rating system in Google Sheets. This rating system is widely used by Schools and corporate companies to rate their employees, students, staff respectively.

So if you are wondering on how to create a Star Rating System in Google Sheets, then this post is for you. In this article, we will discuss how to create a rating system with the help of Google Sheet tips. Read on to find more.

Table of Contents

How Do I Add a Star Rating in Google Sheets?

On this page, we are using REPT and CHAR functions to calculate 5 star ratings.

  • REPT Function: In Google Sheets, the REPT function is used to repeat an expression a specified number of times.
  • CHAR Function: In Google Sheets, the CHAR Function returns a character specified by a code number that refers to your device’s character set.

Star Rating System in Google Sheets Example

Now let us assume the following dataset which consists of employee names in column A and their ratings in column B as shown in the image below.

create-a-star-rating-system-in-google-sheets

Follow the steps given below to create a star rating system in column C.

  • Step 1: Move to the cell where you would like to create a Star Rating System. In our example, we are creating a rating system in column C (Cell C2).
  • Step 2: Now type the formula in Cell C2 – “=REPT( CHAR( 9733 ) , B2 )“.
  • Step 3: Press the “Enter” button.
  • Step 4: Now drag the formula applied cell to other cells till where you would like to insert the Star Rating. Alternatively, Google Sheets also suggest the AutoFill formula which you can use to insert the formula automatically.

create-a-star-rating-system-in-google-sheets

Now you will see the results as shown in the image below.

create-a-star-rating-system-in-google-sheets

Explanation of Star Rating System in Google Sheets

In our example, Column B contains a numerical value that represents the rating. Column C is where you convert that value into a more visually appealing star rating.

The star is created using the CHAR function, which returns a Unicode character based on a number. The REPT function is used in this case to repeat the star that corresponds to the rating value.

How to Edit and View Text from Right to Left in Google Sheets?

When you open a spreadsheet with right-to-left text, or when you add text in a right-to-left language, right-to-left controls are activated automatically. However, if the right to left language controls is not activated, you can manually enable the same in Google Sheets.

In this article, let us understand how to edit and view the text from right to left in a spreadsheet with the help of Google Sheet tips provided on this page. Read on to find more.

How to Turn On Right to Left Language Controls in Google Sheets?

In order to set up the right to left language controls in the Google Sheets, follow the steps as given below:

  • Step 1: Open the Google Spreadsheet on your device.
  • Step 2: Now click on the “Menu” from the top left side of the screen.

edit and view text from right to left in Google Sheets

  • Step 3: Choose “Settings” from the drop-down menu.

edit and view text from right to left in Google Sheets

  • Step 4: Now a sub-menu will open on the screen. Now tick the checkbox “Always show right-to-left controls“.
  • Step 5: Click on the “Ok” button as shown in the image below.

edit and view text from right to left in Google Sheets

Now this action will enable the right to left language controls in the Google Spreadsheet.

How to Change Direction of the Text Inside a Cell in Google Sheets?

Consider the following dataset. Here we need to change the direction of the text inside a cell in Google Spreadsheet.

edit and view text from right to left in Google Sheets

Follow the steps as given below to change the direction of the text inside a cell in Google Sheets:

  • Step 1: As soon as you enable the Turn On Right to Left Language controls in Google Sheets, you will be able to see Right to Left Language controls enabled in the toolbar.

edit and view text from right to left in Google Sheets

  • Step 2: Now select the cell, where you would like to change the direction of the text.
  • Step 3: Click on the “Right to Left” icon in the toolbar.
  • Step 4: This will change the text directions as shown in the image below.

edit and view text from right to left in Google Sheets

How to Change the Directions of the Columns in Google Spreadsheet?

Google Sheets also allows us to change the directions of the columns. In order to change the column directions in the Google Sheets, follow the steps as given below:

  • Step 1: Open the Google Spreadsheet, where you would like to change the directions of the columns.
  • Step 2: Select the columns to change the directions.
  • Step 3: Now in the menubar, click on the “Right to Left” icon.
  • Step 4: As soon as you choose the icon, the column directions will be changed in sheets as shown below.

edit and view text from right to left in Google Sheets

How to Use Dark Theme in Google Sheets: Simple Steps to Change Google Sheets Theme

It is no surprise for Google Sheets to have various features and functions which make one life easier when it comes to data analysis. One of the amazing features of Google Sheets is that it enables the user to change the theme of the sheet in Dark view, light view as well as in Normal view. However one must note that these options are available on the Phone.

On this page, let us understand how to use a dark theme in a Spreadsheet with the help of Google Sheet tips provided on this page.

How to Use Dark Theme in Google Sheets?

Follow the steps as outlined below to enable the dark theme viewer in Google Spreadsheet:

  • Step 1: Open the Google Spreadsheet application on your device.
  • Step 2: Now on the top left side of your device, tap the Menu icon as shown in the image below.

Use Dark theme in Google Sheets

  • Step 3: Now a menu will open on the screen. Choose “Settings” from the drop down menu.

Use Dark theme in Google Sheets

  • Step 4: Now the Settings menu will open on the screen. Now choose “Theme” from the drop-down menu.

Use Dark theme in Google Sheets

  • Step 5: Now three theme options will open on the screen. Choose the “Dark” Theme from the three options.

Use Dark theme in Google Sheets

Step 6: Now the theme will be enabled and you will see a message from Google Spreadsheet. Click on the “Ok” button.

Use Dark theme in Google Sheets

  • Step 7: As soon as you click on the “Ok” button. You will see your Spreadsheet with dark mode as shown below.

Use Dark theme in Google Sheets

How To Turn Off the Dark Mode in Google Sheets?

Your documents and sheets are automatically adjusted to fit the dark theme and improve viewing. For collaborators, you can see how a document or sheet will look in the light theme. In order to turn off the dark mode in Google Sheets, follow the steps as given below:

  • Step 1: Open the Google Spreadsheet where you want to change the theme view.
  • Step 2: Now click on the “More” icon (three dots) towards the right side of the screen.

Use Dark theme in Google Sheets

  • Step 3: Now just uncheck the icon under “View in light theme“.

Use Dark theme in Google Sheets

How to Get the Last Monday of the Month in Google Sheets (With Examples)

Since the workweek is normally starting from Monday through Friday, knowing the last Monday of each month might be useful in various cases. For example, if you want to know what is the date of the last Monday in a particular month, then you can find the same with the help of the Google Sheets EMONTH function. The EOMONTH function in Google Sheets, as the name suggests, stands for “End Of Month.” It returns the last calendar day of a month that is a given number of months behind or ahead of a given date.

In this article, let us understand how to use the EMONTH function to know the last Monday of the Week along with Google Sheet Tips provided on this. Read further to find more.

Syntax of Google Sheets EMONTH Function

=EOMONTH(start_date, months)

  • start_date: It is the date from which the EOMONTH function calculates the month’s end date.
  • months: It is the number of months in which the function should move forward or backward through time, according to a positive or negative value.

How to Find Last Monday of a Month?

Assume you want to know the date of the final Monday in the month of October 2021. Now to get the same from the Google Sheets, follow the steps as given below:

  • Step 1: Move to the cell where you want to find the last Monday of the month.
  • Step 2: Now enter the formula “=EOMONTH(DATE(2021,10,1),0)WEEKDAY(EOMONTH(DATE(2021,10,1),0),2)+1“.
  • Step 3: Press the “Enter” button and you will see the date; which represents the last Monday of the month.

last monday of a month in google sheets

Formula Explanation: 

  • EOMONTH: This function returns the month’s last date. ‘End Of Month’ is the abbreviation for the end of the month.
  • WEEKDAY: This function returns the date’s weekday number. The last day of October 2021 in this scenario was 31/10/2021, which is a Sunday. So, on Sunday, the Weekday function returned 7 (the numbering began on Monday). So Monday is number one, Tuesday is number two, and so on).
  • DATE: When the year, month, and day values are specified, this function returns the date.

EOMONTH(DATE(2021,10,1),0)

The last date would be October 2021, according to this component of the formula. It’s important to note that I was using ‘0’ as the second argument (which gives us the last date of the month to which the date in the first argument belongs).

You can also use this function to get the previous/next month’s last date (instead of 0 use 1 for next month and -1 for the previous month).

WEEKDAY(EOMONTH(DATE(2021,10,1),0),2)

The first portion of the formula tells us which weekday is the month’s last day. This will yield 7 in this case because Sunday is the last day of the week.

=EOMONTH(DATE(2021,10,1),0)-WEEKDAY(EOMONTH(DATE(2021,10,1),0),2)+1

Finally, the above formula gives the month’s last Monday.

How to Turn On Notifications in a Google Spreadsheet in 2 Easy Steps

While working in a Google Sheets that you own and is shared with multiple members, you will have fear of losing data. Also, it would be quite difficult to identify which user has made what changes in the spreadsheet if multiple persons are making changes at one go.

However, with the Google Sheets Turn on Notifications feature, you can easily identify which user has what changes in the spreadsheet. The Turn on Notifications feature of G-Suite will set up notifications to be notified when other people make changes to your spreadsheets and to see what they have changed.

In this article, let us understand how to enable the notifications if someone makes changes to the dataset with the help of Google Sheet tips provided on this page. Read further to find more.

How To Set Notifications on Google Sheets?

Only you have the ability to configure notifications for yourself. When you make changes to your spreadsheet, you won’t receive notifications, but you will receive notifications when others do.

Follow the steps given below to get notified when a user makes changes in your Google Spreadsheet:

  • Step 1: Open the Google Spreadsheet to enable the notifications.
  • Step 2: Click on the “Tools” tab from the menubar.
  • Step 3: Select “Notification Rules” from the drop-down menu.

Turn on notifications in a spreadsheet

  • Step 4: Now a window will open on the screen with various options listing down. Move to the When Section, where further you will have two options.
    • Any Changes are Made: When someone makes a change to a spreadsheet, you can set up notifications to notify you.
    • User Submits a Form: When someone fills out a form, you can receive notifications.
  • Step 6: Select “how often” you want to receive notifications in the window that appears. You will be notified with:
    • Email – daily digest: Every day, send a summary of all changes.
    • Email right away:  For each change, send an email.
  • Step 7: Choose the options as per your choice and click on the “Save” button.

Turn on notifications in a spreadsheet

Explanation:

Here when you choose daily digest, you will list of changes made by multiple users as a summary at one go to your mail id. However, when you choose “Email Right Away“, you will start receiving the emails as and when a user is making changes to your Google Spreadsheet.

How to See Who Makes Changes in Google Sheets?

Depending on your level of spreadsheet access, you can see who makes changes to your spreadsheet.

  • If you are an editor, you’ll be able to see the usernames of those who make changes.
  • If you are a viewer, you’ll be able to set notifications but won’t be able to see usernames.

Use Apps Script to create more specific notification rules, such as when someone modifies a specific range of cells.

How to Turn Off Notifications in Google Sheets?

The steps to turn off the notifications in Google Sheets are given below:

  • Step 1: Click on the Tools from the menubar.
  • Step 2: From the drop-down menu, choose “Notification Rules“.
  • Step 3: Now a window will open up on the screen. Here click on the “Delete” button.

how to turn off notifications in google sheets2

This will turn off the notifications in Google Sheets.

If you want to edit or change the permission under the how often and when section, click on the “Edit” options instead of Delete to change the permissions.

How To Add, Edit, View, Filter And Delete Comments in Google Sheets?

Comments are one of the useful features that allow you to collaborate in Google Sheets. Users will be able to provide feedback, suggestion, and tag contacts in the comments. In this article, let us understand how to Add, Edit, View, Filter, And Delete the comments in Google Spreadsheet with the help of Google Sheet tips provided on this page. Read on to find more.

Table Of Contents

How to Add a Comment in Google Sheets?

To add a comment in google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to add the comment
  • Step-2: To add the comment, click on the Add comment icon which is available in the toolbar

add comment google sheets

Additionally, you can also right-click on the cell for which you want to add a comment and select the Comment option. Also, the keyboard shortcut key would be Ctrl+Alt+M

  • Step-3: Type your Comment that you want to add

add comment google sheets

  • Step-4: Click on the Comment which is highlighted in green color in the above image.

add comment google sheets

You could see in the above image, the comment is added to A1 cell.

How to Edit a Comment in Google Sheets?

You can always edit a comment which you have added. To Edit the comment in the google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to edit the comment
  • Step-2: Click on the More icon and select the Edit option.

add comment google sheets

  • Step-3: Type the new message and click on the save

add comment google sheets

How to View a Comment in Google Sheets?

To view the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon

add comment google sheets

  • Step-2: Now you can view all the comments. To close, click on the same Open comment history icon again.

Additionally, At the bottom of any comment window, you can also click Open all comments.

How to Find a Comment in Google Sheets?

To find the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon
  • Step-2: Click on the cell name, you could see the comment and its location in google sheets

add comment google sheets

Additionally, To see all comments in the sheet, click See all comments from the drop-down list.

How to Filter a Comment in Google Sheets?

To Filter the comment in the google sheets, you need to follow the below steps.

  • Step-1: On the top right page, click the Open comment history icon
  • Step-2: On the left side of the Comments window, click the “All” drop-down list to filter the comments by any of the following:
    • All
    • For you
    • Open
    • Resolved

add comment google sheets

  • Step-3: All comments in that list will appear in the window

How to Delete a Comment in Google Sheets?

You can always delete a comment which you have added. To delete the comment in the google sheets, you need to follow the below steps.

  • Step-1: Click on the cell that you need to delete the comment
  • Step-2: Click on the More icon and select the Delete option

add comment google sheets

Step-3: Now, click on the Delete button to delete the comment in google sheets.

add comment google sheets

 

How to Use the ISTEXT Function in Google Sheets? (With Example)

The ISTEXT function in google sheets checks cells for text value and returns TRUE or FALSE. This function can be useful when you have to validate the data which contains only text.

In this article, let us understand how to use the ISTEXT Function in Google Spreadsheet with the help of Google Sheet tips provided on this page. Read on to find more.

Table Of Contents

What Is ISTEXT Function in Google Sheets?

ISTEXT is a very straightforward function. If the given cell is text, you will get a “TRUE” response, and if it’s not a text, you will get a “FALSE” response.

It is one of google sheets functions that examine the data in a cell to identify what type of data it is — and whether it’s the correct form of data.

ISTEXT function will return only TRUE or FALSE as the response. This can be used in the IF function for more validation part.

Syntax:

=ISTEXT(data)

In the above syntax,

  • ISTEXT – This is the keyword for the ISTEXT function in google sheets
  • data – Is the cell that you have to validate if the given data is text or not.

How To Use ISTEXT Function in Google Sheets?

Now, let’s see an example of how to use the ISTEXT function in google sheets.

istext function google sheets

In the above example,

We are checking if the cell is having text or not with the formula =ISTEXT(A2).

We are having data with “ABCDEF” and “Hello!! Welcome” which is considered as the text, and the response is TRUE. The cell having “1234” which is numeric, is not considered as text, and the response is FALSE.

Using ISTEXT with the IF Function in Google Sheets?

We could validate the ISTEXT with the IF function in google sheets.

Formula:

=IF(ISTEXT(data),”condition_1″,”condition_2″)

In the above formula,

  • IF – If is the keyword for calling the IF statement function in google sheets
  • ISTEXT – This is the keyword for the ISTEXT function in google sheets
  • data – This is the cell that you have to validate if the given data is text or not
  • condition_1 – If the validation is TRUE(cell is having text) then executes given condition here
  • condition_2 – If the validation is FALSE(cell is not having text) then executes given condition here

Let’s see an example of how to use the ISTEXT function inside the IF condition.

istext function google sheets

In the above example,

We are checking if the cell is having text or not using if function with the formula –

=IF(ISTEXT(A4), “This is Text”, “This is not a text”)

We are having data with “ABCDEF” and “Hello!! Welcome” which is considered as the text, and the response is “This is Text”. The cell having “1234” which is numeric, is not considered as text, and the response is “This is not a text”.

Using the IF statement with the ISTEXT function makes it clear to the user that they have entered incorrect content. This can be useful when gathering any kind of information.

ISTEXT Similar Functions in Google Sheets

Similar to ISTEXT Function, we also have functions like,

  • ISNUMBER – Returns TRUE, if the data is having a numeric value.
  • ISDATE – Returns TRUE, if the data is having the date
  • ISURL – Returns TRUE, if the data is having a URL
  • ISEVEN – Returns TRUE, if the data is having an even number value
  • ISODD – Returns TRUE, if the data is having an odd number value

All of these are text validation sequences designed to help you determine whether the correct content has been entered into a spreadsheet.