Tip3X

Tag: Google Sheets

  • How to use new themes on Google Sheets?

    —

    by

    Aman
    in

    Do you know that the Google Sheets app offers a total of 16 themes on the web app to splash a new outlook? The standard mode remains the default option although, you can change it to a different one. Besides, users can customize the selected theme for chart backgrounds, text, and hyperlinks. How to use…

  • What is new Enhanced Smart Fill feature in Google Sheets? How does it function

    —

    by

    Aman
    in

    Google has introduced a new AI-powered Enhanced Smart Fill feature for the Sheets app which lets you enjoy the latest tweaks of artificial intelligence. This addition is a part of the Duet AI suite for Workspace customers and enables them to perform their tasks more efficiently. The Enhanced Smart Fill feature will make manual text…

  • How to insert current date and time in Google Sheets?

    —

    by

    Raul Sarte
    in

    If you have a spreadsheet where you want to view the current date (with or without time), you can easily do this in Google Sheets. This is convenient when you want to always display the date and time when you open the worksheet. The advantage of these date and time features in Google Sheets is…

  • How to use Conditional Formatting to find duplicate Rows in Google Sheets?

    —

    by

    Raul Sarte
    in

    Google Sheets is one of Google’s most powerful products and one of the go-to solutions for spreadsheet and data management on the web. Moreover, Sheets supports custom functions and formulas that help make up for some of these shortcomings. If users are savvy with formulas or can do a little bit of scripting, Sheets can…

  • How to use COUNTIF function in Google Sheets?

    —

    by

    Raul Sarte
    in

    If you want to count the number of items in a range of cells based on specific criteria, then the COUNTIF function in Google Sheets is the one to use. You can count the number of occurrences of anything, using criteria for either numbers or text in the range of cells. Moreover, parameters identify the…

  • How to alphabetize in Google Sheets?

    —

    by

    Raul Sarte
    in

    Google Sheets often helps people manage lists of people, things, and places. An alphabetical sort can not only bring a bit of order to these lists but also help us recognize patterns, such as inaccurate or duplicated data. Google Sheets on the web offers at least two distinct alphabetical sort options. Furthermore, the first reorganize…