Dear Widman,

Thanks for your help.

It works out very well.

Kind Regards

Low

--
A36B58K641


"widman" wrote:


customize your menu bar to add the icon for paste values. (Right click menu
bar, customize, commands, edit - and drag the paste values icon to your
toolbar)
Then just copy and click the icon.

Of course it's always easier if you can have all the ones you want in one
column.

"Mr. Low" wrote:

Dear Sir,

May I know how to convert formulas to values under Excel 2002 and Excel 2007 ?
Is Copy and Paste Special is the only way ? Any keyboard short cut or
single button for this ?

Is there any short cut way of filling up the blank cells with the reference
just above it ?
<Usually I copy and paste reference by reference
Eg.

Before
AFD220
BLANK
BLANK
BLANK
AFD221
BLANK
BLANK
AFD222
BLANK
BLANK €¦.

After
AFD220
AFD220
AFD220
AFD220
AFD221
AFD221
AFD221
AFD222
AFD222
AFD222

Thanks

Low

--
A36B58K641