paste values from single cell to merged cell in excel

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:

paste values from single cell to merged cell in excel paste values from single cell to merged cell in excel

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:

paste values from single cell to merged cell in excel 2 paste values from single cell to merged cell in excel

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:

paste values from single cell to merged cell in excel 3 1024x575 paste values from single cell to merged cell in excel

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.

paste values from single cell to merged cell in excel 4 paste values from single cell to merged cell in excel

Excel options

paste values from single cell to merged cell in excel 5 1024x775 paste values from single cell to merged cell in excel

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.

paste values from single cell to merged cell in excel 6 paste values from single cell to merged cell in excel

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

Video How to calculate working days using excel with sample
Definition of Working Days: It is the period of time between two dates after deduction the week ends and the holidays, in other meaning the net eff...
14 easy steps to create a gantt chart with Excel in 3 minutes
14 easy steps to create a Gantt chart with Excel in 3 minutes, just follow the steps shown in the photos and you can download the sample excel temp...
Amazing excel project management add in
Amazing excel project management add in will allow multiply users to work in the same excel spreadsheet at the same time online and offline. ex...
MS Excel Functions and Formulas you need to use regularly
List of MS Excel Functions and Excel Formulas you need to use regularly with photos and detailed explanation how to use each MS Excel Functions For...
Performance Management Plan Template
Performance Management Plan Template, this Performance Management Plan Sample is useful to monitor the performance of your management plan in high ...
How to create a shop drawings submittas log with sample
Shop drawings log is a control document to record and monitor the shop drawings submittals and approvals between the contractor and the consultant ...
Create Gantt Chart and cash flow using excel with sample file
How to create a time schedule, Gantt chart, Bar chart and cash flow using the attached excel sheet. This Microsoft Excel sheet is fully automated a...
Project Management from Directory
Project Management from Directory includes all Project Management from and excel spread sheets for project management all in one place, all files c...