30 Coolest Google Sheets hacks

1. How to add a comment?

Comments in google sheets are a great help for all of us. When you’re working with someone on sheets and you want that person to correct something to do so you need to write a comment on that cell let’s see how. To write a comment right-click on the cell you want to make a comment then click on comment. Write!

How to add a comment in google sheets

2. How to add color to a cell in sheets

You may want to highlight a cell to keep a note of that. Let’s see how to do that. Select the cell/cells you want to modify then click on the fill color in the toolbar. Now choose your color

How to color a cell in Google Sheets

3. Use the CLEAN function to clean cell

To remove non-printable characters from your cell type “=Clean(‘Cell address’)” in the function bar.

Clean cell function in Google Sheets

4. How to see the edit history of a cell?

To view, the edit history of a cell right-click on it & click on show edit history

Check the History of cells in google sheets

5. How to add an image to a cell in google sheets?

To add images to a cell select that cell and in the function bar type “Image(Url)”

how to add a image to cell in google sheets

6. Clear all Formatting in a cell

To clear all formatting in a cell follow the shortcuts:

Mac: Cmd + /
Windows: Ctrl + /

7. Insert a current date in a cell

You were working on a report and in a certain cell, you wanted to put today’s date. To do so in seconds follow the shortcut.
Mac: Cmd + ;
Windows: Ctrl + ;

add date to google sheets
Add date to google sheets

8. Find and replace

To open Find & replace in google sheets press
Mac: Cmd + Shift + H
Windows: Ctrl + H

See also  How to scan documents in Phone:  Scan Documents On Android and iPhone

9. Quick tip:

Use conditional formatting to help visualize data

10. Import Charts from sheets

We can use charts to intensify our presentations. Let’s see how to import charts from sheets to slides/docs
First, create a chart in sheets. Second, go to slides/docs click on insert>charts>from sheets then select the spreadsheet and choose the chart and click on import. Done.

how to add a chart in google sheets

11. Capitalization in cell (Name)

Suppose you’ve got an extract in which there are names all written in an indefinite manner. To make them definite select the cell(s) where you want them to be corrected and in the function bar type
“proper(select the cells to be corrected)”

How to correct capitalization in a cell # Google sheets

12. Translate text

If you want to translate text in a cells type
‘=GOOGLETRANSLATE(cell to be translated)’

Translate another language in google sheets

 

13. Quick tip:

Track (& organize) guest post submission

14. Split names and data

If you ever find that you just must divide the data contained in a very very cell into multiple cells, you will be able to use the selection “divide the text into columns” (found under “Data”). this could be useful if you want to wash up data, for example, if you
would like to separate the first and last names into separate columns on your sheet.

Split cells in google sheets

15. Check if it is an Email

If you have an inventory of emails and you’d wish to confirm that they’ve used a sound email address structure, then you will be ready to check them using Google Sheets. It won’t certify your emails are being delivered, but it’ll help identify any email addresses that will bounce (like ones missing the ‘@’ or ‘.com’).

Check if it is an email in google sheets

16. Connect to google forms

Suppose you want all your responses in google sheets. To do so create a google form & go to the Responses page there you will see a create spreadsheet sign click on that.

See also  10 Best Lite Android Apps For 2023

17. How to add more columns to spreadsheets?

By default, there are columns till Z to add more right-click on any cells and then select insert column.

Add more columns in a spreadsheet google sheets

18. Quick tip:

Track Backlinks

19. How to add a sheet?

To add a sheet click on the + sign you see at the bottom left.

How to add sheet in google sheets

20. How to rename a sheet?

To rename a sheet click on the arrow facing downwards next to the default name at the bottom left then select rename.

21. How to make a chart in google sheets?

To make a chart in google sheets select the cells for which you want to make a chart click on insert and then select chart.

22. Quick tip:

Lock cells to prevent changes by others

23. How to add a pivot table

To add a pivot table select the data for which you want a pivot then clock on data>pivot table and then create

24. Fill an entire column with a certain cell

Control + D or ⌘ + D to fill in an entire column to a certain cell

25. Switch between sheets using your keyboard

To switch between press alt/option + Up/Down arrow

26. Quick tip

Extend sheets with some add-ons

27. Fill right function in google sheets

If you want the same value as in the right cell press Cmd + R. Voila!

28. How to open add-ons menu

Add-ons menu helps in doing more with your sheets. To open it press Ctrl + Opt + N

29. Open the context menu

Usually, we open a context menu with a right-click but you can also open it by pressing Cmd + Shift + \

30. Best Tip of the blog

You can create Qr codes in Google Sheets

Latest

test

Voyager Scholarship: Voyager Scholarship 2025 Application, Enrollment & Tips

The Voyager Scholarship is an esteemed program that provides...

Spokeo Artificial Intelligence Scholarship 2024 Application, Enrollment & Tips

Artificial Intelligence (AI) has become an integral part of...

Pizza Hut Scholarship: Pizza Hut Scholarship 2024 Application, Enrollment & Tips

The Pizza Hut Scholarship Program is a post-high school...

Newsletter

Don't miss

test

Voyager Scholarship: Voyager Scholarship 2025 Application, Enrollment & Tips

The Voyager Scholarship is an esteemed program that provides...

Spokeo Artificial Intelligence Scholarship 2024 Application, Enrollment & Tips

Artificial Intelligence (AI) has become an integral part of...

Pizza Hut Scholarship: Pizza Hut Scholarship 2024 Application, Enrollment & Tips

The Pizza Hut Scholarship Program is a post-high school...
Vasav Trehan
Vasav Trehanhttps://technifyed.com
Vasav is the brain behind Technifyed.com. His love for Technology and Programming led him to kick-start this flabbergasting website and his Instagram account @technifyedofficial. His motive is to Simply Tech for Everyone.

test

Voyager Scholarship: Voyager Scholarship 2025 Application, Enrollment & Tips

The Voyager Scholarship is an esteemed program that provides financial aid, opportunities, and support to students aspiring to pursue a career in public service....

Spokeo Artificial Intelligence Scholarship 2024 Application, Enrollment & Tips

Artificial Intelligence (AI) has become an integral part of our modern world and is transforming various industries. As a result, several organizations are providing...