Google is an easy, efficient way to store, organize, and analyze your data. Sheets is a tool that can be used very effectively when used properly. These tools will help you navigate your way through Sheets and will help you save time.
Inserting a Comment
There are three main ways to insert a comment into Google Spreadsheet.
1. Select the cells that you wish to leave a comment on. Click on the “Insert” tab in the upper left corner. Once the drop down menu opens on the “Insert” tab, select the option labeled “Comment.” Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.
2. Select the cells that you wish to leave a comment on. Right click inside the cells selected and click “Insert Comment.” Proceed to insert your comment and click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.
3.Select the cells that you wish to leave a comment on. On your keyboard press Ctrl + Alt + M to insert a comment. Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.
To insert a border on your spreadsheet, select the cells, click on the “Borders” symbol, and select the border you want to use. You can also change the color of the border and the border style once you click the “Borders” symbol.
Changing Formats of Numbers
Changing formats gives you different ways to present data.
Select the “Format” tab on the access bar, click “Number”, and select the option you want from the list. If the format you want is not present, click the “More Formats” option to choose more options or create your own format.
Copying Box into Multiple Rows/Columns
This a pretty easy tool to use. Place your cursor in the bottom right corner of the box you wish to copy, the cursor should become a small symbol resembling an addition sign. Left click and hold, then drag your cursor into the rows/columns you wish to copy it into.
If you are having trouble keeping your data organized, then freezing might be for you. Freezing rows or columns is an effective way to use headers on your sheets. The freeze bars are located on the perimeter of the cell to the left of the “A” tab and above the “1” tab.
Formula Continuation Tip
If you have a minimum of 2 cells with a formula you would like to continue, you can easily continue that formula without having to keep typing it out. Select the cells with the formula you want to continue the formula from. Then, click and hold on the bottom right corner of the highlighted cells and drag to the cells you wish to continue with the formula.
If you would like to learn more about Google Sheets, go to Cole Davis’ Blog. He has created another blog about sheets, Google Sheets: Basic Functions. If you have any questions over this content or Sheets, you can contact me via email at: firstname.lastname@example.org
Paul Chavez – Student
Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.