excel
99 TopicsInsider status / membership / icon disappear
After installin Visio 2024 I lost my Insider status I have Microsoft 365 Subscription (consumer) (actually I have more subscriptions but active is consumer) Formarly I had joined Insider but now there is missing any connection to insider HOw to get back Insider Henn (very long time insider and MCT since 1996)59Views0likes2CommentsInsert pictures in cells in Excel
Hey everyone, Fantastic news! Excel now supports the ability to insert pictures directly into cells! This new feature enriches your worksheets, making it even easier to comprehend your data and glean insights. Here's how it's done: select the cell where you want to place the picture, go to Insert > Pictures > Place in Cell, and choose one of the available sources. It's that simple! This feature is presently rolling out to Insiders running Version 2306 (Build 16529.20000) on Windows or Version 16.75 (Build 23070901) on Mac. We release our features gradually to ensure a smooth experience. So, if you haven't received this update yet, hang tight. Your feedback is greatly appreciated and can even help shape our future improvements. To delve deeper into this exciting new feature, https://insider.microsoft365.com/en-us/blog/insert-pictures-in-cells-in-excel We welcome any comments or questions you might have there. Your involvement truly makes a difference! Keep excelling, Genny Harrison Microsoft 365 Insider CM2.3KViews2likes1CommentCreate accessible PDFs with Microsoft 365 apps
Hi Microsoft 365 Insiders! In the spirit of Global Accessibility Awareness Day, let’s highlight the importance of creating PDFs that everyone can access and enjoy. Our latest blog post by Peter Wu provides a comprehensive guide on how to create accessible PDFs using Microsoft 365 apps. Blog link: Create accessible PDFs with Microsoft 365 Here’s why this matters: • Over 1 billion people worldwide live with disabilities. Making your content accessible empowers them to fully participate in the digital world. • Microsoft 365 apps have built-in tools that help you make content accessible as you go, including the Accessibility Checker that runs while you work. • When saving or exporting your document as a PDF, use the ‘Save or Export as PDF’ command to preserve accessibility features. Remember, ‘Print as PDF’ won’t keep your PDFs accessible. Let’s embrace these practices and ensure that our digital content is inclusive for all. Check out the blog to learn more about creating accessible PDFs and join us in making a difference! Thanks, Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android448Views0likes1CommentNew Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE
Hey Microsoft 365 Insiders, Great news for Excel enthusiasts! Excel now includes powerful translation functions, allowing you to translate and detect languages directly within your spreadsheets. The new TRANSLATE and DETECTLANGUAGE functions help break down language barriers, making your data more accessible and your workflow smoother. Discover how it works in our latest blog post by Gedion Alemayehu, Product Manager on the Excel team: New Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE NOTE: These are preview functions. Their signature and results may change substantially before being broadly released, based on your feedback. So, we do not recommend using these functions in important workbooks until they are generally available. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android6.4KViews2likes9Comments(Beta) Color issues with Dark Mode in Excel
I just downloaded the insider update that allows for a full dark mode in excel. A couple of things I've noticed: Black and white are inverted. If you select black for a font color, cell fill, or border color, you'll end up with white, and vice versa. If someone is in dark mode, they're going to get awfully confused when they try to change various colors of the cells they're working in and aren't getting the color they want to pick, especially for those who need to use specific colors in their spreadsheets for whatever reason. This isn't so bad with black and white; annoying as it is, you can still at least remember to choose black when you need white or white when you need black. But when you choose other colors, you often end up with a color that is vaguely in the family of the color you selected, but not really. Trying to select the standard yellow used for highlighting, and you end up with an almost pale gold-like color. An example of what happens with a few colors is shown in the picture, but every color is affected to some degree. This makes the dark mode feature almost entirely useless for those who rely on colored conditional formatting in some or all of their spreadsheets, as the colors selected in dark mode end up being completely different from the color you actually wanted to select, and it's nearly impossible to try to figure out which color you have to select to get something that even resembles the color you actually want. The colors of individual elements of a spreadsheet (Font color, highlighting, borders, etc.) should not be altered this severely based on whether or not dark mode is turned on.160Views0likes1CommentGROUPBY aggregating more than one column of data
In the early versions of Excel beta, we were able to create a formula like this: =GROUPBY(Table[Code], Table[[Duration]:[Expense]], SUM, 3) and this worked just fine. But now, the lambda SUM function is coming up with a #NAME error, even when I use the formula builder. Excel version: Microsoft Excel for Microsoft 365 MSO (Version 2404 Build 16.0.17521.20000) 64-bit Example attached.666Views0likes1CommentKeyTips now available in Office for Mac
Microsoft 365 Insiders, Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android1.1KViews0likes6CommentsNew Regular expression (Regex) functions in Excel
Hi, Microsoft, 365 Insiders! Calling all Excel enthusiasts! We're excited to introduce three new functions that use Regular Expressions to help parse text more easily: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. Jake Armstrong, Product Manager on the Excel team, takes a look at and shares insights on each powerful function in our latest blog: New Regular expression (Regex) functions in Excel Thanks, Perry Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android4.1KViews1like8CommentsData Types and StockHistory Missing in Beta
I recently upgraded to latest beta release update (Version 2502 - Build 18502.20000) and noticed that Data Types have now disappeared from the Data Ribbon in Excel. STOCKHISTORY formula still shows up as a usable formula, but when I enter the fields, I now get a #CONNECTION error. Has Stocks as a data type now been removed from the newest versions of Beta or is this a bug? Anyone else experience the problem?42Views0likes0CommentsThe pandas code read_excel() does not work in Python/Excel, unlike in native Python.
I have an issue when I try to read a specific workbook in Excel using pandas read_excel() The following code was tested natively and it worked: import pandas as pd pth = "C:/Users/XXXX/Python 101/SUBPATH/" input = "inputworkbook.xlsx" wb = pth + input df1 = pd.read_excel(wb, sheet_name="Sheet1", skiprows=1) When I try to execute it from an excel workbook, I got this error message : FileNotFoundError: [Errno 2] No such file or directory: 'C:/Users/XXXX/Python 101/SUBPATH/inputworkbook.xlsx' Could you explain me why it doesn't work the same ? (Thanks)Solved12KViews1like10Comments