Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!
Get external data from web not showing
Hello, I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea why this might be happening? See attached a screenshot of what I'm getting. Shouldn't that option be appearing between the "From HTML" and "From Text" options? I'm on Microsoft Excel for Mac, version 16.23 (19.03.09) Thanks in advance, Pedro
Excel 365 on Mac - Issue with refreshing data types
I am getting error message "couldn't refresh data types, we need to fix your account, sign out and sign in again. I am getting this message after upgrading to MacOS Ventura 13. signing out and signing in again didn't resolve, anyone facing similar issues. Do we have a resolution to this Regards RameshHave an Excel question?
Ask the Excel team anything. Get your questions ready for the Excel team! Join our Reddit AMA this Thurs. November 17th at 12pm EST. https://www.reddit.com/r/excel/comments/5aonww/microsoft_excel_product_team_ama_november_17th/ Related Excel Resources: Besides this community we also have a large set of related resources for Excel. From training videos to Hands on labs, from support to feature request. Here are the top links for Excel: Excel Basics Guided Learning: Excel LinkedIn Learning Videos Excel Documentation More Excel Learning YouTube Videos Excel Intermediate-Advanced Guided Learning: Data Analysis using Excel at edx.org Analyzing and Visualizing Data with Excel at edx.org Excel Hands On Labs Analyzing Data in Excel Hands On Labs Get and Transform Data Hands On Labs Excel Data Model Hands On Labs Support Documentation: Excel Documentation What is new in Excel Product and bug support: Excel Support Community: Excel Community Request a Feature: Excel Feature Requests Blog: Excel Blogs Demo Files: Excel Demos Download trial version of Excel Try Power BI for pre-built dashboards On Demand Excel session from Microsoft Ignite: Excel sessions at Microsoft Ignite 2016Fill BLANKs down, up or both in column(s) - similar to Power Query
Hi Looked at +/- replicating Fill Down and Fill Up functionnalities in Power Query with a LAMBDA. My attempt below: // FillDownUp: =LAMBDA(array, LET( Data, DROP(array, 1), DataCols, COLUMNS(Data), FillCol, LAMBDA(array, SCAN( IF( ISBLANK( TAKE(array, 1) ), XLOOKUP(FALSE, ISBLANK(array), array, ""), "" ), array, LAMBDA(seed,x, IF( ISBLANK(x), seed, x)) ) ), FillStack, LAMBDA(seed,col, HSTACK( seed, FillCol( CHOOSECOLS(Data, col) ) )), DataFilled, IF(DataCols = 1, FillCol(Data), DROP( REDUCE(0, SEQUENCE(DataCols), FillStack),, 1) ), VSTACK(CHOOSEROWS(array, 1), DataFilled) ) ) Open to alternatives...
WHERE IS THE "Check for Issues" button on the INFO TAB?????
Is Microsoft kidding me??? I spent the last HOUR troubleshooting with THREE different technicians where this option is and NONE of them knew how to troubleshoot! I am using EXCEL on a MACBOOK PRO. When you navigate to FILE > INFO, a panel shows up that includes a "Check for Issues" button, but NOWHERE is it shown. To make things EASIER for you, go to this link: https://www.exceldemy.com/excel-hidden-rows/ Hit the CMD + F (if you're using a MAC), On the Search Bar type in: Delete Excel Hidden Rows It will navigate you to the TITLE SECTION with that exact text. Read the section within that titled: 2.1 Use ‘Inspect Document’ Option to Delete Hidden Rows in Excel You will see exactly what I'm talking about. My issue: THERE IS NO "CHECK FOR ISSUES" OPTION VISIBLE. WHERE IN THE F-CK IS THAT OPTION? I AM PAYING EXCEL A $100 YEARLY SUBSCRIPTION JUST TO HAVE THEM MAKE ME DO THEIR JOB FOR THEM. THIS DOESN'T MAKE ANY SENSE! IF THIS ISN'T IMPLEMENTED, THEN IMPLEMENT IT! HOW CAN MICROSOFT MAKE MAC USERS PAY FOR A PROGRAM WHERE THEY DON'T EVEN ADD THE FULL FUNCTIONALITIES FOR A WINDOWS COMPUTER? WHAT THE HECK?????
unpivot data and handle merged cells without using Power Query (Unpivot_Toolkit)
Hey, guys!! I’ve been working on a set of functional Excel Lambdas to solve a common headache: transforming "Wide" human-readable data into "Long" database formats without having to open Power Query every time. =UNPIVOT_PLUS(table, [no_of_cols], [no_of_headers], [attribute_names], [value_name], [remove_errors], [remove_blanks],[pad_blanks_with],[pad_errors_with]) Don’t worry about the full list, most use cases only require 5 arguments. I've included a table of default values at the end. Merged Cell Support: Automatically handles fill-down/fill-right logic for merged headers/columns. Bonus Helper: SPLIT_INJECT =SPLIT_INJECT(array, target_indices, delimiter, [ignore_empty], [match_mode], [pad_with]) It targets specific columns, splits them by a delimiter (like TEXTSPLIT), and expands the entire table horizontally while keeping all other columns perfectly stable. Optional arguments match TEXTSPLIT defaults. Feel free to tear this apart or adapt it for your own edge cases. I’d love to hear how you end up using it! You can grab both functions from my GitHub Gist https://gist.github.com/Medohh2120/f8553c149684e39bb499249e39f01017. Argument Description Default Behavior table The array or range of data to unpivot. Required argument (no default) [no_of_cols] Fixed left columns to keep as identifiers. 1 [no_of_headers] Top rows used as headers, handling merged cells. 1 [attribute_names] Header name for the unpivoted attributes . "Attribute" [value_name] Header name for the unpivoted values. "Value" [remove_errors] Excludes grid rows with formula errors. FALSE [remove_blanks] Removes grid empty cells and empty strings. TRUE [pad_blanks_with] Value to substitute for empty cells. Leaves cell blank [pad_errors_with] Value to substitute for errors. Leaves error as-is
