Charts in Google Sheet

Looking for ways to visualize your data? Google Sheets can create awesome charts and graphs. Open a Google Sheet, add some data, and EXPLORE!

Google Sheets Templates

I will be the first to say that I LOVE spreadsheets. You can just do so much with them, and I just love graphs and charts (I know, kind of geeky). Google just made it even easier to use charts and set colors. Check out below and start exploring the style templates in Google Sheets.

Style Templates:

1. Open a Google Spreadsheet.

2. Enter in some data for a chart or graph.

3. Click “Format”.

4. Click “Template”.

5. On the right side, you will see a list of default templates. You can choose one of these. 

6. You can also click “Customize”. 

7. You can set font, chart background, and data range colors. Click “Done” to save this template.

Here is a Video Walkthrough of these steps as well.

If you want these directions in a Document, Click HERE!

Alternating Row Colors in Sheets

One of my favorite Google tools is Sheets. I use it for much more than just data spreadsheets. There are many tweaks that make Sheets extra cool. Conditional formatting, charts, cell formatting, and more. One of the things that is easy to do but can be labor intensive is alternating row colors for a whole sheet. The good news is that there is a quick and easy way to do this with just a couple of click! Follow the steps below to alternate colors for rows in an entire spreadsheet.

1. In Google Sheets, click on “Format” and then click on “Alternating Colors”.

2. You can select a range in the “Apply to range” field if you only want part of the sheet to have this formatting or leave it as the whole spreadsheet.

3. If your sheet has a header or footer select them in the options to make them bolder by default.

4. You can use the default color options if they work for you, or you can make custom color options below.

5. Click “Done” when finished!

6. If you change your mind you can click “Remove alternating colors”.

  

---

Open up a Google Sheets and give it a try!

If you want these steps in a Document click Here!

Rotate Text in Google Sheets

Whoa! 

It is FINALLY here! 

The elusive Rotating Text in Google Sheets cells! Many of us have been waiting a long time for this. It is finally here! Follow the steps below to see how to rotate text in Google Sheets cells!

Rotate Text in Google Sheets

1. Type text in a cell.
2. Click on Format, then “Text rotation” and choose how you want to rotate.

Here are the Text Rotation options:

None: No rotation
Tilt Up:
Tilt Down:
Stack Vertically:
Rotate Up:
Rotate Down:
Degrees:

Now start editing all that text you have been begging to rotate!

If you want these steps in a Document click HERE!

Remove Unused Rows and Columns

I will admit it, Google Sheets is one of my favorite Google tools. I use it for many things: data sheets, creating charts, making organized tables, reordering text lists by name, math assessments, and many other things many use Documents to do. One of the things that is most over looked is that the overall size of a Sheet is editable. Many users leave all those pesky unused cells lingering and this makes it far too easy to get lost in a sheet by accidently scrolling through empty rows and columns. By removing those unused cells, Sheets can be managed and used in ways not thought of before (almost like a standard document) with defined edges. Check out the easy steps below to get rid of all those unwanted empty cells.

Remove Unused Rows and Columns

1. Open or create a Google Sheet.
2. Locate the cells you no longer want (the unused rows and columns after all your work).
3. Remove these unused cells with the following steps:

Removing Unused Rows:

1. Click to the first row you want to remove.
2. Hold Command+Shift+(down arrow) on Mac or Ctrl+Shift+(down arrow) on PC.
3. Right Click on one of the row header numbers that is selected.
4. Choose Delete Rows (numbers).

Removing Unused Columns:

1. Click to the first column you want to remove.
2. Hold Command+Shift+(right arrow) on Mac or Ctrl+Shift+(right arrow) on PC.
3. Right Click on one of the column header letters that is selected.
4. Choose Delete Columns (letters).

Now your Google Sheet is the exact size you want and there is no getting lost in the unused columns and rows. I do this on every Google Sheet I use as it makes navigating the document much easier.

Want these steps in a Document? Click Here!