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,
- How to add borders to a range specifying what part of the range the border will be.
- Adding colour to your borders.
- Adding border thickness or dashes and dotted borders.
- Troubleshooting a few issues you might face when creating multiple border types.
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.
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!
~Yagi
