Data Subtotals with Visible Cells feature in Excel
In this video you will learn about the Data Subtotals with Visible Cells feature in Excel, including:
What the Data Subtotals feature is
What it does
How you can use it in a spreadsheet
How you can use the visible cells only option for copying to help copy a subtotalled list
Data Subtotal is a useful feature in Excel that can save you a lot of time. If you were to do what this feature does manually, it would take you a lot longer! This feature allows you to add subtotals into your data in a few quick steps rather than it taking you hours of work. It can be used for simplifying data and summarising it in a smart way. The only problem is normally if you want to copy just your subtotalled list, you can end up with all the 'hidden' rows too! So to overcome this, you can use the 'visible cells' option to just select the visible cells in your subtotalled list. We will now go through this for you in the video.
Some related videos you might like:
RANK and XLOOKUP in Excel - • RANK and XLOOKUP in Excel
SUBTOTAL vs SUM Function in Excel - • SUBTOTAL vs SUM Function in Excel
We also have a number of playlists on our channel that you might like to look at. One of these being Data Displaying in Excel - • Data Displaying in Excel
Our Data Subtotals with Visible Cells feature in Excel video is also included in our hint and tip post that can be found on our website - https://www.jplcomputer.co.uk/2022/01...
If you would like more information about us, pop over to our website here - https://www.jplcomputer.co.uk/
#MsOffice #MsExcel