You can insert Checkboxes into any cell in Excel


  • Staff

 Excel Blog:

We're excited to announce the release of Checkboxes to production in Excel. They are great for checklists, managing tasks and visualizing your data at a glance. With just a few clicks, you can insert Checkboxes into any cell, making your spreadsheets more dynamic and user-friendly.

medium


To insert Checkboxes:
  1. Select the range where you want checkboxes.
  2. Select Insert > Checkbox.

    medium
To check or uncheck a Checkbox:
  • Click on the checkbox.
  • Select one or more checkboxes and press Space.
To remove Checkboxes:
  • Press the Delete key.
If any of the checkboxes were checked, Delete will uncheck them. Press Delete again to remove them.

Availability:

Don’t have it yet? It’s probably us, not you. Features are released over time to ensure everything is working smoothly.

Windows and Mac Desktop: Rollout begins June 26

On Web and Mobile (iPad, iOS & Android): Coming soon

Check back here for updates. We expect all users on Current Channel to have access by the end of July 2024.

Checkboxes are among the most requested features by our user community, so thank you for all of your feedback!


Jake Armstrong (LinkedIn)
Senior Product Manager, Excel


 Source:

 
This looks really useful for spreadsheets which are shared by a team. I'm rather surprised that it hasn't been there before!
 

My Computers

System One System Two

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    Home built
    CPU
    Ryzen 3900x
    Motherboard
    Gigabyte Aorus Master x570 rel 1.0
    Memory
    32GB (2x16) @ 3600 MHz Corsair Vengeance LPX
    Graphics Card(s)
    Gigabyte Windforce RTX 2080
    Sound Card
    No separate sound card.
    Monitor(s) Displays
    Dell U2718Q
    Screen Resolution
    3840x2160
    Hard Drives
    1TB WD-Black SN850; 1TB Samsung Sata 850 Evo; 4 TB WD Blue Sata SA510 2.5''; 4TB Samsung Sata SSD 870 EVO 2.5".
    PSU
    Be Quiet Dark Power Pro 11 750W
    Case
    Lian Li PC-8FIB
    Cooling
    CPU: Noctua NH-U12A; Case: BeQuiet + Lian Li fans.
    Keyboard
    Steelseries Apex 7 brown keys.
    Mouse
    Logitech (wired) G403
    Internet Speed
    940 Mb/s down; 105 Mb/s up
    Browser
    Edge (Chromium)
    Antivirus
    Eset Internet Security
    Other Info
    Pioneer blu-ray optical drive.
  • Operating System
    Windows 11
    Computer type
    Laptop
    Manufacturer/Model
    Dell Inspiron 7373 2-in-1
    CPU
    Intel Core i7 8th Generation
    Motherboard
    Dell 0HG1FH (U3E1)
    Memory
    8GB DDR4
    Graphics card(s)
    Intel UHD Graphics 620 (Dell)
    Sound Card
    Realtek Audio (on motherboard)
    Monitor(s) Displays
    Touch screen generic monitor
    Screen Resolution
    1920x1080
    Hard Drives
    256GB Micron SATA SSD.
    Internet Speed
    400Mb/s (Wifi)
    Browser
    Edge Chromium
    Antivirus
    Eset Internet Security
    Other Info
    Dell says this system is not Windows 11 capable, but Microsoft seems happy with it.
This looks really useful for spreadsheets which are shared by a team. I'm rather surprised that it hasn't been there before!
You need to emphasize that this new feature is only available if you have a Microsoft 365 Subscription. Current standalone perpetual versions of Office 2021 will not get it. However, I assume Office 2024 will have it.

I have been using Excel for 29 years and have been able to add Checkboxes to Excel as far back as I can remember. Previously you inserted a Check Box Control and controlled it with Visual Basic for Applications code. The big difference now is they have made it a whole lot easier.

For Example:

Excel 97 (In Options enable Forms. Insert Check Box Control)

Excel 97 #2.jpg

Excel 2021 (In Options add Developer to Ribbon. Insert Check Box Control)

Excel - 2001.jpg
\
 
Last edited:

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2
    Computer type
    Laptop
    Manufacturer/Model
    ASUS TUF Gaming A15 (2022)
    CPU
    AMD Ryzen 7 6800H with Radeon 680M GPU (486MB RAM)
    Memory
    Crucial DDR5-4800 (2400MHz) 32GB (2 x 16GB)
    Graphics Card(s)
    NVIDIA RTX 3060 Laptop (6GB RAM)
    Sound Card
    n/a
    Monitor(s) Displays
    15.6-inch
    Screen Resolution
    1920x1080 300Hz
    Hard Drives
    2 x Samsung 980 (1TB M.2 NVME SSD)
    PSU
    n/a
    Mouse
    Wireless Mouse M510
    Internet Speed
    2000Mbps/300Mbps
    Browser
    Firefox
    Antivirus
    Malwarebytes
  • Operating System
    Windows 11 Pro 23H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom build
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    ASUS PRIME X370-PRO
    Memory
    G.SKILL Flare X 32GB (2x16GB) DDR4
    Graphics card(s)
    ASUS ROG-STRIX-RTX3060TI-08G-V2-GAMING (RTX 3060-Ti, 8GB RAM)
    Monitor(s) Displays
    Samsung S23A300B (23-in LED)
    Screen Resolution
    1080p 60Hz
    Hard Drives
    2TB XPG SX8200 Pro (M2. PCIe SSD) || 2TB Intel 660P (M2. PCIe SSD) ||
    PSU
    Corsair RM750x (750 watts)
    Case
    Cooler Master MasterCase 5
    Cooling
    Corsair H60 AIO water cooler
    Mouse
    Logitech K350 (wireless)
    Keyboard
    Logitech M510 (wireless)
    Internet Speed
    2000 Mbps down / 300 Mbps up
    Browser
    Firefox, Edge, Chrome
    Antivirus
    Malwarebytes (Premium)
    Other Info
    ASUS Blu-ray Burner BW-16D1HT (SATA) || Western Digital Elements 12TB USB 3.0 external hard drive used with Acronis True Image backup software || HP OfficeJet Pro 6975 Printer/Scanner
I don't see that option. Only in developer mode. 🤔
 
Last edited:

My Computer

System One

  • OS
    Windows 11 Pro
    Computer type
    PC/Desktop
    CPU
    Intel® Core™ i9-12900K Desktop Processor 16 (8P+8E)
    Motherboard
    Asus TUF Gaming Z790-PLUS WIFI D4
    Memory
    G.Skill Ripjaws V Series 32gb (2x16gb) DDR4 3200mhz
    Graphics Card(s)
    Asus Dual Geforce Rtx™ 3060 TI Edition 8gb Gddr6
    Monitor(s) Displays
    BenQ EW3270U 31.5” 3840x2160 UHD 16:9 HDR LED 4K LG 27UK850-W 27'' 4K UHD IPS LED Monitor with HDR10
    Screen Resolution
    3840x2160
    Hard Drives
    Samsung 990 with heatsink PRO PCIe 4.0 Gen 4 NVMe® SSD 1TB
    WD_BLACK SN850X NVMe M.2 2280 1TB PCI-Express 4.0
    Crucial T500 2TB Gen4
    Samsung 970 Evo M.2 2280 2tb Pcie Gen3. X4
    PSU
    Corsair AXi Series AX860i Digital 860W 80 PLUS PSU
    Case
    Fractal Meshify C ATX Mid Tower Case
    Keyboard
    Logi MX Keys
    Mouse
    Logi M705
    Internet Speed
    400 mbs
    Browser
    Firefox
    Antivirus
    Eset NOD32
    Other Info
    Love fast boots

Latest Support Threads

Back
Top Bottom