Excel 2021 how to?


K

Kim Parker

Well-known member
Member
Local time
1:33 PM
Posts
48
OS
Windows 10 physical Windows 11 virtual
I use Excel for lot more than number crunching. It keeps track of my ancestry information, links, etc. I am not sure how to explain what I am looking for, it is show/ hide a row(s). For example, let's say 3x Great- Grandpa Osmund is listed on his own worksheet, with the names of his sons and daghters. To enter the names of the descendants of Generation 2, and each of their family down through the generations, would be a nightmare for clarity.

But as I have G2 Erik on his own line, and his own kids on the G3 lines, and so on
If I could make G3 or G4 (or both) disappear back up with a mouse click,
then I can have my clarity and understand it too.

What would I search for to learn how to do this?
No javascript, way too complicated.
Some searches I found mentioned the rows will show down when I click on a word.
That might work but I want to row(s) to go up and down (show/hide) with a mouse click.

Plus, not everyone has the latest and greatest Excel, so this should be something older versions of Excel can do.
 

My Computer

System One

  • OS
    Windows 10 physical Windows 11 virtual
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom Built
    CPU
    12
    Motherboard
    Asus
    Memory
    128
    Graphics Card(s)
    Nvidia
    Screen Resolution
    1360x768
    Hard Drives
    2
    PSU
    850
    Case
    Cooler Master
    Cooling
    fans
    Keyboard
    ergonomic
    Mouse
    wired
    Browser
    several
    Antivirus
    abast
Kim Parker said:
I use Excel for lot more than number crunching. It keeps track of my ancestry information, links, etc. I am not sure how to explain what I am looking for, it is show/ hide a row(s). For example, let's say 3x Great- Grandpa Osmund is listed on his own worksheet, with the names of his sons and daghters. To enter the names of the descendants of Generation 2, and each of their family down through the generations, would be a nightmare for clarity.

But as I have G2 Erik on his own line, and his own kids on the G3 lines, and so on
If I could make G3 or G4 (or both) disappear back up with a mouse click,
then I can have my clarity and understand it too.

What would I search for to learn how to do this?
No javascript, way too complicated.
Some searches I found mentioned the rows will show down when I click on a word.
That might work but I want to row(s) to go up and down (show/hide) with a mouse click.

Plus, not everyone has the latest and greatest Excel, so this should be something older versions of Excel can do.
Click to expand...
Using VBA, as explained here:

www.ablebits.com

How to hide columns in Excel using shortcut, VBA or grouping

4 quick ways to hide and show columns in Excel: shortcut, ribbon menu, VBA, and grouping.
www.ablebits.com www.ablebits.com

excelchamps.com

Excel VBA Hide and Unhide a Column or a Row

In this VBA tutorial, we will learn to hide and unhide a column and a row using a VBA code, and we will write this code by using hidden...
excelchamps.com excelchamps.com
 

My Computers

System One System Two

  • OS
    Windows 11 Pro for Workstations
    Computer type
    Laptop
    Manufacturer/Model
    ASUSTeK COMPUTER INC. TUF Gaming FX705GM
    CPU
    2.20 gigahertz Intel i7-8750H Hyper-threaded 12 cores
    Motherboard
    ASUSTeK COMPUTER INC. FX705GM 1.0
    Memory
    24428 Megabytes
    Graphics Card(s)
    Intel(R) UHD Graphics 630 / NVIDIA GeForce GTX 1060
    Sound Card
    Intel(R) Display Audio / Realtek(R) Audio
    Monitor(s) Displays
    Integrated Monitor (17.3"vis)
    Screen Resolution
    FHD 1920X1080 16:9
    Hard Drives
    2 SSD SATA/NVM Express 1.3
    WDS500G2B0A-00SM50 500.1 GB
    WDCSDAPNUW-1002 256 GB
    PSU
    19V DC 6.32 A 120 W
    Cooling
    Dual Fans
    Mouse
    MS Bluetooth
    Internet Speed
    Fiber 1GB Cox -us & 400MB Orange-fr
    Browser
    Edge Canary- Firefox Nightly-Chrome Dev
    Antivirus
    Windows Defender
    Other Info
    VMs of Windows 11 stable/Beta/Dev/Canary
    VM of XeroLinux- Arch based & Debian 12
  • Operating System
    Windows 11 Insider Canary
    Computer type
    Laptop
    Manufacturer/Model
    ASUS X751BP
    CPU
    AMD Dual Core A6-9220
    Motherboard
    ASUS
    Memory
    8 GB
    Graphics card(s)
    AMD Radeon R5 M420
    Sound Card
    Realtek
    Monitor(s) Displays
    17.3
    Screen Resolution
    1600X900 16:9
    Hard Drives
    1TB 5400RPM
OAT said:
Using VBA, as explained here:

www.ablebits.com

How to hide columns in Excel using shortcut, VBA or grouping

4 quick ways to hide and show columns in Excel: shortcut, ribbon menu, VBA, and grouping.
www.ablebits.com www.ablebits.com

excelchamps.com

Excel VBA Hide and Unhide a Column or a Row

In this VBA tutorial, we will learn to hide and unhide a column and a row using a VBA code, and we will write this code by using hidden...
excelchamps.com excelchamps.com
Click to expand...
But isn't VBA unsfe? Some relatives aren't too experienced in computers. Also, if javasacript were turned off on their's it would course have to be turned on for this sheet/ workbook.
 

My Computer

System One

  • OS
    Windows 10 physical Windows 11 virtual
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom Built
    CPU
    12
    Motherboard
    Asus
    Memory
    128
    Graphics Card(s)
    Nvidia
    Screen Resolution
    1360x768
    Hard Drives
    2
    PSU
    850
    Case
    Cooler Master
    Cooling
    fans
    Keyboard
    ergonomic
    Mouse
    wired
    Browser
    several
    Antivirus
    abast
Kim Parker said:
But isn't VBA unsfe? Some relatives aren't too experienced in computers. Also, if javasacript were turned off on their's it would course have to be turned on for this sheet/ workbook.
Click to expand...
If you write the code yourself, what's unsafe about it?
JavaScript and VBA are totally different things.
www.educba.com

JavaScript vs VBScript | Know The Top 6 Amazing Differences

In this JavaScript vs VBScript article, we will look at their Meaning, Head To Head Comparison,Key differences in a simple and easy ways.
www.educba.com www.educba.com
The idea of writing a macro within a sheet is to make it transparent to the user and to automate things.
You can have a button named Show or Hide, and all the users need to do would be to click on that cell.
You can protect the spreadsheet and lock it preventing any unwanted 'changes'.
Give it a chance, you will be impressed by its power.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro for Workstations
    Computer type
    Laptop
    Manufacturer/Model
    ASUSTeK COMPUTER INC. TUF Gaming FX705GM
    CPU
    2.20 gigahertz Intel i7-8750H Hyper-threaded 12 cores
    Motherboard
    ASUSTeK COMPUTER INC. FX705GM 1.0
    Memory
    24428 Megabytes
    Graphics Card(s)
    Intel(R) UHD Graphics 630 / NVIDIA GeForce GTX 1060
    Sound Card
    Intel(R) Display Audio / Realtek(R) Audio
    Monitor(s) Displays
    Integrated Monitor (17.3"vis)
    Screen Resolution
    FHD 1920X1080 16:9
    Hard Drives
    2 SSD SATA/NVM Express 1.3
    WDS500G2B0A-00SM50 500.1 GB
    WDCSDAPNUW-1002 256 GB
    PSU
    19V DC 6.32 A 120 W
    Cooling
    Dual Fans
    Mouse
    MS Bluetooth
    Internet Speed
    Fiber 1GB Cox -us & 400MB Orange-fr
    Browser
    Edge Canary- Firefox Nightly-Chrome Dev
    Antivirus
    Windows Defender
    Other Info
    VMs of Windows 11 stable/Beta/Dev/Canary
    VM of XeroLinux- Arch based & Debian 12
  • Operating System
    Windows 11 Insider Canary
    Computer type
    Laptop
    Manufacturer/Model
    ASUS X751BP
    CPU
    AMD Dual Core A6-9220
    Motherboard
    ASUS
    Memory
    8 GB
    Graphics card(s)
    AMD Radeon R5 M420
    Sound Card
    Realtek
    Monitor(s) Displays
    17.3
    Screen Resolution
    1600X900 16:9
    Hard Drives
    1TB 5400RPM
You must log in or register to reply here.

Similar threads

Solved Change cursor color in Excel 2021, W11 Pro
Replies
18
Views
468
TryingHard
T
A weird thing happening in Excel 2021, but not Excel 365
Replies
6
Views
302
antspants
antspants
Excel horizontal scrollbar stopped working in Excel 365 online free version but I got it working again in Excel 2010
Replies
0
Views
94
Ozguy
O
Solved Excel 2019 freezing periodically
Replies
4
Views
305
fishingfool
fishingfool
Finally got it -- Publisher 2021 and dynamic update from EXCEL 2024 --SUCCESS
Replies
1
Views
898
antspants
antspants

Latest Support Threads

Latest Tutorials

Back
Top Bottom