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 ddalgleish@contextures.com

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:

  1. 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.
  2. On his Bacon Bits blog, Mike Alexander shows how he mocks up a dashboard, before starting to build in Excel.
  3. 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.
  4. 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!


Contextures Products

Save time with our "Done For You" Excel products.


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




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.