Google Sheets Follow
With Google Sheets, you can create and edit spreadsheets directly in your web browser-no special software is required. Multiple people can work simultaneously, you can see people's changes as they make them, and every change is saved automatically. Google Sheets is comparable to Microsoft Excel in many ways.
To create a new file, click Start a new spreadsheet.
If you have existing files, you can import and convert them to Sheets, including Microsoft file formats.
- Go to Drive.
- Click New File Upload.
- Choose the file you want to import from your computer to add it to Drive.
- In the Upload complete window, click Show file location.
- Right-click the file and select Open with Sheets.
Formatting
Select cells in your spreadsheet and then format them using the toolbar options.
Add rows, columns, and cells
- Select the row, column, or cell near where you want to add your new entry.
- Right-click the highlighted row, column, or cell -Insert - choose where to insert the new entry.
Delete cells: Select the cells, right-click and select Delete cells.
Move rows or columns: Select the row number or column letter and drag it to a new location.
To add a tab, at the bottom of your spreadsheet, click Add sheet to add another tab.
To delete or copy a sheet, click the down arrow on the sheet's tab. This also allows for the following sheet options.
To use a formula, type an equal sign (=) in a cell and type in the function you want to use. Note: You may see suggested formulas and ranges based on your data. A function help box will be visible throughout the editing process to provide you with a definition of the function and its syntax and an example for reference. If you need more information, click the "Learn more" link at the bottom of the help box to open a full article.
A full list of functions can be found here - https://support.google.com/docs/table/25273?hl=en#query=add
For more help with formulas, please see this tutorial - https://www.youtube.com/watch?v=J-YF5A-w54s
Collaboration is an important feature of using Google Sheets. You can share documents, spreadsheets, or presentations with individuals or large groups of people. You can share with people inside or outside your organization. People can make changes at the same time, and you can see changes as they happen. To start, select the file you want to share.
- Click Share
- Enter the email address or Google group you want to share with.
- To decide what role people will have on your file, select Viewer, Commenter, or Editor.
- Choose if to notify people (this will send an email notifying the group of the new permissions).
- Click Send or Share.
Comments
0 comments
Please sign in to leave a comment.