Forum Widgets
Latest Discussions
Excel Filter Not Working after Certain Row
Help! I have been trying all the tips online that I've found and nothing seems to work. I have a spreadsheet with a large amount of data and I have my columns filtered. I am continuously adding data daily. However, when I try to filter it will only apply the filter up to a certain row. I have no blank rows or merged cells. I tried going to the "advanced" option for filter and putting the range up to a certain row but that didn't work. I have also tried to select the data to turn the filter off then on, but when I select the data is greys out the filter button where I cannot do that. Any input and help would be greatly appreciated!Solvedjbabineaux92Jul 10, 2026Copper Contributor162KViews1like8CommentsText split
I have this informatie in a cel: WIJNVEEN 15693 | 88/38 | 31-12-2024 | [WIJNVEEN|15693] I need the two components at the end, the parts between [ and ] So one cel is "WIJNVEEN" and the second cel is "15693". Can anyone help with 1 formule for each cel, so no "in between" cels?MrsSandraJul 10, 2026Occasional Reader24Views0likes2CommentsStock Data Type - SPCX
I have spreadsheet that pulls Stock data and it has been working fine. Bought some SPCX shares and added SPCX to the Stock cell. Selecting Stock Data Type does NOT find SPCX in the list of shares. This is on the deaktop app. I tried this wth Excel Online and SPCX is found and works fine? I have also made sure the Desktop apps are all up to date. Any potential fixes out there?SolvedThuleniJul 10, 2026Tin Contributor59Views0likes3Commentsgenerate list
Good day! I have a file that has list of all names on one sheet. is there a way to generate on a different sheet list of names based on the first letter of the names? like in sheet1 would be all the names, sheet2 would be names starting in A-D, sheet3 names starting in E-J... TIA!BenjonBarachinaJul 10, 2026Copper Contributor47Views0likes4CommentsOPENED FILE AND ALL CHARTS WERE MISSING
So, I have been using this spreadsheet since 2014 and have always upgraded it to stay current. I had a file in Jan 2024 that I added data to and saved. Last month (Apr), I opened the file to add new data as I always have, and all my charts were gone. I've searched and cannot fight how these charts were deleted. It was not me. I've looked for fixes and there is little to no similar issue to mine unless my search was weak. I'm looking for ideas, and while I am not a computer engineer, I know Excel and lots more. I already tried the options, checkmark solution. Thanks in advance charleychas707Jul 10, 2026Copper Contributor3.5KViews0likes3Comments- vlopez0036Jul 10, 2026Copper Contributor40Views0likes2Comments
"Allow edit range" permission on Azure AD joined device
Hello. Many of our users use "Allow edit range" permission in excel. On domain joined devcies, users can search Windows AD to select the user to assign permission. However, on Azure AD joined devcies only local system is listed and thus permission cannot be assigned to a user. Has anyone faced this issue ad have found a resolution for this? How to use "Allow edit range" permission and select a user from Azure AD?atirek08Jul 09, 2026Copper Contributor2.1KViews1like7Commentshow to ignore conditional formatting for a cell that is not empty but invisible (cell format ;;;)
hi, i need help with a conditional formatting of cells that are not empty but invisible (cell format to ;;; (invisible)). I have a calendar where the dates are invisible (outside of the month) but the cell formatting applies to it (cuz it is that date, i.e., public holiday). i have attached the screenshots and i hope someone can help me out. thank you so much. regards, angelenghietan1986Jul 09, 2026Copper Contributor62Views0likes2CommentsSave or convert Excel spreadsheet to a Google doc
I created a spreadsheet in Excel but I need to now save it or convert it into a Google doc for someone who doesn't have MS Excel or Office. Is either way possible and how is it done? Thank you.DL0713Jul 09, 2026Copper Contributor8.3KViews0likes3CommentsAdd-in Excel Labs
Da tempo sto utilizzando l'add-in Excel Labs, soprattutto nelle sua funzionalità base di "Advanced formula environment" particolarmente utile nella compilazione di formule LAMBDA che stanno avendo un così grande sviluppo in questi ultimi tempi. La facilità nella redazione e nel debug inline delle formule, i commenti e la gestione delle stesse in "Gestione Nomi" ne ha fatto per me e penso per molti uno strumento eccellente che ovviamente non può essere paragonato all'edito base di Excel. Rivolgo perciò un invito a considerare possibile la sua implementazione direttamente in Excel come strumento alternativo all'editor di base . Ritengo che tutti potranno giovarne.alberto20Jul 08, 2026Tin Contributor30Views0likes1Comment
Tags
- excel43,877 Topics
- Formulas and Functions25,388 Topics
- Macros and VBA6,569 Topics
- office 3656,337 Topics
- Excel on Mac2,742 Topics
- BI & Data Analysis2,490 Topics
- Excel for web2,014 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,701 Topics