There's a quiet frustration baked into this question, and it's one we recognize all too well. You're staring at a weekly agenda, you need to shift everything down by seven rows, and the only answer anyone offers is a formula you explicitly said you don't want. The internet shrugs. The spreadsheet software shrugs. And you're left dragging cells by hand, one by one, like it's 1999.
Here's the thing: the problem isn't you. It's the tool. Excel was built for a world where manual repetition was just part of the job, and its design still carries that assumption forward. When you ask "how do I move a block of text down seven rows without breaking anything," the software hears "how do I restructure my data," and it answers with formulas, macros, or nothing at all. But your use case is simpler than that. You're not building a dynamic model. You're trying to keep a living document that shifts with your week. You need the cells to move, but you also need to keep typing in them. That's not a formula problem. That's a workflow problem.
What you're describing is a gap between what spreadsheets are and what they could be. The fact that you're asking this question at all suggests you've already sensed it. You don't want to learn a new scripting language or memorize a keyboard shortcut that only works if you've set up the sheet exactly right. You want the tool to understand that when you say "shift my agenda down a week," it should just do that. Not because you've written a complex formula, but because that's the obvious, human thing to do. And that's exactly where the future of spreadsheet software is headed: not toward more powerful formulas, but toward interfaces that meet you where you are.
Stop fighting the tool, but don't accept its limitations either. The fact that you're struggling with this is a sign that you've outgrown the traditional spreadsheet workflow. You're not asking for anything unreasonable. You're asking for a smarter way to manage your time. And when the tool you're using can't handle that gracefully, it's worth asking whether the tool is the problem. The answer, in this case, is yes. The next version of your agenda shouldn't require you to drag anything. It should just know.