Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Group and Ungroup for Pivot Tables

Pivot Tables for Excel 2007Another popular query we have is how to Group and Ungroup for Pivot Tables. This method allows you to combine a number of similar items into a single category for further analysis.

Related: Watch the video clip on how to group and ungroup data in a pivot table

The grouping can be done on text, dates or numbers with each type offering different options. Dates can be grouped into days, months, years, quarters and it even allows for grouping of time. Numbers allows for groups based on the intervals you want. For the text grouping you simply need to choose the items you want grouped together.

In order to do this it is as simple as right clicking on one of the cells and clicking the UNGROUP option.