It's Easy to Kick Off Unwanted Pivot Layout

« Your Feedback Helps Us To Deliver Best

Reverse FirstName with LastName & Vise Versa »

Oct 30

Kick-Off Unwanted Pivot Layouts

Hi there,

Today, I will be sharing a most important tip for Pivot Table. Most of the questions I am receiving from my trainees are from Pivot. Especially on today's topic. i.e., How to come out of Pivot Layout if at all we don't require to create a Pivot for our data? The Excel workbook will look mysterious if at all you are not able to know the solution to this problem. Many times, I have deleted the complete workbook or worksheet when I face this situation before knowing this tip. However we will proceed how to remove or delete the Pivot Layout when not required.

When You want to Create a Pivot, the Layout Looks Like This

...

To prepare a pivot table from the raw data, what you will do is selecting the raw dump and click on ALT + N + V + T , right? The above pic is how it looks even for you. ;)

Say, you don't want this pivot table for some reason and you want to use this space for further data analysis, then what you will do, you need to delete this area.

Select the outer boarders of the cells to select the complete Pivot Layout

You need to select this area completely to delete the layout.

When You Try to Press DELETE button from Keyboard

When you press DELETE button from your keyboard after selecting this layout will look like the above image. This is still incomplete. So,

Press CTRL + D to remove the pivot layout from Excel

the above result can be achieved when you select the above line from the layout and use CTRL + D which copies the format of blank cells to the below cells and it exactly looks like above. So, now the pivot layout is kicked off from your space.

This is awesome tip right.

That's it from my end. See you in the next post.

HAVE YOU KICKED-OFF PIVOT LAYOUT?

If you have other option to do this activity please do share it with us using below comments section. If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here for free.

SOME IMPORTANT LINKS:

Collect Time in Hourly Basis Using Pivot

Custom Grouping in Pivot Table

Pivot Week (1 - 5 Series)

Pivot Chart Tutorial

Thanks,

You must be logged in to see the comments. Log in now!

If you have no account yet, you can register now! (It only takes a few seconds)