Become a Sheet Beast: Top Google Sheets Tips and Tricks (2024)

You can create a new google sheets by typing sheets.new in your browser.

By Pressing Control + Question Mark, you actually unlock the goldmine of shortcut keys. Cool, I know, but there is something even more interesting.

By pressing Alt + Question Mark, you can search anything google sheets has to offer, Like Freeze row and it will free the top row, meaning that I can move anywhere in the spreadsheet and it will keep showing the first row.

You can manually freeze a column or a row by going to top left corner of your sheet and dragging this gray bar like so. you can freeze as many rows and columns this way.

By Pressing Control + arrow keys you can quickly move between non empty cells in a sheet, add Shift button and you can make selections.
You can press shift + F11 To quickly add a new sheet.

To easily move between sheets you can press Alt + up or down arrow.

To clear formatting of a cell you can press Control + Backslash

You can copy the above cell with all the formatting by pressing Control + D and You can copy the content and formatting of the cell to left by pressing control + R.

By Pressing Control + Y, you can repeat the last action that you did.

To quickly insert a comment on a cell, you can press Control Alt M, or if you want to insert a note, you can press Shift +F2.

To copy the style or formatting of a cell to any other cell you can do that by selecting the cell whos formatting you want to copy and click on paint format and select that cell or cells whos formatting you want to change.

If you search google sheets formulas in google and click on the first link. It will take you to the page where all the formulas of google sheets exist.

Now if you have a bunch of numbers in a column, you can see their total, their average etc and google sheets will count the total cells for you also. really handy.

To view data clearly, you can use alternating colors, press Alt + Question mark and type alternating color, you can also select different color styles from the side panel.

If you want only a certain data to be entered in a column you can do that by inserting drop down menu. press Alt + Question mark, then type drop down menu and put in your options here. Now it will only allow you to select from the options you entered. you can quickly insert date in a cell by typing “=“ and “today“ and then press enter twice.

You can use filter to easily visualize your data. To create a filter select your your whole sheet or the columns you want to create filter for. then press Alt + Question Mark and type filters choose create a filter. Now you will see the filter icons alongside your headers and you can do all sorts of filtering now. This is so fun and easy, you can sort the data alphabetically or you can uncheck certain items so that they don't show up in the sheet.

If you have any data that has duplicates or uneven spaces, you can easily remove that. Go to data, then data cleanup. you can choose remove duplicates and it will remove any duplicates or you can click on trim white spaces to get rid of any spaces. The best part is that you can click on data clean up suggestions and choose if you want to ignore or take action on any specific thing.

If you have somehow messed up your google sheet and you want to go back to a previous version of sheets you can do that by clicking on version history. with version history you can see the changes that have happened in the sheets over time.

Now thank you for reading to the end if you want to see everything in action, here is a YouTube Video that explains all of these tips.

Thank You very much for reading,