Excel FormattingLesson 25Free preview

Excel Format Borders

This lesson is part of Excel · All levels

Summary

The worksheet's built-in line is just a screen view so it often doesn't go with print, and that's where the Borders format is needed. You can choose the outer line, the inner line, or all the lines, even draw your own line with Draw Border. Format > Formats of Cells > Border gives full control over the shape and thickness of the line.

Key points

The built-in gridlines are not part of the data and are generally not included in print.
Borders provide a fixed line that always appears and is printed
Common options: All Borders, Outside Borders, Bottom Border
Cells > Border format set the shape, thickness, and position of the line

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.