Corrupted sheet; 1st column missaligned by one row

English
#1

I have a sheet of 760 rows & 5 columns. While editing around row 302 I have discovered that the data in all columns to the right are misalligned by one row. I need to move the initial column down by one row. Is it possible to do that?

#2

Choose menu Sheet - Insert Cells.
or
Press Ctrl++ and choose Shift cells down.

#3

THanks for reply.
Sorry, too much of an amateur. Tried Ctrl + + and nothing appeared. Don’t know where menu appears.
I will need to find where the rot started too - my problem, not yours.

#4

Ctrl++ depends on UI language and/or keyboard layout. Use menu Sheet → Insert Cells… (which also displays the active shortcut).

1 Like
#5

Thank you both. Problem fixed.
I should try to find an indtruction course for Calc.

1 Like
#6

I can wholeheartedly recommend this Document Foundation offering :wink:

#7

Thank you. Downloaded and saved.

#8

And for always the latest and greatest and in several languages, see English documentation | LibreOffice Documentation - LibreOffice User Guides .

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.