title: Selecting a sub row cell in google sheet
body: <p>While selecting one entire row we can use <code>={Sheet1!1:1}</code>. I am interested in knowing how do we select a sub row starting from B1 and till the end. Is there any way to do so without using Apps Script?</p>
  <p>Edit 1: THe solution provided by @Marios works but let me just add a modification to my problem. I want to use the columns for column validation as shown below:</p>
  <p><a href="https://i.stack.imgur.com/tgsbq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tgsbq.png" alt="enter image description here" /></a></p>
  <p>Whatever was suggested in answer works in general but I wanted to use that criterion for data validation dropdown. Sorry for the confusion.</p>