What is the method to collapse or expand rows & columns in excel sheet?

What is the method to collapse or expand rows & columns in excel sheet?

The simple method to collapse or expand rows & columns in excel sheet are as follows:

Here is a quick step-by-step example to show you how.

Here are the basic steps:

  • First, you have to group the row/column selection
  • THEN, you can collapse or expand that group

Here is how you group rows or columns and then expand/collapse the group:

  • First, you need to group the columns/rows.


  • To group the ...
Continue Reading →

What is the best feature of Excel according to you and why?

Pivot Tables

PivotTables summarise large amounts of Excel data from a database that is formatted where the first row contains headings and the other rows contain categories or values. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.

If you’re new to creating PivotTables, Excel 2013 can analyze your data and recommend a PivotTable for you. Once you’re comfortable with PivotTables you can start ...

Continue Reading →

How do you create a pivot table in Excel?

Pivot tables are one of Excel‘s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.

Insert a Pivot Table

To insert a pivot table, execute the following steps.

1. Click any single cell inside the data set.

2. On the Insert tab, in the Tables group, click ...

Continue Reading →