Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...

Edit your horizontal chart data in Excel 2007 with a variety of available tools. Change the data, format, titles and scale of your scatterplot's horizontal axis. Scatterplots are a type of chart in ...

Microsoft Excel is great for numbers, certainly, it does this job really well. But, if you want to present your data in an attractive manner that allows you to visualize and analyze it easily, then ...

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style. It’s common to highlight input cells so users know which values to change, and ...

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...