Top 9 Google Sheets Tips and Tricks to Use It like a Pro
3. How to create a graph in Google Sheets
Data can be difficult to interpret, which is why we use graphs. Google Sheets comes with many different types of graphics. Before choosing one, make sure your data is ready. Select all the cells you want to graph and click on Graphs under Insert.
You should now see a default bar graph with a few options on the right. You can change the type of chart from bar to pie or whatever, color, select cells, add title and legend, and more here.
I suggest you use dummy data and play around until you realize it. Creating charts and diagrams is not that difficult anyway.
4. How to wrap text in Google Sheets
You write a long string of text, and it spills over into the next cell, blocks the value there, or it just disappears into the cell wall. Select the cell and click Text Wrapping under Format. This is where you choose the Wrap option.
Selecting the Overflow option will allow the text to continue in the next cell while Clip will cut it short, as we saw in the screenshot above.
5. How to add a column in Google Sheets
Google Sheet can easily perform mathematical calculations. The addition is a formula that most people often use. Select the cells of the column or row you want to total and select the Sum option under the math icon.
Have you noticed all the other formulas available on site? Google Sheets can be a very good calculator.
6. How to add columns and rows in Google Sheets
When you are managing a large amount of data on a single sheet, simply moving it around to add a single row or column is not a good idea. Fortunately, there is a simple way. Just select the row or column where you need a new empty row / column, then select the Insert 1 option above or below.
You should see the empty line now. The index number / alphabet will automatically change on the sheet.
You can also use the same method to add columns.
7. How to lock cells in Google Sheets
Locking a cell will prevent accidental changes. Do not confuse it with a security measure. People can still take a screenshot, print or even copy and paste the contents of the cell.
Select the cells you want to lock and select Protected sheets and ranges under Data.
You can not only lock cells here, but also the entire sheet. Enter a description that will make it easier to recognize locked cells in the future in case you have more than one. Select Set permissions when you're done. You can now select who can access locked cells.
8. How to create a drop-down list in Google Sheets
Drop-down lists save a lot of space, making it easier to select values and fill out forms or use variables. Select the cell in which you want to create a drop-down list and click Data validation under Data.
You can now choose the criteria of the cell in question. For example, you can create a list of dates, numbers, names, check boxes, or items. You can then choose a range and determine what happens when invalid data is entered.
I have selected a number between 10 and 100. So when I enter 5 in this particular cell, Google Sheets displays a red mark to indicate an error.
Creating a list with multiple optional values will insert a down arrow to signify the drop-down list.
9. How to label the legend in Google Sheets
You can easily add text and format captions to Google Sheets. The process is simple and easy to make your data easily identifiable, especially if you share the sheet with several other people.
Spread it well
Google Sheets is powerful, versatile, and free for life with no strings attached. The fact that it is available on all platforms and works directly from a browser makes it even more popular. Share your tips and tricks with us in the comments section below.
Then: Working with Google Sheets all the time? Here are some of the Google Sheets models to save time and increase productivity.