Today I was asked how to reorder sheets from within a Google Spreadsheet. Google Spreadsheets is one of my favorite collaboration tools. It provides the capabilities for assigning different sheets to individual students or a collaborative group. Sheets can become out of order when collaborators use one spreadsheet. No worries! It is easy to drag the sheet into an alpha or numerical order. Just click down on the sheets tab and drag to the right or left to reorder sheets.
In the Google Help Forums, I spotted the following question. “If there was a tool for ungrouping and grouping shared Google Calendars?” Naturally, my reply was you can group shared calendars by checking them off individually. However, there is a tool for users to ungroup all at once by using the following steps.
- Open Google Calendar
- Click Option Settings (3 vertical dots) for the Calendar to leave open
- Select “Display this Only”
I suggested to the user about grouping calendars together and embedding into a New Google Site. My idea would provide a simple method for viewing several team member calendars at once.
You may find the following Google Help Center resources beneficial:
It always amazes me when I hear someone say, “Something is wrong with this program!” “My shape, image, & text keep disappearing!” I always enjoy the look of amazement when restoring the item by moving an image through the layer levels. Layers allow users to move shapes, images or texts backwards and forwards through the layers.
Directions for Ordering Layers
- Click Shape to Select (blue box appears around image)
- Click Arrange in Toolbar
- Select Order
- Click one of the following:
- Bring to Front
- Bring Forward
- Send Backward
- Send to Back
One of the questions I often hear is, “How can students annotate math notes without a whiteboard?” My answer is, “When using Google APPS it’s not a problem!” There is a hidden gem called Google Keep housed in Docs, Slides, Drawings, and Sheets. Google Keep provides a whiteboard where students can draw and write fluidly with one finger or a stylus. When the student finishes white-boarding all they have to do is drag the image onto the file. The Keep image allows the student to provide supporting details.
Open Keep Whiteboard
- Click Open in New Tab Icon
- Select Pencil Icon to Open New Drawing
Annotate with Color
- Open Keep Drawing
- Double Click a Pen
- Select Color and Pen Tip Size
- Start Drawing
Drag Image onto a Google File
- Open Google Docs, Drawings, Slides or Sheets
- Click Keep Icon
- Located on Right-side
- Drag Keep Image onto file
The artist within me absolutely enjoys timesaving design tools found within Google Slides, and Drawings. Aligning multiple objects or images on a page is quick and easy. In a matter of seconds an image, shape or text may be centered both horizontally and vertically. If gaining back time in your day is important then trying this tip just may be helpful to you.
Arrange Tool Directions
- Open a Google Drawing or Google Slide
- Click Image (blue square appears)
- In toolbar Click Arrange
- Select Center on page
- Select & Group Objects (blue square appears)
- Click Arrange
- Select Align