Загрузка...

Group Rows and Columns in Excel With Expand & Collapse Buttons | Include Summary and Subtotals

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/Group-Rows-and-Columns.xlsx

In this Microsoft Excel video tutorial I explain how to group rows and/or columns. This can be done automatically if you already have subtotals in your data, or you can define the groups manually. Once the groups are created you can use expand/collapse (plus or minus) buttons to hide or show each group. Excel can also create subtotals for you based on every change in value within a given column or columns.

#microsoftexcel #exceltips #exceltutorial

Table of Contents
00:00 Introduction
00:22 Use this method if you don't have subtotals
03:57 Use this method if you do have subtotals
05:15 Use this method to create subtotals

Видео Group Rows and Columns in Excel With Expand & Collapse Buttons | Include Summary and Subtotals канала Chester Tugwell
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять