You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
(Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way.)
I often work with pivot tables that have URLs as rows of data, and the URLs can be quite long. In the past, whenever I changed the data and refreshed the pivot table, Excel would automatically resize the column width, making the column as wide as the longest URL. This pushed all my other data to the right and out of view. To see it, I had to scroll--an extra eye-wearying, time-consuming step.
Now the column width doesn't change each time the pivot is refreshed, but now you need to define how wide the column with the URLs should be.
Nice article Stacey. It's one of those options that people don't look up on the dialog boxes that open and keep adjusting the width of the columns without knowing that there is already an option for that in Excel. Regards. jppinto
Thanks for the comment Joao. Yes, I'm always looking for ways to save time.
This should be the default setting, or there should be some way to enable this as the default setting. I have to do this everytime I make a pivot table (which can be a dozen times a day in some projects)
Found. It works for 2007 also.