Varsha We frequently receive shared Google Sheets in which specific rows or columns are hidden. When the rows are hidden, the user may have the impression that some data is missing. Thus to overcome this, Google Sheets allows us to unhide the rows easily at few clicks. Let’s understand how to unhide rows with important Google … Read more
We frequently find ourselves needing to rearrange columns in our Google Sheets. For example, sometimes we want to bring two columns next to each other as an afterthought, and other times we just want to compare their values. So let’s understand how to move columns with the help of Google Sheet tips provided on this … Read more
There are several functions in Google Sheets that help you perform various actions and operations without any difficulty. Of all the functions, Google Sheets has one of the most useful functions named YEAR. Using the YEAR function in Google Sheets, we can simply extract the year based on the date. To simplify the dataset based … Read more
Google 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