Data Formating :
=> How to change multiple values to uppercase/lowercase/proper case/sentence case in Google Sheets?
Select your data.
From the Instant tab select Data Formatting dropdown and then press Uppercase/Lowercase/Proper case/Sentence case button.
=> How to change multiple values to positive/negative in Google Sheets?
Select your data.
From the Instant tab select Data Formatting dropdown and then press the Positive/Negative button.
=> How to freeze/unfreeze data in Google Sheets?
Select your data.
From the Instant tab select Data Formatting dropdown and then press the Freeze/Unfreeze button.
=> How to trim extra space from values in Google Sheets?
Select your data.
From the Instant tab select Data Formatting dropdown and then press the Trim Out Extra Space button.
=> How to fill multiple cells with some values in Google Sheets?
Select empty cells.
From the Instant tab select Data Formatting dropdown and press Fill Empty Cells button.
Then it’ll ask you to enter the value. So enter your value and hit the ok button.
Create And Manage Sheets :
=> How to hide/unhide/delete multiple sheets at once in Google Sheets?
Select all the sheets that you want to hide/unhide/delete.
Press the appropriate button(Hide/Unhide/Delete).
=> How to protect/unprotect multiple sheets at once in Google Sheets?
Select all the sheets that you want to Protect/Unprotect.
Press the appropriate button(Protect/Unprotect).
=> How to rename multiple sheets at once in Google Sheets?
Select all the sheets that you want to Rename.
Open Rename Sheets Dropdown and select Prefix/Suffix/Remove.
Enter Value You want to Add or Remove From Selected Sheet name.
Press the Rename Sheets button.
=> How to create multiple sheets at once using selected names in Google Sheets?
Select cells containing your sheet names.
From the Instant tab select Create & Manage Sheets dropdown and then press Create Sheets For All Selected Cells button.
=> How to create/update/delete index sheet automatically in Google Sheets?
From the Instant tab select Create & Manage Sheets dropdown and then press Create New Index Sheet / Update Index Sheet / Delete Index Sheet button.
=> How to sort all sheets in a spreadsheet in ascending and descending order in Google Sheets?
From the Instant tab select Create & Manage Sheets dropdown and then press Sort All Sheets(A to Z) / Sort All Sheets(Z to A) button.
=> How to sort all sheets in a spreadsheet by tab color in Google Sheets?
From the Instant tab select Create & Manage Sheets dropdown and then press Sort All Sheets By Color button.
Highlight Duplicates :
=> How to highlight duplicate rows and values in Google Sheets?
Choose what you want to highlight.
Choose where you want to highlight duplicates.
If you want to highlight it with multiple colors then select Different Colors option. Otherwise, it’ll all be highlighted with the same Yellow color.
If you want to ignore case while highlighting duplicates then select this option. By default it is case sensitive.
Press the Highlight button.
Also, you can instantly highlight duplicate rows and values using below instant operations from the instant tab.
- Rows (In Selected Data)
- Values (In Selected Data
- Rows (In Current Sheet)
- Values (In Current Sheet)
Unique Values :
=> How Find Unique Values in Google sheets?
Select Your Data.
Open Sutrabar and from the Instant tab. Select Unique Values dropdown and then press Highlight Unique (In Selection) button.
Also, you can find unique values in entire sheet using Highlight Unique (In Sheet) button.
=> How to Remove Duplicate Values in Google sheets?
Select Your Data.
Open Sutrabar and from the Instant tab select Unique Values dropdown and then press Remove Duplicates (In Selection) button.
Also, you can remove duplicate values from entire sheet using Remove Duplicates (In Sheet) button.
Clear :
=> How to clear values / formatting / dropdowns / notes from Google Sheets?
Choose where you want to perform the clear operation.
Select all the things that you want to clear.
Press the Clear button.
Also, you can instantly clear formatting and values using below instant operations from the instant tab.
- Values (In Selected Data)
- Formatting (In Selected Data)
- Values (In Current Sheet)
- Formatting (In Current Sheet)
- Values (In Spreadsheet)
- Formatting (In Spreadsheet)
Delete Empty Rows / Columns :
=> How to delete empty rows and columns from Google Sheets?
Choose where you want to delete empty rows/columns.
Choose what you want to delete.
Press the Delete button.
Also, you can instantly delete empty rows and columns using below instant operations from the instant tab.
- Rows (In Selected Data)
- Columns(In Selected Data)
- Rows (In Current Sheet)
- Columns(In Current Sheet)
- Rows (In Spreadsheet)
- Columns(In Spreadsheet)
Add Rows / Columns :
=> How to add multiple rows and columns in Google Sheets?
Choose what you want to add.
Choose where you want to add these new rows/columns.
Enter the number of rows/columns you want to add.
Press the Add button.
Insert Text Conditionally :
=> How to insert specific text in multiple cells in Google Sheets?
Enter the text that you want to insert.
Choose where you want to add this new text. (Also, add details in right side box in required options)
If you want to ignore case while adding your text then select this option. By default it is case sensitive.
Press the Add Text button.
Miscellaneous :
=> How to find and highlight duplicate values in Google sheets?
From the Instant tab select Miscellaneous dropdown and then press Find & Highlight Data button.
Enter the value that you want to find and highlight.
Select where you want to find and highlight your value.
Select color to highlight your values. By default values will be highlighted with yellow color.
Select appropriate conditions to find and highlight your value.
Press Find & Highlight button.
=> How to export Google sheet data to a JSON file?
From the Instant tab select Miscellaneous dropdown and then press Export To JSON button.
Select the sheet to export.
Select which row you want to set as a header.
Press the Export button.
=> How to export Google sheet data to a XML file?
From the Instant tab select Miscellaneous dropdown and then press Export To XML button.
Select the sheet to export to XML.
Select which row you want to set as a header.
Press the Export To XML button.
=> How to split Google sheet data into multiple sheets?
From the Instant tab select Miscellaneous dropdown and then press Split Data Into Multiple Sheets button.
Select the data that you want to split. As you would select the data in your sheet the range will be updated in this field automatically.
Choose how you want to split your data.
Select the appropriate conditions that you want to apply while splitting your data.
Select how you want to name new sheets with splitted data.
Press the Split Data button.