• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • paste values from single cell to merged cell in excel

    paste values from single cell to merged cell in excel

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning
    • Date December 3, 2012
    • Comments 9 comments

    paste values from single cell to merged cell in excel, merged cells causing lots of problems in copy paste right? How many times you needed to copy from single cells to a merged cells and you had to do it one by one ??


     

     

    I faced this problem in my bar chart sheet (Create Gantt Chart and cash flow using excel with sample file), Therefore i searched and found a Excel Formula to Paste Values from single cell to merged cells  and AutoFit Merged Cells in Excel in very simple steps:

    Excel merged cells
    Excel merged cells

    As per the above figure, we have two columns and we want to copy from the column which contains A,B,C…. to the column which contains 1,2,3,…, Lets see how to do it.


    1- Use my secret formula to tell the excel i want to get the information from column A to column E:

    Select all values in the column E and then type this formula =INDEX($A$1:$A$7,COUNTA(E$1:E1)) then CTRL + Enter , it is important to type control + enter after you type the formula to apply the same formula to all selected cells, see the figure below:

    Merge Cells Excel 2010
    Merge Cells Excel 2010

    2- Now check the result

    the result of our formula will be Error message 🙂 ha ha ha , do not worry we still working, you will receive the following error message circular reference warning, just click ok , see the figure below:

    Shortcut Copy Paste Values
    Shortcut Copy Paste Values

    3- fix excel error message:

    we will tell the excel, common Mr. Microsoft excel we are too lazy to copy paste one by one all this values from single cell to merged cell (imagine if you have hundred’s of cells), Please let us use the circular reference to solve this problem. from file tap —— click option—— then from formula tap———- click enable iterative calculation—— then OK , see figures below.

    Excel options
    Excel options
    Excel options
    Excel options

    4- See the correct result and download the sample sheet:

    After we fixed the error message now the sheet will be working correctly and if you changed any value in column A it will be changed automatically in column E , see the figure below and download the sample sheet.

    Excel 2010
    Excel 2010

    Download the sample excel sheet to paste values from single cell to merged cell in excel

    paste values from single cell to merged cell in excel


    Tag:copy paste, excel, excel template, featured, free online project management, merged cell, Microsoft MS Excel, paste in excel, paste values from single cell to merged cell in excel, project management templates, project planning template

    • Share:
    Hany Ismail, MSC, PMP
    Hany Ismail, MSC, PMP

    Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

    Previous post

    Install primavera 6.0 and upgrade from primavera 6.0 to primavera 6 version 7
    December 3, 2012

    Next post

    How to create a shop drawings submittas log with sample
    December 5, 2012

    You may also like

    Materials Procurement Scheduling in a Baseline Programme
    Materials Procurement Scheduling in a Baseline Programme
    7 May, 2022
    Planned VS Actual Excel Sheet
    Mini Schedule Planned VS Actual Excel Sheet
    18 August, 2021
    3 weeks look ahead schedule
    3 weeks look ahead schedule excel sheet
    24 July, 2021

      9 Comments

    1. blank
      Hasan Jlelaty
      December 3, 2012
      Log in to Reply

      this is best website I found in internet.
      god bless you.

      • blank
        Moneer Jlelaty
        December 3, 2012
        Log in to Reply

        God bless u eng. Hassan, u r sooos hardworking man 🙂

      • blank
        Planning Engineer
        December 4, 2012
        Log in to Reply

        Thanks Mr. Hasan

    2. blank
      Antonio Regio
      January 22, 2013
      Log in to Reply

      Thanks for sharing. God bless.

    3. blank
      Mhamed Ibrahim
      February 11, 2013
      Log in to Reply

      thank you very much it's very helpful.

    4. blank
      Krisna Castor
      May 10, 2013
      Log in to Reply

      ive got a problem, what if the values you are to paste is from another file?

    5. blank
      Saqib Paracha
      June 17, 2013
      Log in to Reply

      Another Great Shot Planningengineer.net.

    6. blank
      Saqib Paracha
      June 17, 2013
      Log in to Reply

      Krisna Castor……..
      there is a way around….. first simply paste the value somewhere in the same sheet from another file and then apply the formula 🙂

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....