I'm creating a simple Excel spreadsheet for table data entry (table created using the "Format as table" option — couple of columns, there could be hundred of rows). I would like to always have the last row of the table blank and ready for data entry (otherwise I don't see the dropdowns). I am pretty sure I have seen that in the past, but I can't replicate. Any idea how I could do that? Ideally without VBA.
data validationmicrosoft excelmicrosoft-excel-2007