1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I imported a Google Sheets document to excel and need help trying to add options to the drop downs.

Our take

Transitioning from Google Sheets to Excel can feel overwhelming, especially when you discover that you've overlooked an important dropdown option. You’re not alone; many users face challenges as they adapt their reports for broader sharing. Fortunately, editing dropdown options in Excel is straightforward and can enhance your report's functionality. In this guide, we’ll walk you through the steps to modify your dropdown lists efficiently, ensuring your report meets your boss’s expectations and serves your team across all offices. Let’s dive in!

I created a report on google sheet to make my life simpler. My boss actually liked it and wants me to put it into excel so it can be shared across all of our offices.

I have downloaded it to excel but realized I missed an option for one of my drop downs. How can I edit the options in the drop downs that were created in Google Sheets?

submitted by /u/DreamRevolutionary14
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

I imported a Google Sheets document to excel and need help trying to add options to the drop downs. | Beyond Market Intelligence