Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Filling a Cell.
Written by Allen Wyatt (last updated June 8, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
There may be times when you need to fill a cell with a particular character or group of characters. For instance, you may need to fill a cell with the characters " guess " (with the spaces) for the entire width of the cell. Excel allows you to do this very easily. It repeats the characters over and over again, regardless of the cell width. To utilize this feature, follow these steps:
Figure 1. The Alignment tab of the Format Cells dialog box.
Excel repeats whatever you typed in the cell, until the entire cell is filled. For instance, if you typed two characters, then those two characters are repeated over the width of the cell.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2761) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Filling a Cell.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Easily seeing where all the formulas are in your worksheet can be handy. Here are some ideas on different ways you can ...
Discover MoreHate to take your hands off the keyboard? Here are a couple of ways you can reject the mouse and still adjust the height ...
Discover MoreNeed to merge a bunch of cells together on a regular basis? You'll love the two macros in this tip which can make short ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-06-10 10:37:52
PJEF
I cannot get this to work at all. I am using Excel on an iMac. In the "format cell" dialog box, there is no "Text Direction" choice, just the angle degrees that you want the text to run. AND when I select "fill", no matter what choice I select, it either does nothing or it clears the cell.
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments