[Solved] Move cell content down on Enter

[Mandalore]

Here's the rough scenario i'm trying to create:
There is text in cell A2. I type something into A1. As soon as i hit enter, i want the text that was originally in A2 to move down to A3, the text i just typed into A1 to move down to A2, and A1 to be empty again. And so on and so forth, until i reach the bottom of the document.
Is this in any way possible or am i wasting my time trying to figure this out? Thanks in advance.

[MrProgrammer]

Hi, and welcome to the forum.

As soon as i hit enter, i want the text that was originally in A2 to move down to A3, the text i just typed into A1 to move down to A2, and A1 to be empty again.

Calc does not work the way you would like when Enter is pressed. Behavior upon pressing Enter is in option Calc → General → Press Enter to move selection. It's the selection which moves, not the data. Options are set with OpenOffice → Preferences on a Mac, Tools → Options on other platforms. Doing what you'd like is not one of the choices. I disable (uncheck) the option so that the selection does not change when I press Enter. The suggestion below is based on this behavior.

However, I can record a macro to shift cell content down.
• Tools → Macros → Record → Insert → Cells → Shift cells down → OK → Stop Recording
Then I give my macro a name and save it. The tutorial in my link discusses assigning a keyboard shortcut, say F3, to a macro. I tested the macro and it does what you've asked for.

You can record your macro using those steps and assign F3 to it. After you do this once, then
• type data in A1 and press Enter
• press F3 to shift column A down and leave A1 empty.

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

[Zizi64]

And so on and so forth, until i reach the bottom of the document.

What you meant as "bottom of the document"? The Calc has about a million of Rows. Do you mean one Page to Print?

Of course it may possible (by usage of the macros).