You might want to open two files in two separate windows to compare them. Also, if you want to edit two files simultaneously, you need to open them separately. That is why you can change Notepad ...
To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...