Excel Increment Based on FormattingExcel: highlight groupings of data differently based on a cell's valueHow...

Is it appropriate to ask a former professor to order a library book for me through ILL?

Interpretation of linear regression interaction term plot

Can I challenge the interviewer to give me a proper technical feedback?

How does a sound wave propagate?

The (Easy) Road to Code

Exempt portion of equation line from aligning?

Did Amazon pay $0 in taxes last year?

Create chunks from an array

Why do we say 'Pairwise Disjoint', rather than 'Disjoint'?

A running toilet that stops itself

Why does a car's steering wheel get lighter with increasing speed

Is this Paypal Github SDK reference really a dangerous site?

Having the player face themselves after the mid-game

Is divide-by-zero a security vulnerability?

Short SF story. Females use stingers to implant eggs in yearfathers

PTIJ: Sport in the Torah

Why aren't there more Gauls like Obelix?

I've given my players a lot of magic items. Is it reasonable for me to give them harder encounters?

Professor forcing me to attend a conference, I can't afford even with 50% funding

How to distinguish easily different soldier of ww2?

Inorganic chemistry handbook with reaction lists

Has a sovereign Communist government ever run, and conceded loss, on a fair election?

3.5% Interest Student Loan or use all of my savings on Tuition?

How spaceships determine each other's mass in space?



Excel Increment Based on Formatting


Excel: highlight groupings of data differently based on a cell's valueHow to sort list-style numbers in Excel?Word table copy/drag formula like ExcelComplex Excel formatting of SQL-based dataInsert columns, within a range, based on cell referenceExcel: combine strings based on duplicate keysFormatting “spills over” to next rows: is this a bug in Excel 2013?Create hyperlink to folder if folder with same name exists (Excel)How do I select only hidden rows in excel?Excel - Compare the value of two fields and change color depending on results













0















I am currently using Excel to write test plans with sections and test cases, where there are section numbers, sub-section number, test case numbers, and test case steps. I was wondering if there was a way to auto increment section and step number in the column based on the row's formatting.



The use case is the ability to copy the existing rows and inserting them in between or after the existing rows and to have the section and step numbers automatically adjust.



Is this possible within Excel relatively simply, or would it require VBA scripting or using an entirely new tool/add-on?



Example Test Plan Formatting










share|improve this question









New contributor




loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I am currently using Excel to write test plans with sections and test cases, where there are section numbers, sub-section number, test case numbers, and test case steps. I was wondering if there was a way to auto increment section and step number in the column based on the row's formatting.



    The use case is the ability to copy the existing rows and inserting them in between or after the existing rows and to have the section and step numbers automatically adjust.



    Is this possible within Excel relatively simply, or would it require VBA scripting or using an entirely new tool/add-on?



    Example Test Plan Formatting










    share|improve this question









    New contributor




    loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I am currently using Excel to write test plans with sections and test cases, where there are section numbers, sub-section number, test case numbers, and test case steps. I was wondering if there was a way to auto increment section and step number in the column based on the row's formatting.



      The use case is the ability to copy the existing rows and inserting them in between or after the existing rows and to have the section and step numbers automatically adjust.



      Is this possible within Excel relatively simply, or would it require VBA scripting or using an entirely new tool/add-on?



      Example Test Plan Formatting










      share|improve this question









      New contributor




      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I am currently using Excel to write test plans with sections and test cases, where there are section numbers, sub-section number, test case numbers, and test case steps. I was wondering if there was a way to auto increment section and step number in the column based on the row's formatting.



      The use case is the ability to copy the existing rows and inserting them in between or after the existing rows and to have the section and step numbers automatically adjust.



      Is this possible within Excel relatively simply, or would it require VBA scripting or using an entirely new tool/add-on?



      Example Test Plan Formatting







      microsoft-excel formatting






      share|improve this question









      New contributor




      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 9 hours ago









      cybernetic.nomad

      2,273417




      2,273417






      New contributor




      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 9 hours ago









      loiuytre35loiuytre35

      1




      1




      New contributor




      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      loiuytre35 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          loiuytre35 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1412524%2fexcel-increment-based-on-formatting%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          loiuytre35 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          loiuytre35 is a new contributor. Be nice, and check out our Code of Conduct.













          loiuytre35 is a new contributor. Be nice, and check out our Code of Conduct.












          loiuytre35 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1412524%2fexcel-increment-based-on-formatting%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

          Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

          Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...