naming ranges

Teryl · Feb 27th, 2002, 09:16 AM

I need to divide a large group of cells by 173.3. Is there a way to maybe name the group and then divide each individual cell by 173.3? Each cell contains a different number (164 rows, columns A:J) I don't want to individually select each cell and insert the divisor. Please help! Thanks

Juan Pablo González · Feb 27th, 2002, 09:18 AM

Easy. Put 173.3 in an empty cell, copy it, select the cells you want to modify (Divide), go to Edit, Paste Special, and select "Divide". Click ok, and you're set.

Feb 27th, 2002, 09:18 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Easy. Put 173.3 in an empty cell, copy it, select the cells you want to modify (Divide), go to Edit, Paste Special, and select "Divide". Click ok, and you're set. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 09:16 AM	#1
Teryl New Member Join Date: Feb 2002 Posts: 19	I need to divide a large group of cells by 173.3. Is there a way to maybe name the group and then divide each individual cell by 173.3? Each cell contains a different number (164 rows, columns A:J) I don't want to individually select each cell and insert the divisor. Please help! Thanks