Search Contextures Sites
Excel Weekly News from Contextures Oct 2, 2012Get a list of workbook formulas, zoom in to see drop down list items, round up or down, and other tips, in this week's Excel news from Contextures.
List All Formulas in Workbook
If you're taking over an Excel file that someone else built, or making changes to a file that you haven't used in a long time, it can be hard to understand (or remember) how the file works.
To quickly see what is in a workbook, you can use programming to create a list of all the formulas on each worksheet.
Click here to read the instructions and download the sample file: List All Formulas in Workbook
Make Data Validation List Appear Larger
You can't change the font size in a data validation drop down list, and it can be hard to read the items, if the zoom setting is reduced.To make the text appear larger, you can increase the zoom setting with VBA code to when a data validation cell is selected.
Click here to read the instructions: Make Data Validation List Appear Larger
Inserting Charts in Excel 2013
On Microsoft's Excel blog, Diego Oppenheimer explains how it will be easier to select the right chart type in Excel 2013.
Click here to read about the new chart features in Excel 2013: Inserting Charts in Excel 2013
Rounding Numbers With Formulas
In Excel, you can use formatting to show a specific number of decimals, but if you want to round the number, there are several formulas that will do the work for you.On his blog, Chandoo gives an example of each rounding formula, to show how it works. It's a good reference list, for those times when you have to round a number.
Read the details here: 18.2 Tips on Rounding numbers using Excel Formulas
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.