Dear Sir,

I need to copy Cell B1: C1 downwards until B12:C12 by clicking the bottom
right corner of cell C2 after it has been pasted.

However I noticed that €œP2€� in column B begins to increase in a series
instead of maintain as €œP2€� up to cell B12. The same thing happen to date,
month values if it in in the column

This feature is useful for certain purpose at work , but I think it is more
proper to make it functional under series fill f option instead of copying
and pasting function.

A B C
0430746001 P2 BILLED
0430753001 P2 BILLED
0430753002 P3 BILLED
0430753003 P4 BILLED
0430753004 P5 BILLED
0430753005 P6 BILLED
0430753006 P7 BILLED
0430753007 P8 BILLED
0430753008 P9 BILLED
0430753009 P10 BILLED
0430753010 P11 BILLED
0430753011 P12 BILLED



May I know if there is a way to set the worksheet for it not to show
incremental values for alphanumeric , date, time and month/year references
during pasting ?

Currently the only way for me is to copy the original cells and highlight
the entire block to paste instead of clicking at the bottom right corner of
the cell of the source data


Thanks

Low

--
A36B58K641