Return to site

Excel for mac remove empty rows

broken image
broken image

A user noticed that, when clicking the Category-column dropdown in the Transactions sheet in Excel, the data validation dropdown includes many blank rows below the pre-populated values from the Categories sheet.īy default, the data validation is configured to pull from cells A2:A98 in the Categories sheet.