As I am sure you are all aware, text boxes are great for adding comments and other information to your worksheets. There is also the flexibility of moving them around and keeping them from printing if you like. There are, however, some instances where text boxes just don’t do the job for you.
Suppose you want to enter two or more columns of data into a text box but find it almost impossible to have everything line up properly? I know it can be maddening – you try to add extra spaces to line it up only to find that when you print your worksheet, the data is all over the place. And heaven help you if you have to change something!
Below is another option that will give you some of the benefits of a text box, but much more control over the display of your data.
- Enter your data in another part of your workbook or even in another workbook.
- Format your text to your liking.
- Instead of displaying it in a text box, take a picture of the range of cells.
Taking a picture allows you to paste the range as a picture in your workbook or even in another application if you like.
- Select the range of cells you want to use.
- Click CTRL + C or Edit | Copy.
- Select the cell where you would like to paste your picture.
- On the Home tab, click the small arrow on the bottom of the Paste tool.
- A list of options will appear.
- Point to the As Picture command and select either Paste Picture Link to create an image of those cells that will update as the cells change or Paste Picture to paste a static image.