Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
0 answers
Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly
I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells. So i started testing for the latest non corrupt file and…
asked 2024-05-20T06:00:19.39+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(220.8, 48%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Abhinav Jain
0
Reputation points
commented 2024-05-20T08:48:39.54+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
5,475
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Creating a link from a word doc to a specific excel cell
Hi, I'd like to create a link from a word document to a specific cell in a workbook sheet. I have tried \ work book address #gid=.'pagename -'!$A$160. which initially takes me to the correct cell but I get a pop up box saying "reference isn't…
asked 2024-05-17T12:10:10.9733333+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(281.6, 37%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kirsten Affleck
20
Reputation points
commented 2024-05-20T07:58:25.78+00:00
Kirsten Affleck
20
Reputation points
1 answer
Print preview not matching document (inserted cell images)
I'm trying to create a document that will build an overall image based on smaller images in cells, but when I print, gaps will appear along row lines of the image (see 2nd image with highlighted areas). Any idea why this is, or if they can be eliminated?
asked 2024-05-17T11:35:52.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(182.40000000000003, 36%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Clinton.E
0
Reputation points
answered 2024-05-20T07:00:17.1266667+00:00
Emi Zhang-MSFT
22,236
Reputation points Microsoft Vendor
4 answers
create a 2nd chart from data in a worksheet from which a chart has already been created
Question 1 : I want to create a 2nd chart from alternative data in a worksheet I have already created a chart from different data in this worksheet. When I open a new worksheet to host the new chart, and insert a chart it creates a blank chart…
asked 2024-05-10T15:29:53.9266667+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(230.39999999999998, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Laurence Clerkin
0
Reputation points
commented 2024-05-20T06:02:05.9766667+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
1 answer
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,344 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 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,563 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,019 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,654 questions
asked 2024-05-17T09:55:50.3666667+00:00
gh X
30
Reputation points
answered 2024-05-20T05:52:48.8033333+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
2 answers
Issue with Excel Destination character size in SSIS
I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS 2019 excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…
asked 2024-05-17T11:41:58.3833333+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, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dhanvi Bansal
0
Reputation points
answered 2024-05-20T05:47:09.9266667+00:00
ZoeHui-MSFT
33,386
Reputation points
1 answer
why my XLSX file can't open by MS office, but it can open by libreoffice
open_by_libreoffice.png view_page_breaks_by_libreoffice.png open_by_google_sheet.png open_by_ms_office.png Hi developers, I've output a XLSX format file(Page breaks in Export to Excel.xlsx), which add some page breaks in the file(rowBreaks in…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,344 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
asked 2023-10-17T06:53:25.74+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(3.2, 47%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZC%3C/text%3E%3C/svg%3E)
Zhu, Chris
0
Reputation points
commented 2024-05-20T03:29:21.92+00:00
Zhu, Chris
0
Reputation points
0 answers
How to automatically jump to another cell after hitting enter
Hello All, is there a way to automatically move from the current cell to a specified cell after pressing enter or tab? For example: After entering data in cell H2 and pressing enter, cell H3 is selected. If I press tab, then cell I2 is selected. …
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,598 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,563 questions
asked 2024-05-17T21:01:24.8+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(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Constance Fischer
0
Reputation points
edited the question 2024-05-20T01:02:54.1966667+00:00
Emi Zhang-MSFT
22,236
Reputation points Microsoft Vendor
0 answers
How to convert Tint value with base color to System.Drawing.Color using OpenXml Library in C#?
Using OpenXml library i want to get the cell background color. when i tried with the below code i did not get the actual color of cell background. Please help me on this. private static BooleanResult<System.Drawing.Color>…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 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,563 questions
asked 2024-05-17T06:51:04.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(220.8, 79%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pritam Adak
0
Reputation points
edited the question 2024-05-20T01:00:06.0833333+00:00
Emi Zhang-MSFT
22,236
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to create a conditional Format that changes colour the closer it gets to a deadline?
Hello! I am trying to create a conditional format that changes colour 3 times , to a deeper shade each time the real time date changes, and is closer to the dead line, the deepest shade being the day of. lightest shade >7 days to complete middle…
asked 2024-05-16T13:32:03.1466667+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, 54%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lo's Pharmacy
20
Reputation points
commented 2024-05-17T12:49:47.08+00:00
Lo's Pharmacy
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Copy and past embedded images from one Excel file to another with Microsoft Graph on Sharepoint
Hello, Is there a way to copy and past embedded images from one Excel file to another with Microsoft Graph on SharePoint? I was able to copy the data from one Excel file to another with the following script but the format is not preserved and the…
![](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(211.20000000000002, 30%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
3 answers
Excel loosing trusted locations
Recently a client started having a problem where Excel 2021 is loosing its trusted locations for common things. Such as c:\users\username... People cant open excel files from their documents folder, downloads, server Z: drive. All of a sudden it causes…
asked 2024-05-08T14:20:32.3433333+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(249.60000000000002, 43%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bob Karon
21
Reputation points
commented 2024-05-17T07:43:21.36+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
3 answers
Excel cells maximum sum
Good evening to all, In excel in cells F8:F9 we have the numbers 17 and 11 respectively (sum 28), in cells M8:M9 we have the numbers 14 and 9 respectively (sum 23) and in cells T8:T9 we have the numbers 17 and 14 respectively (sum 31). I am looking for…
asked 2024-05-08T21:45:29.8733333+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(313.6, 6%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Νικόλαος Γιαννέλος
0
Reputation points
commented 2024-05-17T07:18:53.6366667+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm)
I am unable to refresh an excel spreadsheet pulling the data from Access Database. [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm) I can refresh other spreadsheets from the same access…
asked 2024-05-16T12:24:00.0533333+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(252.8, 73%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Trickett-Bell, Andrew
0
Reputation points
commented 2024-05-17T05:35:58.73+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
1 answer
when i paste a cell it results wrong value
when i paste a cell it results wrong value
asked 2024-01-30T15:57:35.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(60.8, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEJ%3C/text%3E%3C/svg%3E)
evelin john
0
Reputation points
answered 2024-05-17T02:34:17.37+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(92.8, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
S.Sengupta
15,676
Reputation points MVP
1 answer
Files that are encrypted through the sensitivity label.
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…
asked 2024-05-16T18:58:07.4566667+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(70.4, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIN%3C/text%3E%3C/svg%3E)
Iniobong Nkanga
1,681
Reputation points
answered 2024-05-17T02:31:41.2166667+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
macOS Excel v16.85 truncates string size to 126 characters for custom property values
In the latest release of Excel M365 for macOS (v16.85) we are experiencing an issue where when we use the Excel Javascript API via an add-in application to retrieve custom property values, where each custom property is truncated to 126 characters. We…
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,917 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
896 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,563 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
471 questions
asked 2024-05-16T20:50:25.2666667+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(131.20000000000002, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Colby Timm
0
Reputation points
edited the question 2024-05-17T01:23:10.41+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
Office Script to delete all rows in a table receives timeout error
I have an office script that is designed to delete all rows in a table. When I run it for 50 or less rows it runs with no problem, but times out when I test it for a larger number of rows (~600). Once this project is live I anticipate the table will…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 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,563 questions
asked 2024-05-16T14:08:07.1333333+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(169.60000000000002, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wewillendure
0
Reputation points
edited the question 2024-05-17T01:10:48.44+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
1 answer
HELP!!! MS Excel (MS 365 Family) on a Mac keeps lagging
Hello, Every 3-5 minutes the cursor my MS Excel would convert to the rainbow spinning wheel of death for about 30 second, which is extremely unproductive. Not to mention frustrating. During these lags, Activity Monitor shows MS Excel %of CPU…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,519 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
471 questions
asked 2024-05-10T02:44:21.4733333+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(211.20000000000002, 66%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Wong
5
Reputation points
edited a comment 2024-05-16T19:34:55.1466667+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(201.6, 85%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PM
0
Reputation points
1 answer
New version of excel is having permission issues with opening some files
Hello Please i need help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files. Had to roll back to the older 16.84 version for it to work.
asked 2024-05-15T16:58:34.16+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, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
266
Reputation points
commented 2024-05-16T18:04:13.4433333+00:00
IniobongNkanga-8038
266
Reputation points