10 effective Google Sheets hacks to 10x your productivity.
A thread🧵
A thread🧵
1) Color Alternate Rows
Instead of coloring individual rows, you can use the shortcut by selecting the data set that you want to highlight alternate cells and then,
> Go to the format tab
> Then click on ‘Alternating colors’
Instead of coloring individual rows, you can use the shortcut by selecting the data set that you want to highlight alternate cells and then,
> Go to the format tab
> Then click on ‘Alternating colors’
2) Freeze Rows or Columns
You lose track of data as soon as you scroll away from the headers, so to combat that you can freeze the row or column header.
You lose track of data as soon as you scroll away from the headers, so to combat that you can freeze the row or column header.
Click on the gray empty box which is located in the top left of the sheet, then:
> Drag it down to freeze the rows
> Drag it to the right to freeze the columns
> Drag it down to freeze the rows
> Drag it to the right to freeze the columns
3) Insert any Image
This function lets you directly insert an image in a sheet using the URL of the image.
Put this syntax in the required cell:
=IMAGE(“google.com”)
This function lets you directly insert an image in a sheet using the URL of the image.
Put this syntax in the required cell:
=IMAGE(“google.com”)
4) Create a Drop-Down List
To make data entry free of error, make it easier for users to select from the option.
To make data entry free of error, make it easier for users to select from the option.
To do this, follow the instructions:
> Click on the cell you want to create the menu
> Click on the Data tab & select the data validation option
> Click on “Add Rule” & insert all the options
> Then click on the save button
> Click on the cell you want to create the menu
> Click on the Data tab & select the data validation option
> Click on “Add Rule” & insert all the options
> Then click on the save button
5) Extract the Unique Items
If you have a list with repeated names/inputs but you want only the list of unique items, then follow these steps:
> Select the cell where you want the list
> Then, use this formula:
=UNIQUE(Column row: Column row)
For example: =UNIQUE(A1:A10)
If you have a list with repeated names/inputs but you want only the list of unique items, then follow these steps:
> Select the cell where you want the list
> Then, use this formula:
=UNIQUE(Column row: Column row)
For example: =UNIQUE(A1:A10)
6) Correct Misspelled Word
For this select the data/row or column for which you want to run a spell check.
> Then click on the Tools tab and select the spelling option
> After it runs a spell check, it will show all the misspelled words.
For this select the data/row or column for which you want to run a spell check.
> Then click on the Tools tab and select the spelling option
> After it runs a spell check, it will show all the misspelled words.
7) Copy Google Sheets
To copy google sheets from one google sheet document to another, here’s what to do:
> Open the google sheet which you want to copy
> Then right-click on the sheet and click on ‘COPY TO’
To copy google sheets from one google sheet document to another, here’s what to do:
> Open the google sheet which you want to copy
> Then right-click on the sheet and click on ‘COPY TO’
And then you can select to either copy to a new sheet or to an existing one.
8) Zoom In And Zoom Out like Excel
Something we miss in google Sheets is the power to zoom in and zoom out like in Excel.
Something we miss in google Sheets is the power to zoom in and zoom out like in Excel.
However, here’s the hack to get it( When using chrome browser)
> Go to the top-right corner of the chrome browser
> Click on the ‘Chrome customize’ icon/ three dots
> Now you can choose the zoom level by using the +/- button
> Go to the top-right corner of the chrome browser
> Click on the ‘Chrome customize’ icon/ three dots
> Now you can choose the zoom level by using the +/- button
9) Insert Hyperlinks
This will help you create a hyperlink using a URL.
If you have a list of URLs and you want to link these URLs to a text, use this syntax:
=HYPERLINK(URL, LINK_LABEL)
This will help you create a hyperlink using a URL.
If you have a list of URLs and you want to link these URLs to a text, use this syntax:
=HYPERLINK(URL, LINK_LABEL)
10) Transposing Data
Here’s what you need to do:
> Select the cells you want to transpose
> Copy it by right-clicking & selecting the ‘COPY’ button
> Select the cell where you want to transpose
> Then right click & click the option “Paste special” & then on “Paste Transpose”
Here’s what you need to do:
> Select the cells you want to transpose
> Copy it by right-clicking & selecting the ‘COPY’ button
> Select the cell where you want to transpose
> Then right click & click the option “Paste special” & then on “Paste Transpose”
If you liked this thread:
- RT the first thread and share it with folks on Twitter.
- Follow @rajshamani for more such insightful threads.
Thanks for reading!
- RT the first thread and share it with folks on Twitter.
- Follow @rajshamani for more such insightful threads.
Thanks for reading!
Loading suggestions...