Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
57,133 questions with Microsoft 365 and Office | Excel | For home | Windows tags
9 answers
Issue with Excel Copying and pasting
Hi there, My Excel has suddenly stopped C&P correctly. I have some text in cells, but I only want to copy and paste a specific part of that text into another cell. However, even when I double click, highlight the text that I want and press CTRL + C,…
Microsoft 365 and Office | Excel | For home | Windows
asked 2026-03-24T20:55:36.31+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, 46%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marco McVey
45
Reputation points
commented 2026-03-27T04:57:23.6866667+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(102.4, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Syed Zilan Ahamed
0
Reputation points
2 answers
Excel formula
Is there an excel formula which will automatically add .01 or .02 to a list of numbers that are duplicative?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-24T21:42:48.7533333+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, 94%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Michael Glaspy
20
Reputation points
commented 2026-03-26T23:39:33.7066667+00:00
Michael Glaspy
20
Reputation points
2 answers
Display multiple pages
I want to have two pages open simultaneously so I can compare numbers across tabs.
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-05T21:53:35.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(252.8, 49%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Michael Osborne
0
Reputation points
commented 2026-03-26T21:52:00.6466667+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(284.8, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kal-D
6,030
Reputation points Microsoft External Staff
Moderator
2 answers
In Excel I am having problems printing out sheet page heading. Columns titles print OK but page title does not print. The page title shows on prewview but does print on document.
Please advise why my document does not show Page title. It appears on the pre-view but does not print out, Column headings all OK.
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-02-25T05:26:10.1366667+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, 89%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Donald Thomas
0
Reputation points
commented 2026-03-26T21:51:19.0566667+00:00
Kal-D
6,030
Reputation points Microsoft External Staff
Moderator
2 answers
Linked Data Refresh Error
I have a currency converter that automatically updates every time I open my document. EUR->USD. I just now noticed that it is no longer updating. I am getting an error: Couldn't refresh data types: You need to be online to refresh your linked data…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
![](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, 96%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
1 answer
Subtotal dialog dropdowns unresponsive in Hebrew UI (RTL)
Hi everyone, Has anyone encountered this issue? In the Subtotal dialog, the dropdowns for options such as "At each change in" and "Use function" do not work at all when the display language is set to Hebrew, but work perfectly fine…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
![](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, 45%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
2 answers
Why does My Office 365 suddenly NOT see that I'm connected to the Internet? What Changed?
Why does my Office 365 not see that I'm connected to the internet? Why has this changed?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-26T17:05:42.8233333+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(108.80000000000001, 23%, 20%)' 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)
Scott Anderson
0
Reputation points
answered 2026-03-26T17:41:47.9033333+00:00
DaveM121
856.3K
Reputation points
Independent Advisor
3 answers
Inserting a .csv Into a New Excel Worksheet
I exported google contacts to a .csv. I want to open the .csv in a Excel worksheet but having difficulties. I find no option to open a .csv anywhere in excel. According to an example I found on the internet I'm to click 'Data' and select 'From…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
![](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(38.4, 65%, 13%)' 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)
2 answers
The server couldn't complete this action. Error Code: 0x803d0014
How do I fix this error. I want to share a workbook in Excel. The server couldn't complete this action. Error Code: 0x803d0014
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-01T16:39:14.2233333+00:00
Stacy Black
0
Reputation points
answered 2026-03-26T08:08:35.94+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, 80%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Norah-L
4,615
Reputation points Microsoft External Staff
Moderator
2 answers
Split categories
How do I split a single transaction into multiple categories. For example if I am creating a checkbook register on excel. column 1 = date column 2 = check number column 3 = name of place column 4 = categories (drop down list) column 5 = withdrawal…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
![](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, 25%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Sorting a section of a column of data
[Moderation note: PII removed] In the attached example PDF there is a list of businesses and their employees in column A and the number of orders placed by those employees in column B. I have this information in an excel spreadsheet. Using a VBA macro I…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-24T10:08:23.0766667+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(67.2, 61%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Colin Cutts
20
Reputation points
commented 2026-03-26T06:10:39.67+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, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kai-H
13,595
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
buttons that don't work in the 365 version of excel
I have a brand new version of 365 excel that I have to pay ransom on but not all the buttons work. How do I get the freeze button to work when it's grayed out and inoperable in any way?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-26T03:18:48.3766667+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(233.6, 56.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK4%3C/text%3E%3C/svg%3E)
KellyGarner-4537
20
Reputation points
commented 2026-03-26T03:27:01.3233333+00:00
KellyGarner-4537
20
Reputation points
1 answer
Excel states it is out of resources
When trying to open Excel in Windows 365, the error message that Excel has run out of resources pops up. All cells contain either #DIV/)! or #CALC!
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T23:09:43.51+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(28.799999999999997, 63%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Keith Singer
0
Reputation points
answered 2026-03-26T01:00:56.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(22.400000000000002, 81%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Arlene D
32,850
Reputation points
Independent Advisor
2 answers
dot separator for date instead of /
I have Microsoft Office and Home 2021 In Excel I have been using a data log input CSV file from B&G Hercules marine processor for some time with no issues. In column one is date and time normally displayed as 11/23/2025 16:27:38.940. It now displays…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-05T23:28:43.97+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(76.8, 46%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
John Johnson
0
Reputation points
commented 2026-03-25T23:34:28.5133333+00:00
Kal-D
6,030
Reputation points Microsoft External Staff
Moderator
0 answers
making a dynamic vlookup foformulae to query a key like 728 where each number in the value retrieves a different value from a data set
dear support, i have a data set in excel as a list of events. for 1 specific day there could be many events for the day. i am trying to use excel 365 with vlookup to interogate a number and extract the value of left position 1, 2 and right , 1 i have…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
![](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(217.60000000000002, 59%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
1 answer
MS EXCEL: Unable to record a macro in Personal Macro Workbook
I'm trying to record a macro in the Personal Macro Workbook and I get two messages. "Personal Macro Workbook in the startup folder must stay open for recording" "Unable to record" Any suggestions?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T20:32:16.57+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(224.00000000000003, 62%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
J G Enterprises
1
Reputation point
answered 2026-03-25T20:32:27.3766667+00:00
Q&A Assist
1 answer
How to highlight all numbers of a specific value from two columns when a designated cell outside those columns is selected?
In an Excel file, I have 5 columns with about 60 cells filled with random years. Below the columns are sums for certain years from the columns above. I would like to be able to click G65 (2027 value) and have all the 2027 values highlighted in the…
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T17:20:13.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(83.2, 94%, 18%)' 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)
Jeremy
0
Reputation points
answered 2026-03-25T17:36:28.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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
83,190
Reputation points MVP
Volunteer Moderator
1 answer
How to insert a movie into Excel and uses macros to start and stop?
How to insert a movie into Excel and uses macros to start and stop?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T15:42:09.7033333+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(83.2, 85%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Lutz Bunger
0
Reputation points
answered 2026-03-25T16:42:09.57+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(44.800000000000004, 86%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jhun Buala
5,065
Reputation points
Independent Advisor
1 answer
how to open an excel spreadsheet after forgetting password
Forgot the password to a spreadsheet that was protected
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T16:13:53.6733333+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, 59%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tom Topping
0
Reputation points
answered 2026-03-25T16:14:03.61+00:00
Q&A Assist
2 answers
Excel Spread Sheet
How do I change the colors of the borders/lines in an Excel Spreadsheet?
Microsoft 365 and Office | Excel | For home | Windows
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
57,133 questions
asked 2026-03-25T15:08:40.9966667+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, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Lauretta Dickstein
0
Reputation points
answered 2026-03-25T15:46:50.58+00:00
riny
20,865
Reputation points
Volunteer Moderator