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
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.