![]() ![]() This version of the macro steps through each of the PivotTables on the current worksheet (if any) and applies those two statements that set them to classic layout. This macro can be improved just a bit, however, by making it more "universal." With ActiveSheet.PivotTables("PivotTable1")Īs you can see, there isn't much (programmatically) to changing back to classic layout-all you need to do is issue two statements that affect the PivotTable. With the PivotTable sheet visible, I turned on the macro recorder and recorded just the steps that Nancy mentioned, above. I created a PivotTable and left it empty, with nothing defined in the various sections of the PivotTable. Nancy wonders if there is a way she can make the classic display the default.įor most versions of Excel there is no way to set this default, but it is possible to make the process a bit less painful. Every time she creates a PivotTable she has to go to PivotTableOptions | Display | Classic PivotTable Layout. Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list.Nancy creates a lot of PivotTables and likes the old layout better than the default set up in Excel 2010 and later versions. ![]() If a pencil icon appears and you want to get rid of it, press Escape. If you choose All Borders in the Borders drop-down menu, borders will be applied to the top, bottom, left and right of the each cell in the selection. You can select all three options (style, weight and color) first and then apply the borders for all settings at once. The Pen color drop-down menu appears as follows: If you choose a Standard Color or More Colors, this will override the theme.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |