- 1). Open the Excel workbook that has the pivot table you want to edit.
- 2). Right-click anywhere in the body of the pivot table and select "Pivot Table Options" from the menu that opens.
- 3). Select the "Layout and Format" tab when the "Options" box opens.
- 4). Look to the "Format" section and uncheck the box next to "For empty cells show." This will remove the blank spaces from pivot tables.
- 5). Click "OK" and review your pivot table. You will see that the blank spaces no longer show up.
- Advertisement -
- Advertisement -
EDITOR PICKS & Articles
- Who"s the Boss? You Or Your Dog?
- Boxer Dogs As Hunting Dogs
- How to Protect a Dog from Eye Injury
- Westie Training For Enjoyable Trips With Your Pet
- Deciding to Train Your Own Dog
- Wild Alaskan Salmon Oil & Dogs
- Dog Training Techniques - Is Using Your Voice the Best Way?
- How to Recognize and Treat Pyothorax in Dogs
- The Decision To Have A Dog, Part One
- Cancer Options for Dogs
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
"Technology" Categories
Stay With Us
"Technology" MOST POPULAR
"Technology" Lastest Articles