Excel Weekly News from Contextures Aug 27, 2013
Adjust column width + more Excel tips
In this week's Excel news, you'll see how to add all the remaining fields to a pivot table, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Excel Dashboards Book Giveaway
The two winner of last week's giveaway, for Vertex42's Spreadsheet Tips Workbook, are Heather R and Jeff. Congratulations!
This week, you can enter the giveaway for a chance to win a copy of the ebook Excel Dashboards and Reports, by Mike Alexander and John Walkenbach. Two winners will be selected.
Go to my blog post, read the rules, and add your comment, to enter the draw for this add-in. The deadline is Wednesday, August 28st, at 12 noon, Eastern time.
Click here to see the details, and to enter the giveaway: Excel Dashboards Book Giveaway
Add All Remaining Fields to Pivot Table
If there are only a few fields in the pivot table, it's easy to check the boxes and add them all manually. You have to do these one at a time though — there isn't a "Select All" checkbox.
If there is a long list of fields, you could manually add a few, and then use a macro to put the rest in the Row Labels area, or the Values area.
Click here to see the details, and get the sample code: Add All Remaining Fields to Pivot Table
Adjust Excel Column Widths to Fit Specific Cells
You can quickly adjust a column's width by double-clicking on its border in the column headings. Sometimes that makes the column much too wide though, if there is heading text in the top few rows.
Instead, you can adjust a column's width to fit specific cells, instead of the entire column.
Click here to see the details: Adjust Excel Column Widths to Fit Specific Cells
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- If you've been using Excel's new add-in, Power Query, you can experiment with these sample functions from Rafael Salas. You can download the add-in on the Microsoft website, but be sure to check the system requirements first.
- On his Bacon Bits blog, Mike Alexander shows how he mocks up a dashboard, before starting to build in Excel.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- On the Option Explicit VBA blog, Jordan G shows how he creates bullet charts in Excel, with a combination of Sparklines and in-cell bar charts.
Video: Customize the Excel Status Bar
In Excel 2007 and later, when you right-click on the Excel Status Bar, there is a long list of options that you can add or remove. For example, show whether Caps Lock is on or off, see the Zoom setting, and even hide the Record Macro button.
Watch this short video to see how to change that setting in Excel 2007. The steps are the same in Excel 2010 and Excel 2013.
The Unicorn Fish
As I mentioned last week, we spent a few days in Rochester, New York, and visited the National Museum of Play. Just inside the door is a fabulous fish tank, with many exotic types of sea life. This guy -- a Unicorn Tang -- was definitely my favourite. I've seen some strange things in Excel files, but nothing as strange as this -- thank goodness!
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, 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 Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.