It would be very helpful to add the following to the menu:
- Line Shift Up -- shift the current line (row) upper (exchange it with previous line)
- Line Shift Down -- shift the current line (row) lower (exchange it with next line)
As this feature is very needed and wanted (though it is absent in MS Excel, too), we also could add default buttons for this to the toolbar.
The similar feature for columns (shift left-right) is far less needed.
For now, I can simulate this only by Macro recording, that is far less convenient.
Hi @alivedsn, thanks for reporting.
Maybe using the option in Menu/Edit/Paste-Special - Shift cells down, can help a bit.
In any case looks fine.
That sounds like something that should be put in a macro.
- Insert blank line (up or down)
- copy line
- delete copied line
Such a macro could be put in the tool bar.
Thanks andréb, m.a.riosv,
Endeed, I already implemented this with macros.
But, having it internally (and having a pre-registered shortcut), will make this option available for everyone as standard - I'm sure this is a very useful thing. Very few users are able to define a macro, and even less are aware they need this...