Header Banner
WonderHowTo Logo
WonderHowTo
Microsoft Office
wonderhowto.mark.png
Gadget Hacks Next Reality Food Hacks Null Byte The Secret Yumiverse Invisiverse Macgyverisms Mind Hacks Mad Science Lock Picking Driverless

How to Create collapsible and expandable cell ranges in Excel

Excel spreadsheet displaying sales data with columns for running totals and indexes.

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. You can then double click and drag it to the rest of the cells to apply the same function.

In the collapsible table, type in "=SUM" on the first Index cell. Highlight the entire Sales column. Click on the second value and hit the F4 key to lock your reference row. Divide the function with the last cell on the Sales column then hit Ctrl+Enter. The results will automatically show. You can now copy the function to the remaining cells.

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!