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: Entering Info into Multiple Cells.
Written by Allen Wyatt (last updated May 25, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
It is not unusual to enter the same information in multiple cells in Excel. If you have such a need, you might want to try this little gem:
Presto! Every cell you selected contains the same information.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2094) 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: Entering Info into Multiple Cells.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Have you ever copied information from one worksheet to another, only to have the information you paste not look the way ...
Discover MoreWhen you are copying a cell from one place to another (perhaps even to a different worksheet), you may not want to copy ...
Discover MoreCopying formulas from one cell to another is quite intuitive in Excel—unless you want the copied formulas to follow ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-05-25 05:26:28
Govind Sookdeo
How can I format cells to count down by date and notify me using various colour coding?
For example, I have a document that is valid for a year, so the cell is in green for validity, 2 months prior to expiry, it shows up yellow letting me know the expiry date is upcoming and a month before the actual expiry date it signals red with an alert.
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 © 2024 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