Excel Weekly News from Contextures June 11, 2013

Interactive Function List + more Excel tips

It's been cool and wet here in Canada this week, and you can see a bird waiting for the rain to start, in my photo this week, at the end of the newsletter.

In this week's Excel news, you'll see how to adjust the pivot table field list, find functions in the interactive functions list, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Interactive Excel Functions List

New functions have been added to Excel, over the past few versions. On my Contextures website, I've created an interactive list of the functions, and you can sort, filter, or download the list. Some functions have hyperlinks, and you can click those to go to a function tutorial on my site.

Click here to see the functions list: Interactive Excel Functions List

How to Adjust the Pivot Table Field List

When you create a pivot table, by default, a pivot table field list should appear, at the right of the Excel window. Instead of leaving the default settings, you can select a different field list layout, move it to a new position, and change the list order.

Click here to see the details, and to watch the video: How to Adjust the Pivot Table Field List

Excel Page Break Preview Tips

Before you print an Excel worksheet, you can check and adjust the page breaks, using the Page Break Preview view. This could save paper, if you discover problems before you start printing.

Click here to see the details, and to watch the video: Excel Page Break Preview Tips

More Excel Tips

Here are a few more Excel articles that I read this week, that you might find useful:

Video: Quickly Remove an Excel Pivot Table Field

After you create a pivot table, you might want to remove a field from the layout. You don't need to go to the field list, find that field and remove its check mark. And, you don't need to drag the pivot field out of the Row Labels area in the field list. Watch this short video to see the quickest way to remove a pivot field from the layout.

For more info on pivot fields, please visit my Contextures website: Excel Pivot Fields

Bird on a Wire

Sometimes I see an overhead wire, filled with dozens of birds, watching the world go by. Last week, I snapped this picture of the opposite situation. Here is a single bird, and dozens of wires! Maybe the approaching storm scared away his friends.


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.