Formula help

Hussein_Mohamed 

An alternative strategy that could be useful is to copy by formula but avoid all the formatting that makes the sheet look nice for a person but can be a nightmare when it comes to calculating with the data.

Blank columns could be removed and level 1 headings copied across so that there is a replica along with every level 2 header.  Only when the calculation is complete would you have a need for pretty formatting).

Hussein_Mohamed 

Copying merged cells from one worksheet to another while maintaining their appearance and values without merging cells on the destination worksheet can be done using the "Center Across Selection" alignment option instead of merging. Here is a step-by-step guide:

Step 1: Copy Merged Cells

1. Select the merged cells in your source worksheet that you want to copy. You can do this by clicking and dragging your mouse to select them.
2. Right-click on the selected cells and choose "Copy" from the context menu.

Step 2: Paste Special in the Destination Worksheet

1. Go to the destination worksheet where you want to paste the data.
2. Select the cell or range of cells where you want to paste the copied data. Make sure the destination cells are not merged.
3. Right-click on the selected cell(s) and choose "Paste Special" from the context menu.
4. In the "Paste Special" dialog box, under the "Paste" section, select "Values" to paste only the values from the source cells.
5. In the same dialog box, under the "Operation" section, choose "Add" to retain any formulas that refer to the destination cells. If you don't have formulas, you can choose "None."
6. Click the "OK" button to paste the copied data as values in the destination cells.

Step 3: Apply "Center Across Selection" Alignment

1. With the pasted data selected in the destination cells, go to the "Home" tab on the Excel ribbon.
2. In the "Alignment" group, click on the "Alignment Settings" button (represented by an alignment icon).
3. In the "Format Cells" dialog box that appears, go to the "Alignment" tab.
4. In the "Horizontal" dropdown, select "Center Across Selection."
5. Click the "OK" button to apply the "Center Across Selection" alignment. This will visually mimic merged cells without actually merging them.

Your data should now be pasted in the destination worksheet, appearing as if the cells are merged, but without actually merging them. The values and any formulas that reference these cells should also be retained. The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful!

This will help all forum participants.