insert ribbon

Text boxes in Excel – How and when to use them with Examples

Insert Text Box into Excel

If you are having trouble fitting text into a particular cell, or if you want a cleaner, easier method to show larger pieces of text, inserting a text box into your spreadsheet is a good solution.  In our post about using text boxes in spreadsheets, we see how many steps there are to inserting text if you do not use a text box.  The steps for inserting text using a text box are simple.

Click on the Insert Ribbon

insert ribbon 

and then click on Text Box.

insert text box

In the editing window, click where you want the upper left hand corner of the box.  While holding down the left button, drag down and to the right until the box is the size and shape you would like.  You are now ready to type as the cursor is already in the box waiting for you.

You can style the text by right clicking on the text the same way in which you would format other text.  In order to make the text box stand out, you can also right-click on the border of the box to change the weight of the border, the color, and the fill of the background.

style text box 2

Disclosure: This is an independently owned website that, at times, receives compensation from the companies whose products are mentioned. Each product is tested by Prolific Oaktree and any opinions expressed here are our own.

Acrobat – How to use letterhead on different pages

I was recently creating a pdf document that required electronic letterhead to be applied to multiple pages.  Acrobat Pro has this ability, but in a limited implementation.  As the watermark (aka letterhead in this case) function stands in Acrobat Pro 11, it can be only applied to one page or a range of pages at a time.  

This work well in most cases.  However, I needed it to be applied to multiple pages that were not in a range.  This cannot be done in a clean and easy manner.   However, there are several workarounds that can help you to solve this problem.

  • Use the insert background image function.  Next to the insert watermark function is the ability to insert a background image.  As far as I can tell, this is the same process as the watermark with the same options.  Therefore, if you need a watermark on page 2 and 10, you can create page 2 as a watermark and page 10 as a background image.
  • Put the pages in a row that need watermarks.  Go to the page thumbnail view, drag and drop them in the order that you need, apply the watermark, then put the pages back into the original order.
  • Use the watermark function multiple times.  This may be the easiest option.  The only downside may be that you feel less victorious and creative for coming up with a crafty work around.  All you do is insert a water mark on the first page or range where you need it.  Then, repeat on the next page or range.  Lather, rinse, repeat.