Changin number when adding rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When adding rows the automatic number colunm doesn't change automatically
why? Please help.
 
Yvonne,

Because the formula in that column isn't written to allow rows to be
inserted?

It would help if you would post the formula: the simplest formula that will
change automatically is

=ROW()

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

Pulling specific Data from one WS to another WS based upon 1 criteria 1
Need a Macro to Scroll to the left 4
Find if between dates 3
I receive "isref" when i do an autofill in a column in Excel 1
removing duplicates in a row 5
formula to search and find item sheet1 copy to sheet 2 1
change the colunm header back to letters? 2
Text to multiple worksheets? 1

Back
Top