excel
41637 TopicsWelcome to your Excel discussion space!
If you’re looking to ask a question or start a conversation about Excel, you’re in the right place! Ask away. Please include your Excel version, sample file, and a bit of context to help others answer your question: Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using) Excel product name and version number (see About Office: What version of Office am I using?) Excel file you’re working with or sample file with data – please remove all confidential and PII data As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow Expected result and method to achieve the result Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question. Thanks! *Kudos tomathetes Twifoo mtarler for contributing to this welcome message72KViews81likes0CommentsWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from youwhich helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team54KViews26likes59CommentsAutocomplete not working for data validation
At work we have a shared excel sheet (we open it on the web) and we use it to store data. We had it set up with data validation list's and when we typed into the boxes, it would autocomplete one of the options. Now, you have to click the down box then start typing because autocomplete has stopped working. Autocomplete is still checked in options, and everything is still the same setting that it was previously as far as anyone can tell. Please help!53KViews23likes73CommentsFull Dark Mode in Excel
Currently you can set Office Theme to Black which acts as a dark mode. In Word, setting this to Black makes the page dark and the text white when it is set to “Automatic”. I was wondering if anyone had an idea if Microsoft is planning to release this same thing for Excel too? Right now Excel when using the dark theme makes everything dark except the cells. Which kind of makes no sense to me. This is where your eyes are most of the time. It needs to be a proper fully dark theme. Is there a way to get a full dark mode without manually setting the background color of the cells dark and the text white? Can a plugin be made to do that while keeping the actual cell background “empty” and the text “Automatic”? Is there already a plugin that does that? Thanks!388KViews22likes43CommentsExcel can be fun and contagious. CD Drive Open and Close....if it is still there
Excel can be fun and contagious. So that some may remember the old days and some may have fun playing with it today Excel doesn't always have to be serious, it can also be funny 🙂 Have fun everyone, enjoy the time. Wish everyone a nice day or night with a lot of health, joy and love. Nikolino I always know that I don't know anything846Views22likes0Commentscreate a kind of Gantt beam from a Working time sheet
Hello people need help too, Would like to create a kind of Gantt beam in this worksheet. Would like to enter the working hours (von=from, bis=to) in sheet "January", in three Duties ( Dienst1, Dienst2, Bereitschaft ) and in MA1 to 9 (colleagues) as well as the TeamChief, in the end it should be in the specified beam in sheet "IND1" should appear. The bar / timeline should appear (“IND1”) in the default color and row of the colleague I insert the working time in sheet “Januar”. Only the entered working hours should appear with color in sheet “IND1”, everything else without color in the row. In the end, the VBA code should be so that I simply copy it into the next sheet every month. A very nice person wrote me this VBA code (which I am also very grateful for) to accomplish my project. However, due to my VBA ignorance, I overexcited his good mood. I tried all the days to make it on my own, but without success. That’s why I contact the community. Any help in any kind is welcome and would like to thank you in advance for taking the time to read my request. If it could come to a solution, I would not only be happy, but also to do a somersault ... and that at my age :-))1.2KViews19likes2CommentsStock Data Types Wont Refresh - Provides Erroneous Error Message
I have an Excel workbook I created a few months ago and this afternoon while I was away, the "stocks" data type refresh feature stopped refreshing. The error message I receive instructs me to sign in to an account associated with this product (Excel), but I am clearly signed in. To be sure, I sign out and sign back in. Hit 'refresh' and receive the same error message. MS tech support tried to make a manual repair during a chat session, but it still will not refresh. Any thoughts? Thanks in advance.31KViews18likes195CommentsPLEASE VOTE!!! for Additional function for formatting cells. Adjust cell size to text length
Your vote counts!!! Adjust cell size to text length Additional function for formatting cells. https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/41191999-additional-function-for-formatting-cells Additional function for formatting cells. Adjust cell size to text length. At the moment there is in the menu of cell format, alignment, among other things the possibility to adjust the text size on the cell. In addition to this function, it would be very helpful if there was a box to click on where the cell would be adapted to the font size. If you like the idea, please click on the link and vote!999Views18likes3Commentsentering the working time, automatically marked with color in the timeline.
When entering the working time in a time entry, this time should be automatically marked with color in the timeline. Is this possible? if yes... how? TEST Sheet Ps. My knowledge in Excel is not the best, but my knowledge in VBA is almost non-existent 😞 Any help is welcome Thx in Advance NikolinoSolved5.7KViews18likes35CommentsVBA - Show data selection in pop-up menu
Hi Guys, have a "little" problem where I need a little help. I have a user form with a list field where I take data from a table from another worksheet. My problem is that it only shows the labeling area and not the data. VBA Code in Scheet1 Option Explicit Private Sub Worksheet_BeforeRightClick(ByVal Target As Excel.Range, Cancel As Boolean) Me.Unprotect ("1234") If Not Intersect(Target, Range("G5:EZ6")) Is Nothing Then Cancel = True ASK_Auswahl.Show End If Me.Protect ("1234") End Sub User Form in sheet 1 Sheet2 - table where the data is taken from Properties window in lists Box1 How can I get all data from Sheet2 to be displayed in the user form? Thx in Advance 🙂 NikolinoSolved5KViews16likes3Comments