Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
0 answers
In Power Query, how to sort non-english strings?
I can sort according to the Turkish alphabet in Excel. When I sort the same table in Power Query, it does not sort in Turkish. Excel and power query window region setting is Turkish.
asked 2024-06-19T16:24:49.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 5%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHZ%3C/text%3E%3C/svg%3E)
Hakan Özhan
0
Reputation points
edited the question 2024-06-19T20:10:34.2033333+00:00
Hakan Özhan
0
Reputation points
0 answers
How to display fractions as decimal sixteenths
Ok so this a srange request. I want excel to display fractions and decimals in decimal sixteenths. What I mean by that is 1/16 is .01 1/8 is .02 3/16 is .03 so on and so forth. Is there any way to accomplish this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 44%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
How to Protect a TABLE
I have a user that wants a spreadsheet designed with some specific requirements. There is a Named TABLE on a sheet. (There is other data in this sheet not in the table.) The user needs to allow the user to ENTER data into the table (add Rows) but needs…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 23%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
I am interested in the algorithm used for cumulative probability distributions - specifically normal and chi square. Where might I find this?
I simply want to know what algorithms are used to calculate cumulative normal and chi-square distributions.
asked 2024-06-18T13:30:31.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 21%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
John Morris
20
Reputation points
commented 2024-06-19T16:04:12.0933333+00:00
John Morris
20
Reputation points
0 answers
Product Keys provided is for Microsoft LTSB version, but we are unable to install this version on our jump host server. How can we proceed?
We are able to download LTSC version on jump server, but we required LTSB version for product key activation. For MS license Activation. Due to LTSC version we are unable to implement product keys. Please provide us contact details or support email for…
asked 2024-06-19T13:58:25.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vaibhavi Rastogi
0
Reputation points
asked 2024-06-19T13:58:25.65+00:00
Vaibhavi Rastogi
0
Reputation points
0 answers
I can't sign in to Excel due to Error - Something Went Wrong [1001]
Here are the troubleshooting details, I have already been on other questions with same topic and none of the solutions helped - Correlation Id: cf49974d-5f0c-4f8b-9042-5ef02f81aaa4 Timestamp: 2024-06-19T12:47:11.000Z DPTI:…
asked 2024-06-19T12:52:20.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 86%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Manas Damle
0
Reputation points
asked 2024-06-19T12:52:20.8466667+00:00
Manas Damle
0
Reputation points
0 answers
Auto reminder mail in VBA based on data in excel
Hi, i want to put a process ..we have formal RO process for radio industries.....when we don't have formal RO ..we book the deal and they promise to send formal RO in in a day or two....if we don't receive formal ro in a two days then we need to send a…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
asked 2024-06-18T17:16:10.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 96%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jayant
0
Reputation points
edited the question 2024-06-19T03:00:04.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
1 answer
Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia
Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…
asked 2024-06-18T06:28:41.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Body and Sole Podiatry
0
Reputation points
answered 2024-06-19T02:40:31.74+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
1 answer
Ctrl+Enter Not Working in Excel
I am using a brand new Mac M3 with Parallels and my ctrl+Enter keys are not working as they used to in my 10-year-old Mac. Specifically, I used to be able to use ctrl+Enter to propagate results to all cells in a range, but this is no longer working.…
asked 2024-06-18T06:31:02.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nicola Cardi
0
Reputation points
answered 2024-06-19T01:54:54.7466667+00:00
Emi Zhang-MSFT
23,031
Reputation points Microsoft Vendor
1 answer
Refreshing a Pivot Table Deletes Columns
Hello, I'm currently working on a collaborative file that contains a lot of Pivot tables. When I refresh a Pivot that has 13 columns (12 months and a total), all the columns disappear except the one with the total. This also seems exclusive to my…
asked 2023-06-21T15:50:45.7166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 20%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E6%3C/text%3E%3C/svg%3E)
60795948
0
Reputation points
commented 2024-06-18T20:45:03.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHW%3C/text%3E%3C/svg%3E)
Holmes, William
0
Reputation points
1 answer
Is match with part of cell possible by a setting?
Does Excel have a setting so that there is a match in the functions XMATCH and XLOOKUP (and other such functions) even if the search string only partially matches the value in the lookup_array? Example: Something so that…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
asked 2024-06-17T23:33:54.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 83%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Regina Henschel
151
Reputation points
commented 2024-06-18T10:22:52.5766667+00:00
Regina Henschel
151
Reputation points
1 answer
One of the answers was accepted by the question author.
In excel, it is very hard to find the mouse stays in that cell, how to solve it?
In excel, the cell where the mouse is located will be identified with a thin black box, please, is there any way to modify the color and line thickness of this thin black box, so that the user can easily identify the mouse to stay in that cell? Thank…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,045 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
0 answers
This case is resolved with the new Excel formula INDEX
Content removed since I could not find a way to delete my post.
asked 2021-03-01T15:52:36.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 33%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rogerio Bettu
1
Reputation point
commented 2024-06-17T17:05:05.4366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
2,271
Reputation points
2 answers
convert excel column headers as row headers in azure data factory
need to convert below example input from excel source - id qn1 qn2 qn3 ................ max q50 1 qr1 qr2 qr3 ................max qr50 2 qr1 qr2 qr3 ................max qr50 desired output - id qn qr 1 qn1 qr1 1 qn2 qr2 1 qn3 qr3 . . 1 qn50…
asked 2024-06-13T04:34:41.5066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 57.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sudha Achuthan
20
Reputation points
commented 2024-06-17T15:39:15.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
5,110
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2021
CTRL + ; to insert current date in a cell CTRL + : to insert current time in a cell both don't work the command does not return anything.
asked 2024-06-02T14:04:32.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOC%3C/text%3E%3C/svg%3E)
Omar Cristian Martinez
20
Reputation points
commented 2024-06-17T10:38:27.4533333+00:00
Omar Cristian Martinez
20
Reputation points
1 answer
Insert rows for every combination of key columns values
Abstract Let us imagine a table big about 20 thousands rows. Of all the columns, three of them are key fields. For every combination of such key fields I need to enter a new row with a specific column set to 0, and copying every other cell's…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
asked 2024-06-14T09:55:59.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 40%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIT%3C/text%3E%3C/svg%3E)
Ishtar Terra
40
Reputation points
edited the question 2024-06-17T03:00:57.2733333+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
0 answers
Is there a way to retain the custom add-in even if break links is performed?
I created a custom formula (in a new add-in) and during one of steps in my macro all the links of the workbook gets broken. Due to this the custom formula gets pasted as values. Is there a way to retain the custom add-in even if break links is performed?
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
asked 2024-06-15T04:42:41.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srivatsan N
0
Reputation points
edited the question 2024-06-17T02:31:35.7633333+00:00
Jiajing Hua-MFST
6,745
Reputation points Microsoft Vendor
0 answers
Help with Excel (Online) script that creates a table of contents, but only for visible sheets
Hello. I want to use the Excel online script found here: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/table-of-contents However I'd like for it to only work for visible sheets within the workbook. I've tried to do this myself,…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
912 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
asked 2024-06-14T06:59:45.0566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Im.DavidJ
0
Reputation points
edited the question 2024-06-17T00:33:56.09+00:00
Emi Zhang-MSFT
23,031
Reputation points Microsoft Vendor
0 answers
Excel script executable by button in workbook once only once, but fails with an error "the button cannot run since the script was unshared. Contact the owner to share it again" when clicked twice.
Created an excel script, and added a button to the excel workbook. This script is owned by and linked to my account. But since the workbook is accessible to my whole organisation, people are able to execute this script by using the button added. While…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,400 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,652 questions
asked 2024-05-07T08:47:24.0733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 76%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Anshal Mukesh Lad
10
Reputation points
commented 2024-06-16T13:34:00.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHD%3C/text%3E%3C/svg%3E)
Hans Douma
0
Reputation points
2 answers
Large Excel file: Suddenly the links are shifted to the cell in the preceding row.
I have a large Excel file (8025 lines). (Microsoft® Excel® 2021 MSO (Version 2405 Build 16.0.17628.20006) 64 Bit) One column (column C) contains names of historical persons; example: Victoria (Vereinigtes Königreich) To each cell (= historical person)…
asked 2024-06-06T06:13:52.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hans-Heinrich Hartmann
0
Reputation points
edited a comment 2024-06-15T12:30:20.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 28.000000000000004%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hrag Hayrabedian
0
Reputation points