In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...
How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...
The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...
Microsoft Excel makes it easy to import data from other sources, such as Access and Oracle databases. Doing so, however, may result in poorly formatted data that is difficult to analyze, sort or ...
HowToGeek on MSN
How to Clean Up and Import Data Using Power Query in Excel
In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it ...
Quick Tip: Apply a uniform size to all charts on an Excel sheet Your email has been sent After adding several charts to a sheet, you might want to adjust their sizes so they're all the same. You can ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback