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

To stop the incrementing of P2 hold down the control key as you drage the
cells down (I assume you are dragging the cells but it is not entirely clear
from your post).
--
HTH...

Jim Thomlinson


"Mr. Low" wrote:

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

The bottom right corner of the cursor is known as the Fill Handle - it
acts like Edit | Fill in that you can drag it down to B12 and the data
will be "filled", or you can double-click it if you have data in
adjacent columns and it will be filled down to the bottom of the
(contiguous) data. If the data is a constant with a number at the end,
then Excel will increment this number as if you had used Edit | Fill -
use of this facility is not the same as Copy/Paste.

To avoid it incrementing then use Copy/Paste as you describe.

Pete

On Aug 3, 9:54 pm, Mr. Low wrote:
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

Right-click and drag then release and "Copy Cells"


Gord Dibben MS Excel MVP

On Fri, 03 Aug 2007 14:27:05 -0700, Pete_UK wrote:

The bottom right corner of the cursor is known as the Fill Handle - it
acts like Edit | Fill in that you can drag it down to B12 and the data
will be "filled", or you can double-click it if you have data in
adjacent columns and it will be filled down to the bottom of the
(contiguous) data. If the data is a constant with a number at the end,
then Excel will increment this number as if you had used Edit | Fill -
use of this facility is not the same as Copy/Paste.

To avoid it incrementing then use Copy/Paste as you describe.

Pete

On Aug 3, 9:54 pm, Mr. Low wrote:
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