Basically, title. What I'm trying to do is: have each chapter start with page 1. My chapters are marked as Heading 1 paragraphs. If I change Heading 1 style to «Insert, Pagea break, Before, With default page style, Page number 1», and add a Heading 1 paragraph, it indeed inserts an automatic page break before itself and starts on a new page with default page style, but page number is not set to 1: the numbering continues from previous chapter.

If I do Ctrl+Enter and set the exact same settings to a manual page break, the new page will start from a page number 1. The problem with this is that I would prefer to not do this manually, it is error prone, easy to forget or mess up, and in general I want to set up my styles so that everything is handled automatically without any direct/manual formatting.

Can anyone reproduce this issue?

There are many cases when people might want to have a dropdown list of the other entered values in a column.

And the ability to prohibit entering others.

Classic one: entering yes, no, maybe.

These are not boolean, but discrete, and others should not be allowed.

Do you know how to do that?

Answer

source

select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

Here is an example.

Thanks @Aufgehtsabgehts@feddit.org

Ende Gelände!

When my cursor is right below a pasted image and I press enter, the image moves down with the cursor. How do I permanently stop this?