Skip to content
Google Sheets Tips
  • Google Sheets Function List
    • Template on Google Sheets
  • Google Sheets Tips
  • Keyboard Shorctus
    • Google Sheets Keyboard Shortcuts
    • Google Slides Keyboard Shortcuts
    • Google Docs Keyboard Shortcuts
    • Gmail Keyboard Shortcuts
    • Google Chrome Shortcut Keys

Google Sheets

How to Use Google Sheets Smart Fill – Automate Data Entry with Smart Fill

June 29, 2022 by Varsha

Smart Fill is one of the new features that were recently introduced by Google. The Smart Fill feature in Google Sheets is similar to that of Excel’s FlashFill feature. The Smart Fill feature can be used if we want to automate the data entry since this feature identifies patterns between two columns and completes the … Read more

Categories Google Sheets Leave a comment

How To Add Leading Zeros in Google Sheets? – Allow 0 As First Digit in Google Sheets

June 28, 2022 by Varsha

It’s quite important for a few spreadsheet users to display zero before the number. However, when you enter a number in Google Sheets with leading zeros, then it might result just in numbers by eliminating the zeros in Google Spreadsheet. Thus, to overcome this issue, Google Sheets allows its users to enter leading zeros in … Read more

Categories Google Sheets Leave a comment

Square Numbers In Google Sheets – How To Square a Number in Google Sheets?

June 28, 2022 by Varsha

If you are a person who is working with engineering and mathematical calculations, then it is quite common for you to have square numbers. Calculation of square numbers is made easy in Google Sheets. Google Sheets has multiple methods with the help of which one can easily convert a number into square numbers. In this … Read more

Categories Google Sheets Leave a comment

How To Get A Hyperlink From A URL – Formula To Extract URL From Hyperlink In Google Sheets

June 27, 2022 by Varsha

Anchor text is more recognizable to most people than URLs. Users, on the other hand, would want to know the URL address for a number of reasons. In Google Sheets, URLs may be readily extracted from a given text. Google Sheets users may extract hyperlinks from the text in a number of ways. If you … Read more

Categories Google Sheets Leave a comment

How To Insert Sheets in Google Sheets? – 6 Ways to Insert a Sheet in Google Sheets

June 27, 2022 by Varsha

Google Sheets can have 200 sheets per workbook. So if you have fewer than 200 sheets, then you can easily insert sheets into the spreadsheet. Inserting sheets into the existing spreadsheet is one of the most common tasks with which a user will deal. Ranging from keyboard shortcuts to Apps Script, there are multiple ways through … Read more

Categories Google Sheets Leave a comment

How To Sort Sheets in Google Sheets? – Arrange Sheets in Google Sheets

June 17, 2022 by Varsha

When you are working with a spreadsheet that has a large number of sheets, it is extremely difficult to find the particular sheet you are searching for among other sheets. To overcome this issue, we can simply sort the sheets. Google Sheets allows its users to sort the sheets using various methods. Also, with the … Read more

Categories Google Sheets Leave a comment

How To Clear Formatting in Google Sheets ? – Remove Formatting

June 17, 2022June 17, 2022 by Varsha

Google Sheets is one of the best spreadsheet programs that help users work with large datasets. Also, one of the main reasons for using Google Sheets is that it allows its users to format the data and make it appear in a more presentable way. There are plenty of formatting features available in Google Sheets … Read more

Categories Google Sheets Leave a comment

How To Insert Line Break in Google Sheets? – Create New Line in Same Cell

June 16, 2022 by Varsha

Inserting a line break in Google Sheets is quite tricky since it doesn’t have any inbuilt feature or function for the same. However, with the help of various functions and keyboard shortcuts, we can easily make text go to the next line in Google Sheets. There are multiple methods with the help of which we can … Read more

Categories Google Sheets Leave a comment

Extract Month Name in Google Sheets – How To Convert Month Number to a Month Name in Google Sheets?

June 16, 2022 by Varsha

Extract Month Name in Google Sheets: When working with the dataset with date values, it would be quite confusing to know the exact month. In particular, if you are working on sales data and want to know in which month the sales were high, then extracting the month from the date would help to find the … Read more

Categories Google Sheets Leave a comment

How to Generate Serial Numbers Automatically in Google Sheets – Autonumber in Google Sheets

June 16, 2022 by Varsha

Google Sheets Sequential Numbers: If you are managing a dataset with records, then it is extremely important for you to have columns with serial numbers. However, entering the serial numbers manually will be a tedious task if you have a large dataset. And to overcome this issue, there are multiple ways in Google Sheets that … Read more

Categories Google Sheets Leave a comment

How To Highlight Negative Numbers Red in Google Sheets? (3 Easy Methods)

June 14, 2022 by Varsha

When you are working with a numerical dataset, it is quite common to experience negative numbers. If your dataset is small, then it’s very easy to identify the negative numbers to understand the detailed analysis of the data. However, if you are working with a large dataset, then manually checking the negative numbers would be … Read more

Categories Google Sheets Leave a comment
Post navigation
Older posts
Page1 Page2 … Page21 Next →

Recent Posts

  • Working with Pandas and XlsxWriter in Python | Set – 2
  • How to Delete One or More Rows in Excel File using Python Openpyxl?
  • How to Create Sheets in Excel File in Java using Apache POI?
  • Python for Spreadsheet Users
  • How to Use Google Sheets Smart Fill – Automate Data Entry with Smart Fill
  • How to Perform a VLOOKUP (Similar to Excel) in R?
  • How to Convert an Excel Column into a List of vectors in R?
  • How to Import an Excel File into R ?
  • How To Add Leading Zeros in Google Sheets? – Allow 0 As First Digit in Google Sheets
  • Square Numbers In Google Sheets – How To Square a Number in Google Sheets?
  • How To Get A Hyperlink From A URL – Formula To Extract URL From Hyperlink In Google Sheets
© 2022 Google Sheets Tips • Built with GeneratePress