You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

For example, if you are making a list of days in the week, type "Sunday." If your list is a common set of data, such as days, months or consecutive numbers, Excel for Mac can automatically ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without ...

Head to the Excel Options menu (through the File menu on Windows) or within Excel Preferences on Mac. Open the Ribbon menu to Popular Commands and click the Developer option on the right, then Save.