paste values from single cell to merged cell in excel

paste values from single cell to merged cell in excel

paste values from single cell to merged cell in excelPMP Road Map template. Read more ... », 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 chartCreate Gantt Chart and cash flow using excel with sample file. Read more ... » sheet (CreateL1-Create,Define Activities and WBS from Bill of Quantities BOQ. Read more ... » Gantt ChartProject Management from Directory. Read more ... » and cash flowproject management plan from Planning Engineer Point of View. Read more ... » using excel with sampleCreate Gantt Chart and cash flow using excel with sample file. Read more ... » fileCreate Gantt Chart and cash flow using excel with sample file. Read more ... »), 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 theHeads Up WHAT'S THE FIRST WORD YOU SEE?. Read more ... » 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:


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 excelVideo How to calculate working days using excel with sample. Read more ... » 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 sheetTrack Changes in Excel 2010. Read more ... » to paste values from single cell to merged cell in excel

paste values from single cell to merged cell in excel


[cmamad id="1179" align="right" mobid="ad-off"]


  • Share on Social Networks

Comments (9)

  • Pingback: Anonymous

  • Hasan Jlelaty Reply

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

    Dec 3, 2012 at 7:22 pm
    • Moneer Jlelaty Reply

      God bless u eng. Hassan, u r sooos hardworking man :)

      Dec 3, 2012 at 7:26 pm
    • Planning Engineer Reply

      Thanks Mr. Hasan

      Dec 4, 2012 at 10:18 am
  • Antonio Regio Reply

    Thanks for sharing. God bless.

    Jan 22, 2013 at 10:26 am
  • Mhamed Ibrahim Reply

    thank you very much it's very helpful.

    Feb 11, 2013 at 9:14 am
  • Krisna Castor Reply

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

    May 10, 2013 at 7:34 am
  • Saqib Paracha Reply

    Another Great Shot Planningengineer.net.

    Jun 17, 2013 at 11:10 am
  • Saqib Paracha 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 :)

    Jun 17, 2013 at 11:12 am

Leave a comment

Your email address will not be published.

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.