Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...

Dynamic dropdowns in Excel allow you to create dependent lists where options in one are dependent on what you selected in another. They are a smart way to streamline data entry: instead of scrolling ...