Google Sheets

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