Embedded Files
4.3: Working with Sheets, Rows & Columns in Google Sheets
4.3: Working with Sheets, Rows & Columns in Google Sheets
4.1 - Introduction to Google Spreadsheets
4.2 - Create, Edit & Format a Spreadsheet
4.3 - Working with Sheets, Rows & Columns
4.4 - Charts in Spreadsheets
4.5 - Activity: Your Class Schedule
4.6 - Activity: Statement of Income
4.7 - Activity: Salary Comparison
4.8 - Activity: Conditional Formatting & Sorting
4.9 - Activity: Functions
Copy, Re-order & Delete SheetsYou can make a duplicate copy of any sheet in a spreadsheet. That copy can be made within the same spreadsheet or into another, separate spreadsheet.Here's how to copy a sheet to another spreadsheet:At the bottom of a spreadsheet, click the down arrow next to the sheet name.
From the menu, click Copy to...
Choose the destination spreadsheet from the list.
Click Select.
The sheet you copy will be duplicated into the destination spreadsheet and positioned as its first sheet. If there's already an existing sheet with the same name, the copied sheet will be named "Copy of sheetname."
To copy one sheet within a spreadsheet, follow these steps:
Click the down arrow next to the sheet name.
From the menu, select Duplicate.
A duplicate sheet (which contains the exact formatting) will appear in a new tab beside the original sheet. It's labeled "Copy of Sheet".
Re-order sheets within a spreadsheet.
If you're working on a spreadsheet that contains more than one sheet, you can change the order of these sheets. Go to the sheet that you'd like to move, and click the down arrow. From the menu, select Move right or Move left. You can also drag and drop sheets by clicking and dragging a sheet tab until it is in the location you'd like.
To delete a single sheet from a spreadsheet, first go to the sheet you'd like to remove. Click the down arrow on the sheet tab, and select Delete from the menu. A warning dialog will appear. If you'd like to delete the sheet, click OK.
Add and Delete Rows & Columns
To add a row or column to a spreadsheet, right-click on the gray area containing the column letter or the row number. Select the action that you'd like to complete. For example, to insert a blank column to the left of the column you selected, you'd select Insert 1 left from the drop-down menu. To delete a row or column, select Delete row or Delete column from the drop-down menu.
If you'd like to insert multiple rows or columns, highlight the number of columns or rows you wish to insert. Then, right click the column or row header, and select "Insert N..." For example, if you highlight five rows, right click the row header, and select Insert 5 above or Insert 5 below.
Move Rows & Columns
You can move a row or column by dragging-and-dropping it to a new location. Or, you can follow these steps:
Select the row(s) or column(s) you'd like to move.
Go to the Edit menu.
Selecting from the following options:
Move row up
Move row down
Move column right
Move column left
Your row(s) or column(s) will move to the selected location.
Here's how to move a selection of cells:
Select the cell(s) you'd like to copy and move.
Point your cursor to the top of the selected cell(s). The pointer turns into a hand.
Drag the data to its new location, and release the mouse to drop it there.
Activity: Explore other formatting options with sheets, rows & columns.
Filter Your Data
The filter feature in Google Sheets makes it easier to analyze and view your data by hiding the data that you temporarily want to take out of view. When you want all of your data to be visible again, all you have to do is disable the filter.
Activity: Explore how to sort and filter your data in a spreadsheet.
Conditional Formatting
By setting text and background colors with rules, you can create styles that offer a visual summary of complex or changing data.
Activity: Explore how to use conditional formatting
Google Apps 101 by Kurt Wismer is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Page updated
Google Sites
Report abuse