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.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Edit a group of workbooks at the same time and you probably will find yourself trying to copy information from one of ...
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 MoreExcel includes a handy shortcut for entering data that is similar to whatever you entered in the cell above your entry ...
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.
Comments