Stop number increase

RoydenC

Board Regular
Joined
Jul 24, 2002
Messages
54
I have cells coded JW11, JP53 etc which indicate which specification to follow in given circumstances. I wish to copy these to other cells- but the numbers ( when copy /"swiping" these to adjacent cells) increase - to JW12 and JP54 - and onwards...respectively. I want format cells to have this increment occur, or not occur in various places in the sheet.
How do I achieve this?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Not entirely sure what you're asking but check out in the Excel help file about the difference between relative and absolute references.
 

RoydenC

Board Regular
Joined
Jul 24, 2002
Messages
54
OK - please excuse the lack of clarity.
I have a cell with JW12 in it - this is not a cell number but text in the cell. when I use the "fill handle" - the black square at bottom right of the cell to copy this cell to adjacent cells - the text will increase to JW13 and then JW14 in the next cell copied to. etc etc. This is presumably a formatting option. I want to copy the information using the fill handle - and NOT have the increase ( in certain cases - ie for JW14 to repeat itself as JW14 in all the cells coped to ) and in other cases I DO want to have the increase.
My question is how do I control this formatting option?
My apologies in advance if this is very elementary!. I am sure it is. I have perhaps some embarrassing gaping holes in my Excel education! I hope you dont mind the indulgence - but I dont know the answer - and nobody around here does either!!
Thanks in advance.
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Hold the Ctrl key whilst you're dragging down if you don't want the increase
This message was edited by Chris Chattin on 2002-11-05 06:15
 

Forum statistics

Threads
1,148,160
Messages
5,745,122
Members
423,927
Latest member
Pra56

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top