Share via

EXCEL - PIVOT TABLES - creation without autofit columns

Anonymous
2016-08-11T14:07:17+00:00

I want to create a pivot table in Excel, but i dont want it to adjust the columns of my Excel sheet.

Do you know how to do this before you create the pivot table? I know how to do it after i create one..

I just go to options and then unclick autofit column width on update.   But i want it to be unchecked before i create the pivot.

i place data below the pivot (cleaned up to present) and i want the column width to stay the same with uniform spacing. i always have to adjust it back. It is a PIA.  i want to shut down that re-sizing permanently.

Trying to limit steps here.  Needs to have ability to not mess with column width (before i set up the pivot).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-11T19:09:44+00:00

    Hi,

    Since your query is related to Pivot tables, I kindly request you to click on the link below to post your query in the TechNet forum.

    http://social.technet.microsoft.com/Forums/en/excel/threads

    Thank You.

    0 comments
  2. Anonymous
    2016-08-11T19:14:54+00:00

    Itz ok.  i got an answer from Excel user voice.  I can actually create the pivot, then before i add fields, go to options and uncheck autosize pivot table.  It works.  I have to do it each time, but it does work. it would take a redesign to get it to uncheck that permanently i guess. Thanks.

    0 comments