Prev: How do I collapse a menu in Excel
Next: Auto filter on blank lines
From: Lucille on 28 Jan 2010 09:54
I have been told that if I highlight figures in a spreadsheet that I want to
change, type in the correct figure and press enter, all the figures should
change. This is not happening, is there something I am doing wrong?
From: Bernard Liengme on 28 Jan 2010 10:03
Try this:
Click on A1
While holding down CTRL , click on B2, C3, D4
Remove figure from CTRL
Type any number (23 for example) and press CTRL+ENTER
All you selected cells now have the number
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lucille" <Lucille(a)discussions.microsoft.com> wrote in message
news:A20C6FA5-0EA9-47B1-A29E-598E14BC6B3A(a)microsoft.com...
> I have been told that if I highlight figures in a spreadsheet that I want
> to
> change, type in the correct figure and press enter, all the figures should
> change. This is not happening, is there something I am doing wrong?

From: Jim Thomlinson on 28 Jan 2010 10:09
<Enter> will only change the value of the acitve cell. Ctrl + <Enter> will
change the value of all highlighted cells.
--
HTH...

Jim Thomlinson


"Lucille" wrote:

> I have been told that if I highlight figures in a spreadsheet that I want to
> change, type in the correct figure and press enter, all the figures should
> change. This is not happening, is there something I am doing wrong?
 | 
Pages: 1
Prev: How do I collapse a menu in Excel
Next: Auto filter on blank lines