[Solved] Short cut for copy/paste special/formula?

[legalnan]

Edit: Split from [Solved] Linking cells on same spreadsheet

Is there a short cut for copy/paste special/formula? It used to be control D. Thanks

[MrProgrammer]

Is there a short cut for copy/paste special/formula?

I believe you are asking about Edit → Paste Special → Selection:Formulas. See PasteFormulas (or perhaps Duplicate) in [Tutorial] Favorite Recorded Calc Macros. Then assign a a keyboard shortcut of your choice. I created shortcuts for both on my system years ago and use then often.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[legalnan]

I was able to record a macro but had no luck running it much less assigning a shortcut key. The instructions are a bit advanced for me. I can manage with copy/paste special/formula for the time being. Thanks very much for trying.