Quick Trick: Resizing column widths in pivot tables

AppId is over the quota
AppId is over the quota

(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. 

Right-click in the pivot table 

Select Pivot Table OptionsIn the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.

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.

Go back to your pivot and select the column with the long URLs. Right-click, and enter a value for the column width. 

Now when you refresh the pivot table, the column doesn't resize. Instead its width corresonds to the value you entered.

View the original article here

Quick Trick: Resizing column widths in pivot tables

AppId is over the quota
AppId is over the quota

(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. 

Right-click in the pivot table 

Select Pivot Table OptionsIn the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.

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.

Go back to your pivot and select the column with the long URLs. Right-click, and enter a value for the column width. 

Now when you refresh the pivot table, the column doesn't resize. Instead its width corresonds to the value you entered.

View the original article here

She asked pivot tables (video)

So many Office customers questions "Pivot table", that we have collected the best answers in this blog post. Most likely, you are on the search for information about creating a PivotTable report, which help to summarize and analyze your data. Or you already have your data in a PivotTable report and are looking for information about how you swing it.

Example of a PivotTable report

Following a three step process insert a PivotTable report based on your worksheet data, you will learn in Quick start: create a PivotTable report.

To the full scoop on PivotTables and PivotCharts), or to create a PivotTable based on an external data source, you should instead the instructions under create or delete a PivotTable or PivotChart report follow.

Because pivot tables are not easy to understand, the following video can be useful.

Are you new to pivot tables? In this case I really recommend that you popular with this training written by my colleague, Judi Hurlock, PivotTable I: get started with PivotTable reports in Excel 2007start. It helped me definitely when I started.

If you are using an earlier version of Excel, you can also this article Pivot, Swivel, and role of Crabby Office Lady, which enjoy the flexible offers an interesting overview of PivotTables little contortionists of the data world!

Excel is the Office application for detailed analysis of data use, but if you keep your data in an Access database, you can pan it there also. The article create or delete a PivotTable or PivotChart report should facilitate entry.

After you create a PivotTable report, it is useful, that you want to pivot the data to view it from different angles. Unfortunately, in order to better the actual features correspond to the "PivotTable data with this", we have another article title for a Weile--we it "change the layout of a PivotTable report" which from made to find it hard if you were looking for information about pivotieren data used.

But now it is again as Pivot data in a PivotTable report, to find which should be in the search for it!

I hope this provides answers to your questions about pivot table. If there are other ideas out there, or you have a good tip about the use of pivot tables, we would look forward to hearing from you!

-Frederique Klitgaard

View the original article here