•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Checkboxes not transferring properly between Google Sheets and Excel
Our take
Are you frustrated with checkboxes vanishing when you export spreadsheets from Google Sheets to Excel? You're not alone. Many users encounter this challenge, as the functionality of checkboxes differs between these platforms. While your conditional formatting might still work with TRUE/FALSE text, it's not the seamless interaction you’re used to. Fortunately, there are solutions to restore that checkbox functionality in Excel. In this guide, we’ll explore practical steps to help you regain control over your work schedule and enhance your productivity in your new role.
Hey folks!
A while ago I created a simple little spreadsheet in Sheets for the purposes of making my job of creating a work schedule easier. The idea is simple: each employee has a row, with three columns for each work day. For each day there is an "Off?" section that has a checkbox, and columns for "In" and "Out".
Checking the checkbox sets off a Conditional Formatting rule for the cells in the next two columns over that greys out those two cells. It looks like this. https://imgur.com/a/tlxEorz
Admittedly, this was very cumbersome to do and that makes me reluctant to scrap it all and work from a different starting point.
Only problem is that when I export it as an excel file and pull it up, all of my checkboxes are gone and replaced with TRUE/FALSE text. I see that checkboxes function differently in Excel than they do in Sheets, but I don't exactly understand it.
The conditional formatting does still work if I type in TRUE/FALSE, but I want to be able to interact with a checkbox like I can already do in Sheets but my Insert Checkbox button is greyed out no matter what I do. The workbook is unprotected, so I'm not sure what's going on.
Does anyone have any ideas on how to get this functioning in Excel? It won't necessarily need to be transferable back to sheets, I really just need it functioning in Excel because that's what my new job uses.
[Microsoft 365 MSO (Version 2601 Build 16.0.19628.20204) 64-bit]
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel User Input Checkboxes to Calculate Travel Hours Across Various Time ZonesHello Excel gurus! I have wasted quite a bit of time trying to figure this out. I'm hopeful that Reddit can save me. :) My department inherited a spreadsheet that calculates how many hours of time we spend traveling. The original spreadsheet was married to the format of a PDF flight itinerary that our travel people used. The travel people changed the spreadsheet (somehow - I don't know how/what - it looks the same to me) so now the old spreadsheet returns nearly all value! errors. The goal is to copy/paste the PDF into A2 and the rest of the sheet does the *magic*. Ultimately, said magic dumps into another tab. Here's the before/after of the original spreadsheet: Before Clicking Checkbox After Clicking Checkbox - Middle column I dumped the old spreadsheet into Google Sheets to unprotect it and aim to reverse engineer the *magic*. Most of the *magic* is back and jives with the new PDF format. (See below, colorful spreadsheet.) The only thing (I think - TBD this thread, I guess) I can't seem to figure out is why the checkboxes in row 3 don't work (below, what appears in the snips to be my second row with boxes all checked). Checkboxes in rows 2 and 4 work. I've tried dragging the cells from 2 into 3, from 4 into 3, and I've tried going from column G into F (I've tried every iteration of copy/paste that I know and I've tried every iteration of copy/paste that right clicking offers). Design Mode is off for all of the checkboxes. When I right click the checkbox, the Format Control cell link is linked to the cell of the checkbox (as applicable for each column). New Spreadsheet Example - All checkboxes checked in row with the issues. New Spreadsheet Example - All boxes unchecked (no changes that I can tell) The largest sheet I have made in the past was seven columns. Any help that can be provided, is much appreciated! submitted by /u/Different_River_3009 [link] [comments]
- Difficulty with checkbox and hiding rows.Admittedly I’m not great with excel. But I’m trying to setup excel in a way for people to simply click a checkbox on Sheet1, that would automatically filter or hide rows on sheet2, sheet3, and sheet4. Specifically I want to set it up so anyone in the field can open mobile excel on their phone or iPad, simply scroll down an input page with all options available, and quickly click checkboxes for items the customer needs. It will automatically fill data in on other sheets for all the formulas and outputs. And then hide rows on a summary page for the boxes that were not selected. Similarly, hide rows on an “estimate” page so the only rows displayed are the ones clicked. So all the field guys need to do is open mobile excel on their iPhones, click a few checkboxes, and the summary and estimate page will only show rows that were clicked on the input page. For whatever reason, I feel like I’m too dumb for this… so any help is greatly appreciated. Thank you submitted by /u/ALonelyTwinkie [link] [comments]
- Conditional formatting based on checkboxes in 2 other cellsI currently have conditional formatting programmed in column C based on if Column G and H are blank or not in 3 scenarios. The sheet is setup as a table. I'm trying to apply the formatting to the whole table. Highlight red if both blank: =AND(ISBLANK(G4), ISBLANK(H4)) Highlight yellow if one blank: =OR(ISBLANK(G4), ISBLANK(H4)) Highlight green if neither blank: =AND(NOT(ISBLANK(G4)), NOT(ISBLANK(H4))) I would like to put checkboxes in those cells instead of blank vs "ok". But putting checkboxes makes everything green since they aren't blank. I tried different variations of =AND(=G4=FALSE, =H4=FALSE) for red, but it gave an error and I couldn't save it. submitted by /u/travel-always [link] [comments]
- Excel Check boxes with more than just True/False responsesI was chatting with Gemini and it seemed to this this was possible with a script, but I could only find way to create checkboxes online... Currently a checkbox is either checked (TRUE) or unchecked (FALSE), and clicking the box toggles between those two options, is it possible to change these two options and create a third or fourth option? My specific use case is a project tracker, but instead of just using the checkboxes for complete or incomplete; I would like it to toggle between 1) In progress, 2) Complete with exceptions and 3) Complete without exceptions. Basically I want a bit more tailored information out of that check box, but since a lot of people use this Status Sheet I want to keep the check box logic (otherwise someone will inevitably unknowingly copy & paste data and overwrite other projects' status while rows are filtered or hidden). For some background my team does about 500 projects and each has about 5-10 sections, so I want a nice way of tracking each project and the sections. (People have a tendency to not tell you there are exceptions lurking in the files, so I need a good way for forcing that issue to our Status Sheet). submitted by /u/East_Direction9563 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#natural language processing for spreadsheets#generative AI for data analysis#google sheets#rows.com#financial modeling with spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#row zero#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#checkbox#Google Sheets#Excel