Lesson 12 - Ranges (Borders)

Setting cell borders inside and outside a Range

In this lesson we learn how to set cell borders so you can visually highlight cells on your worksheets:

  • How to “step over” a called subroutine and why this can be useful to jump over code
  • How to set cell borders to without first selecting a range
  • The types of cell borders that you can use (including Continuous, Dot, Dash)
  • How to change the thickness of cell borders
  • How to set a border around the outside of a range
  • How to set the inside color of a range using RGB (red, green, blue)
  • What keyword to use to clear formatting in a range without clearing contents

Write your comments and feedback below

  • If you have questions or comments about this lesson, write it in the section below.
  • Alternatively you can email the instructor Victor at [email protected]

Complete and Continue  
Discussion

2 comments