Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

Learn how to create, delete & use a Custom List in Excel. If your work requires typing specific lists repeatedly, you can create Custom Lists to save your time. Learn how!

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Using Structured References in Excel Tables Excel tables offer a powerful feature called structured references, which allow you to create formulas that automatically expand and contract with your ...

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...