Friday, December 28, 2012

How to Hide the Excel Pivot Table Data Area


1. Move the data you want to hide to the right. The easiest way to hide a large data field is to hide everything that lies on the right side of a selected column. Therefore, start by moving all the data you want to hide to the right. Click on 'Pivot Table Wizard' on the Pivot Table Toolbar. Now click on 'Layout.' Drag and drop the columns to arrange the data in such a way that all the data you wish to hide is to the right of the column(s) that will be visible and click 'OK.'
2. Click on the first column from the left. Now go to the Pivot Table Toolbar and click on the icon that looks like a list with a green plus sign on the side (fifth icon from the left). A new window, titled 'Show Detail,' will appear. Here, select only the fields for which you wish the data to show. If you select no fields at all, only the data in the very first column will show. You can also hide the data in the fist column if you so desire.
3. Click on the first column. Click the icon from the Pivot Table Toolbar that looks like a list with a red bar on the side (fourth icon from the left). The data in the column will now disappear. If you press the same button again, the data will reappear. This way, you can hide all the data in the data area of the Pivot Table. If you wish to keep all the column headings and hide the data beneath the headings, simply click on the fourth icon (which hides data in one column) once for each column.

Blogger news