Search Contextures Sites

 

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Oct 2, 2012

 
Get 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 Tools

They 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.

Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.