Excel 2016 from Scratch Exercise
Create Text Boxes
An Excel tutorial by Peter Kalmstrom
In this demo in the Excel 2016 from Scratch series, Peter
Kalmstrom explains how to use the Excel tools to create
text boxes (or drawing boxes) and how to apply different
formatting to these text boxes.
If you want to try the exercise yourself, please
download the Excel file Peter uses in the demo!
This is what Peter shows in the demo below:
Peter uses Excel 2016 for his demo, but the Excel basics
are the same for earlier versions of Excel.
- How to create a text box using the Text Box
tool under the Shapes button.
- How to change the font and size of the text
by selecting the entire text box or selecting the text.
- How to change the alignment of the text in
the text boxes by selecting the entire text box and
use the ribbon buttons for alignment.
- How to change the color of the text in the
text boxes by using the Font Color tool and make it
bold and italic by selecting the entire text box and
using the bold and italic buttons.
(If you are observant, you will notice that the text
in one of the text boxes never turns italic even if
Peter says so.)
- How to change the background color of the
text box by using the Shape Fill tool.
- How to add a shadow by using the Shape Effects
tool and change effects by Shadow Options.
- How to change the shape of the text box by
using the Edit Shape tool.