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 email@example.com
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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.
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!
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.
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.