Copy & Pasting within Worksheet

[SheaG]

Hi,

 

I have a question regarding the worksheets. I have created a custom worksheet to use as a material schedule which includes a mixture of merged and individual cells. The trouble I am having is when I want to copy and paste a a group of four rows & paste for a new line - the pasted objects don't carry over the merged cell formatting. Currently I am having to go through and re-merge all the merged cells which becomes quite time consuming.

Just wondering if there is an easier or more streamlined approach which I am missing?

Version: 2024 - Landmark.

[michaelk]

Merged cells won't survive either a row insertion or a copy paste.

 

To make it faster I use these menu commands to format worksheets:

 

https://www.verysmallgroup.com/worksheet-formatting-scripts

 

You can either use the scripts as scripts or menu commands.  I prefer menu commands because you can assign a keyboard shortcut to merge cells, split cells, etc.  There are also commands to copy and paste cell formatting without affecting cell content.