I doing some copy-> paste special → number/text only.
I should paste-special again several times to somewhere else in other sheets.
When I saw in the “Edit” menu, they only show “Repeat: Copy”
I wish they will show me “Repeat: Paste special”
Why not just use shortcut " ctrl+shift+v " ? It is more convenient than using edit menu.
OK there is another way by using macro. Follow this:
1- enable recording a macro see this and this.
2- star recording and do a normal special paste.
3- end the recording and save the macro.
4- then assign a special shortcut for the new macro.
5- enjoy special paste with one shortcut.
That’s it!
I follow your advice, and I now have create a nice paste text/number only Macro
Thank you
Ctrl+Shift+V require extra “enter” keyboard. Total four keyboard must pressed (Ctrl, Shift, V, and Enter)
If I can reduce just in one or two keyboard shortcut, that should be better.
The context menu of Calc offeres: Paste only and then the choice of TEXT or NUMBERS or FORMULA. It might be choice.