Google Sheets Beginners: Borders (07 & 08)

In this next part of our Google Sheets Beginners Youtube course, we take a look at borders. Borders can provide a huge boost to the readability of both your digital Google Sheet and your printed spreadsheets. Not only that, but careful use of border styles, weight and colour can help guide your reader to the most important bits of information on your spreadsheet.

These tutorials are for the Google Sheet or even spreadsheet beginner. I’ve broken the border tutorial down into two parts:

Google Sheets Border Basics

In this tutorial, I’ll cover,

  1. How to add borders to a range specifying what part of the range the border will be.
  2. Adding colour to your borders.
  3. Adding border thickness or dashes and dotted borders.
  4. Troubleshooting a few issues you might face when creating multiple border types.
Watch this video on YouTube.

A Borders Style and Usage Guide

In this tutorial, I’ll cover,
1. Fast workflow for styling borders in a larger “real” project.
2. Using borders to attract the user to important pieces of information.
3. Show common mistakes to watch out for in workflow.

Watch this video on YouTube.

Can you think of any other great ideas for using borders in Google Sheets? I love to hear them. Feel free to add your thoughts in the comments below.

Keep an eye out for more Google Sheets basics tutorials. You can even subscribe! Top right!

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Merging Text (5)

Google Sheets: Merging Text

New to Google Sheets and spreadsheets in general? Find out everything you need to know about merging cells inside a cell efficiently. Merging cells can really increase your design game.

In this tutorial, I’ll cover,
1. Merging Across rows.
2. Merging Across columns.
3. Merging mixed ranges.
4. Highlight some things to watch out for.
5. Go over a quick example of usage.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

Watch this video on YouTube.

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Formatting Text Inside Cell (4)

Google Sheets: Text Formatting

In this tutorial, I am going to show you some tricks on how to format text inside cells that most spreadsheet users have no idea about.

If you are new to Google Sheets or just spreadsheets in general, then this is for you. In this tutorial, I’ll cover:

In this tutorial, I’ll cover:

  1. Formatting selected text in a cell.
  2. Returning to new lines within a cell.
  3. Changing the colour of selected text in a cell.

Even knowing the basics can really give you the edge and save you a heap of time in the workplace. Check out the video below!

Watch this video on YouTube.

Google Sheets Shorts: Align and Wrap Text (2)

Google Sheets: Align and Wrap Text

If you a new to Google Sheets or spreadsheets in general, this short video is for you!

We’ll go over aligning text in cells vertically and horizontally. Then we’ll show you how to wrap long pieces of text so that they fit neatly in the cell.

Lastly, we will wrap things up with an example of how you might want to use align and wrap in your own project.

Oh yeah, there is a groan worth Dad-pun at the end. So brace yourself.

Watch this video on YouTube.

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

My live Google Form response in Google Sheets won’t update in another Sheet Tab that references them. What do I do?

Google Sheets – Intermediate, Arrays, Form Data

Picture this. You have set up your Google Sheet and attached your Google Form data to it so you might get a tab that looks a little something like this:

Form Response Tab Google Sheets

You probably don’t want to mess with this tab because the Form is still live.

Instead, you decide to create a new Google Sheet tab that you want to automatically transfer all the data into, including the current form response data and any new form responses you might get.

The Common Mistake

A common, though mistaken, approach to this is to do a cell-by-cell transfer of data. For example, we would grab the first data cell of our “Form responses 1” Sheet tab and in a new sheet tab cell we would write:

We would then drag that cell across to the right to cover all the columns. Then all the way down to the bottom of the page to cover the current responses and any new responses added.

That might look a little like this:

Cell-by-cell display of data from another Sheet Tab

The problem

This looks like it might work, right? Let’s test it out by adding in a new form response. For me, it will be the 6th response and will appear on row 7 of the ‘Form  Responses 1’ sheet tab.

Continue reading “My live Google Form response in Google Sheets won’t update in another Sheet Tab that references them. What do I do?”