Google Sheets

To make a table in the Google Sheets, select the cells, define the borders to the selected cells and the header row then insert the data.

To insert the check marks in Google Sheets, use any of the methods; using the “Insert Special Characters” feature, using the Unicode or the Wingding fonts.

To hide the gridlines in Google Sheets, either use the “View” option in the menu bar or while printing uncheck the “Show grid lines” option.

To use the inventory template for Google Sheets, download the extension of the “Template Gallery for Sheets” from the add-on.

The free 2023 Google Sheets attendance template can be accessed from the “Template gallery” of the Google Sheets to maintain the attendance record.

To make a button in Google Sheets, click on “Insert”, then choose “Drawing” to make the button shape and make a script in “Apps Script” to assign the button.

To use the COUNTIFS function in Google Sheets, define the range and criteria in the general syntax of “=COUNTIFS(range, criterion)”.

To sort the data in Google Sheets either use the “Sort Sheet” option from the “Data” of the toolbar or use the “Sort” formula.

The IMPORTRANGE function is used to import data from one spreadsheet to another by simply using the function and it requires the URL, sheet name, and range.

To remove the duplicates in Google Sheets, one can use the built-in feature of “Remove Duplicate”, use the “Unique Function”, or download Power Tools extension.

To number rows in Google Sheets for adding serial numbers, either use the fill handle or the functions such as SUM() and ROW().

To sort by date in Google Sheets, the SORT function can be used by following the usage syntax of “Sort(range,column_index,sort_criteria)”.

To round numbers in Google Sheets, we can use any of the Round, Ceiling, Floor, Trunc functions or the custom formula in Apps Script.

To unhide the rows in Google Sheets, select the entire sheet and choose “Unhide rows” from the dropdown menu. Different other methods are explained in this article.

To multiply the values, cells, or ranges in the Google Sheets, we can use either the asterisk (*) symbol or the PRODUCT() function.

To divide the numbers, cells, and columns in Google Sheets, either use the division operator “/” or the “DIVIDE()” function.

To sort by date in Google Sheets, the SORT function can be used by following the usage syntax of “Sort(range,column_index,sort_criteria)”.

To count the NON BLANK cells in Google Sheets, use any of the functions that are COUNTA, COUNTIF, SUMPRODUCT, and a combination of the functions.

A user-friendly and collaborative platform is provided by Google Sheets, a flexible cloud-based spreadsheet program, … Read More

There are many shortcuts in Google Sheets which make the work efficient but most important 22 shortcuts which should be known are discussed in this post.

To sum up the column in Google Sheets, first, open the Google Sheets, select the column, apply the SUM formula, and customize the formula according to you.

To turn on Google Sheets dark mode, simply access “Settings” in the mobile application, then choose “Theme” and finally “Dark” to apply it

To change the row height in Google Sheets, first select the rows then set the height of the rows by dragging the alignment icon up or down.

To use the REGEXMATCH function in Google Sheets, open the Google Sheets, select the cell, and use the REGEXMATCH function by following its general syntax.

For people, companies, and organizations to organize and analyze data collectively, Google Sheets has evolved … Read More

When using spreadsheets, sorting data is essential, and Google Sheets offers a powerful function called … Read More

Google Sheets and Microsoft Excel have become two of the market leaders in the constantly … Read More

To convert Google Sheets to Excel, open the Google Sheet, click on “File” and choose “Downloads” in the drop-down menu. Next, choose the “Microsoft Excel” format.

When you come across a locked sheet without the required rights, unlocking a Google Sheet … Read More

To lock a sheet in Google Sheets, choose the sheet by clicking on its name. Then go to “Data” in the menu tab and choose “Protect sheets and ranges” to lock a sheet.

To use VLOOKUP function to find specified information from another sheet in Google Sheets, follow the syntax “=VLOOKUP(search_key, range, index, [is_sorted])”.

To wrap text in Google Sheets, select the cell or range of cells and then choose “Wrapping” from the drop-down menu of “Format” in the toolbar.

To use the Script editor in Google Sheets, select the “Apps script” from the drop-down menu by clicking on “Extensions”. Next, simply hit on “Script Editor” option.

To group rows and columns in Google Sheets, select the specific rows or columns, choose “View more row options” and simply select “Group rows”.

To create a calendar in Google Sheets, either select the cells and make the entries of month, days, and dates manually or use the “Annual Calendar” template.

To add and subtract time in Google Sheets, we can use the “SUM()” function. To subtract the time, we can use the “Negative(-)” sign with one of the values of the time.

To use the checkbox in Google Sheets, either use the insert option or “Data validation” feature. To make them appealing, you can change their size and color.

To use the percentage formula in Google Sheets, select the cell and define the percentage formula by initiating it with the equal sign in the formula bar.

To apply the formula on an entire column in Google Sheets, 3 different methods Dragging the Formula Down, using the Fill Handle, and the Shortcut key can be used

To split cells in Google Sheets, we can go to the “Data” and then the “Split text to columns” option, also another method is by using the “Split” function.

To delete/remove empty rows in Google Sheets, three different methods can be adopted. These methods are by filtering, sorting the data, or using the extensions.

To insert the bullet points in Google Sheets, either use the manual technique by adding the bullets from the “Custom number format” or choosing the “CHAR” formula.

To use the QUERY formula in Google Sheets, follow the general usage syntax “=QUERY(Range, “SELECT WHERE [Condition]”)”.

To create a meal planning spreadsheet template in Google Sheets, open the new Google Sheet and create a table with the days and meal options

To create a custom workout template in Google Sheets, open the new blank Google Sheet and create a table with the specified information.

To count cells with text in Google Sheets, two functions of COUNTIF and COUNTA are used. Also, the arrayformula can be used to count the text-filled cells.

To add a new line in the same cell in Google Sheets, two different methods can be used, either by using the keyboard shortcuts and the other by using the formula bar.

One can subtract the two different numbers in Google Sheets in three different ways. Using the subtraction operator, sum function, and minus function.

To use the SUMIF function of the Google Sheets, follow the general syntax =SUMIF(range, conditions, sum range) to calculate the sum of the specified column.

To use the Google Sheets “IF THEN” formula, select the cell where the formula should apply. Then define the formula in Google Sheets.

In Google Sheets, pick the cells, then select “Format” from the menu bar, and then “Conditional Formatting” to highlight duplicates.

To create and edit the Drop-Down Menu in the Google Sheets, click on “Data” then “Data Validation” and define the options.

To convert Excel to Google Sheets, upload the Excel file to Google Drive, then right-click on the uploaded file and open it with “Google Sheets”.

To efficiently search texts or numbers in Google Sheets either use the shortcut key of “CTRL+F” or use “Conditional formatting”

To lock the cells in Google Sheets, select the range of cells, then click on “Data” in the menu bar, then “Protected sheets and ranges” and set the permissions.

To freeze a row & a column in Google Sheets, click on “View” in the menu bar and then select “Freeze” to freeze columns and rows.

The “FILTER” function is used on Google Sheets to extract the specified information. The filter function helps Google Sheets users to sort the information.

To merge the cells in Google Sheets, select the cells which are to be merged, and then click on the “Merge icon” in the toolbar.

To create the expense tracker in Google Sheets, either use the default template of “Monthly Budget” from the template gallery or create a new spreadsheet.

For the currency conversion in Google Sheets using the built-in formula of “GOOGLEFINANCE”. This formula retrieves the information from Google Finance