override a cell

  • Thread starter Thread starter shlomop
  • Start date Start date
S

shlomop

The whole column A begin with SP, and I wont to add different number
on each row after the SP. how do I do that with out I should have to g
in to each cell
 
Hi
is there a specific logic which number has to be added in each row?
 
Shlomop,

If you type in SP1 into a cell, then click, hold and drag the fill handle
sown the column, Excel will autofill SP2, SP3, etc.....

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set default cell format while retaining overrides 3
search function 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Sorting by rows with differing numbers of cell entries 3
Help needed 0
Macro to sum doesn't work 2
Match Dates in Two Cells and Ignore subsequent Cells 1
Finding a sum by matching two cells with the same identifier 1

Back
Top