Home Screenshots 10 Languages Why use it?

Excel tip: Entering the same value or formula in many cells

Date: 5 september 2001

Select the cells you wish to fill with the same data.
Type the formula of value and press CTRL+ENTER.

« back

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.

	Home Screenshots 10 Languages Why use it? Download Pricing Contact Us

	Download Download ASAP Utilities (recommended) License Agreement (EULA) Upgrade to the latest version Version history Compare version changes Alternative download options System requirements Home&Charity Edition required upgrade Buy Order your license(s) Payment Methods Pricing and volume discounts Help with the ordering system \| Shopper FAQ Sales, upgrades and Refunds Policy Do you need a license or is it free? License Agreement (EULA) What is it? What is ASAP Utilities Screenshots of ASAP Utilities 10 Languages to choose from The primary goals of ASAP Utilities Mission Statement and Company Values About the author of ASAP Utilities System requirements Examples of how to use ASAP Utilities Why use it? Top reasons to use ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Features Descriptions of all tools in ASAP Utilities Added worksheet functions Fully expanded list of all menu items A few example screenshots of ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities Today's featured time saving tool (March 21st) Reviews Testimonials, feedback from users Press & Media Reviews Clients, who uses ASAP Utilities? User Guide Download the PDF User Guide How to install ASAP Utilities Detailed step by step installation How to uninstall ASAP Utilities Quick Start: Practical Tricks to Save Hours in Excel with ASAP Utilities News Latest news Today's featured time saving tool (March 21st) Press & media reviews RSS Feed Receive our Newsletter Unsubscribe from our Mailing List Tips on our blog Excel tips Excel tips Excel keyboard shortcuts overview Headlines from the best Excel weblogs Links to interesting websites Recommended Excel books Excel version screenshots Support 1. FAQ: Questions and answers 2. Version history 3. Get Support: How to Provide Details 4. Sitemap 5. Help with the ordering system \| Shopper FAQ 6. Contact us EN-US Descriptions of all tools in ASAP Utilities: 1. English 2. 中文(简体) (Chinese (Simplified)) 3. Deutsch (German) 4. Español (Spanish) 5. Français (French) 6. Italiano (Italian) 7. 日本語 (Japanese) 8. Nederlands (Dutch) 9. Português do Brasil (Portuguese (Brazil)) 10. Русский (Russian)
	Home Excel tipsEntering the same value or formula in many cells
	Excel tip: Entering the same value or formula in many cells Date: 5 september 2001 Select the cells you wish to fill with the same data. Type the formula of value and press CTRL+ENTER. « back
	Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us ©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands 🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London! For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.