User Posts: M. Shaiq Ansari
![How to Search in Google Sheets [Complete Guide]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-search-in-google-sheets-18-1zg9m2p41m5bquysz101j8t1fjur1oy63h8k92pckoa4.png)
To Search in Google Sheets Press Ctrl + F to open the search dialogue box. Type the word you want to search. Google Sheets will highlight the ...
M. Shaiq Ansari
![How to Make a Table in Google Sheets [Complete Guide]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-make-a-table-in-google-sheets-24-1zg9f2dfibz8vcnrizbkker9wmjzcuv8idoih6kl1dlo.png)
To Make a Table in Google Sheets Input your tabular data. Optionally, format your table by setting headings with font-weight: bold, font-size: ...
![How to Make a Scatter Plot in Google Sheets [Top Guide]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-make-a-scatter-plot-in-google-sheets-46-1zg0nxpgvj7x5r4qvmyzdpflnye67ugl7lgs63czktr8.png)
To Make a Scatter Plot in Google Sheets Basic Scatter Plot: Gather your data. Select the data. Go to "Insert" > "Chart". Choose the ...
To Highlight Rows and Columns in Google Sheets To highlight empty cells, select the data range. Go to "Format" > "Conditional formatting". ...
![How to Find & Highlight Duplicates in Google Sheets [5 Methods]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-find-highlight-duplicates-in-google-sheets-47-1zdzl102vgo18o6gh3btfqqrmfmtho6lq3rldh80lf3w.png)
To Find & Highlight Duplicates in Google Sheets Go to "Data" > "Data cleanup. Click on "Remove duplicates". A window will appear; click ...
![How to Count Unique Values in Google Sheets [4 Methods]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/How-to-count-unique-values-in-google-sheets-3-1zdkjrqgmtw67sfw8d7ps6a6jud7y7wfysncau50l0a4.png)
To Count Unique Values in Google Sheets Select the data range. Formula: =COUNTUNIQUE(A1:A19). Result: Displays the count of unique values. OR ...
To Add/Create Drop Down List in Google Sheets Write column names in headers. Enter data in separate columns to hide. Select a cell, go to "Data" ...
![Date Formatting in Google Sheets [Complete Guide]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/How-to-stop-google-sheets-from-auto-correcting-dates-25-1zd7rrqgaqg43uenwoy9svx30kiwr5u61xl995lsyzl8.png)
Date Formatting in Google Sheets Go to "Format" > "Number" > Select "Custom date and time". Set the format with AM/PM. Now your time will ...
To Get Data Using Google Sheets API Visit https://console.cloud.google.com/ Select an existing project or create a new one. Name your project ...
To Freeze a Row and Column in Google Sheets Go to View > Freeze. Choose an option for rows or columns. Your selected rows or columns are now ...
To SUM a Column and Row in Google Sheets The basic SUM function: =SUM(3+7) or =SUM(2+3+4+6+20+45+46+217). Use cell addresses, e.g., =SUM(A2,A3), or ...
To Sort in Google Sheets Sort by Date: Use a built-in function or the SORT formula. Helpful for finding the oldest and youngest entries. Sort ...
![How to Sort Rows in Google Sheets [Best Practice]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-sort-rows-in-google-sheets-4-1z7e7ut0822anp946kln94f4xamqoikpdosm5x9jz7fo.png)
To Sort Rows in Google Sheets Open your data set in Google Sheets. Click on a cell where you want the sorted data to appear. Enter the following ...
![How to Sort Pivot Table in Google Sheets [Best Practice]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-sort-pivot-table-in-google-sheets-6.2-1z7e2c82tj7sbcbcedbhdcn56ffqu45gmr8phicfsao4.png)
To Sort Pivot Table in Google Sheets Open your data in Google Sheets. Go to "Insert" and choose "Pivot table". Define the data range and ...
![How to Sort by Column in Google Sheets [2 Methods]](https://www.officedemy.com/wp-content/uploads/thumbs_dir/how-to-sort-google-sheets-f1-1z7dx00x2qzci9e2v4cmyid63vrihrao1qm1pymavwng.png)
To Sort by Column in Google Sheets Sort by Single Column: Select the column to sort. Go to "Data" > "Sort range" > "Advanced range sorting ...
