VarshaGoogle Sheets Phone Number Format: When you type a phone number in Google Sheets, the sheet displays the number in the default style. In order to format any number in the format of a Phone number, we should apply the Google Sheets phone number format formula. Let’s understand how to do this with an example … Read more
Sort by Color in Google Sheets: In the year March 2020 the officials of Google have added a new feature named Sort by Color which helps to sort the rows or columns based on the color code. This feature is really helpful when you want to sort the rows which are highlighted in a particular … Read more
Google Sheets Zoom-In and Zoom-Out are one of the latest features which were recently added. Earlier, browser customization options were used to perform Zoom operations in Google Sheet. However, with the new improved Google Sheets, we can either use the keyboard shortcut or built-in function to Zoom the spreadsheet. On this page, we have provided … Read more
Converting PDF to Google Excel Sheets is the process of converting the PDF file into the G-Sheet. Usually, you might receive the scanned copy of the dataset in a PDF file which needs to be operated in Google Sheet. Unfortunately, G-Suite doesn’t provide us with the option where we can convert the PDF into Google … Read more
The sorting feature is one the most important feature which any user would like to use in Google Sheets. We can sort any dataset in alphabetical order, ascending/descending number-wise, or also use comparing operators to sort the data. Let’s understand how to sort any given dataset along with few Google Sheets tips. Read on to … Read more
Split Text to Columns: When working with a huge dataset in Google Sheets, it’s common to squish the data. Split text to columns is one of the most useful features which was recently added in Google Sheets, that helps to split the data into columns. You can split data in the Google Sheets by any … Read more
Create and Print Labels in Google Sheets: For pulling information into uniform printed labels, Google Sheets can be a useful tool. However, the Print labels function is not included in Google Sheets, thus one needs to use the “Create & Print Labels” Add-ons function from Google Workspace Marketplace. Create and Print Labels add-on extracts data … Read more
Concatenate in Google Sheets: Concatenate is a formula that can be used to combine data from multiple data cells into a single cell. With the help of concatenating formula, we can combine multiple cells with separator, comma and much more options in Google Spreadsheet. In this article, let’s understand how to combine data from multiple … Read more
Google Sheets Named Ranges lets you use a single range across several sheets, formulas, and other operations, and then change it from a specific location. For example, Instead of naming a range of cells “A1:B2,” you may call it “Fruits.” A formula like “=SUM(A1:B2, D4:E6)” could be written as “=SUM(Fruits, Vegetables)” in this way. In … Read more
Though Google Sheets is a user-friendly spreadsheet software, we tend to experience Formula Parse Errors from time to time. We experience errors for various reasons. This could be a blank cell, a number, or a relevant alert message that we are unfamiliar with. However, we can use the IFERROR function to overcome these errors. The … Read more