+ Reply to Thread
Results 1 to 3 of 3

Change the beginning of the numbering on the left column

  1. #1
    Registered User
    Join Date
    05-03-2018
    Location
    UK
    MS-Off Ver
    2007
    Posts
    2

    Question Change the beginning of the numbering on the left column

    Is it possible to change the left numbering column? at row 6 I would like it to begin at 1.

    I know it is a strange request but it would help me with my template each time i delete a row.

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Change the beginning of the numbering on the left column

    now it is not possible.. what would the numbers for the first 5 rows be then?

    but is a common practice to to have formula's that say something like Row()-5 to reference the first row of your template in a formula when you are in line 6 of your spreadsheet.

  3. #3
    Registered User
    Join Date
    05-03-2018
    Location
    UK
    MS-Off Ver
    2007
    Posts
    2

    Re: Change the beginning of the numbering on the left column

    Thanks! that works a treat!!
    Bedankt

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 06-26-2017, 09:04 PM
  2. Change numbering on column from topic to in sequence
    By Shamz41 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-06-2014, 02:24 PM
  3. [SOLVED] Modify code to remove LEFT or beginning
    By bentod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2014, 02:00 PM
  4. Replies: 2
    Last Post: 06-27-2014, 06:40 AM
  5. Left function to include text beginning with 0
    By NickEnglish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2012, 07:35 AM
  6. Replies: 2
    Last Post: 07-19-2005, 11:05 AM
  7. Replies: 1
    Last Post: 07-04-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1