19,666 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
3 answers

How do I get the shown date pattern to continue through the year in Excel?

I am trying to get this date pattern to continue. Is there a formula I can use to continue through the year?

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T21:14:04.1366667+00:00
Michael Nelson 0 Reputation points
edited an answer 2025-12-06T03:13:42.5666667+00:00
Dana D 0 Reputation points
2 answers

Unable to insert rows or copy and insert rows into all worksheets on my workbook.

I have read through multiple threads and had no success with any recommended fixes. Problem- all of a sudden, I am unable to insert rows and or copy and insert a row on all worksheets within the workbook I use on a daily basis. I verified on another…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T17:58:59.1033333+00:00
SSJ Phx 0 Reputation points
commented 2025-12-06T00:05:48.1833333+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
2 answers

Hyperlinks

Sheet 1 A1 is hyperlinked to sheet 2 D4, How the can i the return values from sheet 2 to sheet next to the Hyperlink. I need look up references in SO/PO column back to the sheet 1. Sheet 1 ![User's…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-03T14:35:02.06+00:00
Amon Phiri 0 Reputation points
answered 2025-12-06T00:03:28.9433333+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
3 answers

Why can't I lock a sheet so users can't paste or drag/drop in to a cell. It breaks formulas and validations that should be locked

We use Excel for complex form templates which our clients fill out then submit to our system which then extracts the data in to a database. The problem is that our clients are dragging and dropping their information in to our forms and this breaks our…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T16:07:55.8666667+00:00
Hammond, Lawrence (MOH) 0 Reputation points
commented 2025-12-05T23:16:34.2933333+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
5 answers

I want to create a printable, filtered “weekly/monthly view” from my annual schedule in Excel.

I want to create a printable, filtered “weekly/monthly view” from my annual schedule in Excel. I can have one tab for Monthly Schedule and another tab for weekly

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-11-26T18:22:32.21+00:00
Treeva 1 Reputation point
commented 2025-12-05T22:57:15.4833333+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
2 answers

How to get macros to work on office 2024

Please help with this issue of not able to get macros to work on office 2024 on my desktop pc.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T22:14:07.1033333+00:00
Scott Miller 0 Reputation points
commented 2025-12-05T22:42:38.1366667+00:00
Jay Tr 6,125 Reputation points Microsoft External Staff Moderator
2 answers

How do I search and import data from one spreadsheet to another?

I have two spreadsheets: 1 with employee names (Sheet A), and another 1 with employee names and their supervisors (Sheet B). How can I compare/import the list of individual supervisors from Sheet B to the appropriate employee's record/data field in Sheet…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T18:19:53.92+00:00
Yarberry, Jeffrey - MRP-APHIS 0 Reputation points
commented 2025-12-05T22:20:54.1266667+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
2 answers

in Excel the text cursor is replaced by the eraser icon (eraser with the little star on the top left corner) each time i switch from screen to screen

Im working in Excel and when i go to another screen and go back to excel the text cursor in excel is replaced by the eraser icon (eraser with the little star on the top left corner) each time i switch from screen to screen.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T15:50:59.7833333+00:00
Anonymous
commented 2025-12-05T22:20:18.13+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

I want to create a summary table of three sheets, but only using data that meets specific criteria.

I have three excel sheets with columns A-J. I want to make a summary table that only includes columns A, F and G. Additionally, I want to only add items to my summary that have an item in Column F. Is there a way to do this using XLOOKUP or VSTACK? The…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-03T20:18:44.1733333+00:00
Pey 20 Reputation points
commented 2025-12-05T22:16:58.2966667+00:00
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator
2 answers

“ERR_BLOCKED_BY_RESPONSE.NotSameOrigin / CORS Errors in Excel Online”

Hello, There seems to be a problem with pivot table in web excel. We're using Business Standard version of subscription. What errors we're getting in devconsole: Failed to load resource:…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-02T14:54:14.9166667+00:00
Mateusz Zajączek 0 Reputation points
commented 2025-12-05T22:00:05.5033333+00:00
Killian-N 6,375 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft has blocked macros, the source is untrusted.

Microsoft has blocked macros from running because the source of this file is untrusted. This is happening to a couple of my excel programs and it is killing productivity. any suggestions? I already followed their guidelines on how to unblock but none of…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T18:58:34.28+00:00
Geoff MacPherson 0 Reputation points
answered 2025-12-05T19:50:40.6866667+00:00
Killian-N 6,375 Reputation points Microsoft External Staff Moderator
3 answers

HOW TO VALIDATE IF ATTENDEES IN A MEETING ARE ALL FROM THE SAME STATE

Any assistance will be greatly appreciated. Spent hours trying to figure this out. Maybe I am not using the correct function or something. Please HELP. I need a formula to validate if everyone in a meeting (Col A) has the same state (Col D). If they…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-02T19:55:55.69+00:00
TERI RICE 0 Reputation points
edited an answer 2025-12-05T19:28:01.17+00:00
Dana D 0 Reputation points
2 answers

How do you create an email distribution list from an excel list of contacts?

I have an excel contacts spreadsheet with their email addresses and want to send a holiday message to everyone on the list.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-02T21:42:39.0066667+00:00
Jonathan Krueger 0 Reputation points
edited a comment 2025-12-05T18:42:21.11+00:00
Ruby-N 5,890 Reputation points Microsoft External Staff Moderator
5 answers

Pivot Table setting wont appear

When I right click on a pivot table and select "show setting" nothing happens and I am unable to format my table the way I would like. This happens in all documents and newly created ones. When I create a pivot table, the field list will appear…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-11-21T22:19:09.13+00:00
Uchenna Chidozie 125 Reputation points
commented 2025-12-05T17:09:42.72+00:00
CR 5 Reputation points
2 answers

Connecting a SharePoint Folder to PowerBI

Hi all,  My apologies if this isn't the correct place to post this but I am trying to connect a SharePoint folder to Power BI and am getting a lot of results back. The site I connect to has a very large quantity of documents and the specific path I'm…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T14:34:26.27+00:00
Kareem Culbertson 50 Reputation points
answered 2025-12-05T16:15:45.1933333+00:00
Kai-L 7,005 Reputation points Microsoft External Staff Moderator
1 answer

Categorise a date based upon a conditional date range

Hi, I have a column of different dates (DD/MM/YYY) and I want to create a formula to look up each date and, based upon a specified date range, report that date as a pre-specified category in a different column. In the example below, I want the formula…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T06:10:05.5366667+00:00
Office worker 125 Reputation points
commented 2025-12-05T16:14:53.9+00:00
Barry Schwarz 4,786 Reputation points
2 answers

vba editor font is too small

vba editor now displays text in a hard to read font. how do i enlarge the font in the excel vba editor

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T10:47:52.2433333+00:00
DavidFournier-4139 0 Reputation points
commented 2025-12-05T15:57:39.97+00:00
Julie-Hu 4,945 Reputation points Microsoft External Staff Moderator
2 answers

Spreadsheet Compare no longer is able to save results to exported Excel file

In our company we no longer can export results from "spreadsheet compare" to a new excel file or an existing excel file. No matter where the target file is located. Office: 2502 Build 18526.20660 (semi-annual channel) Windows 11 23H2 Build…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-05T12:27:25.63+00:00
Mokusch, Silvia 10 Reputation points
answered 2025-12-05T15:24:26.2533333+00:00
Mokusch, Silvia 10 Reputation points
1 answer

Annoying Microsoft Excel Formula Pop-up Guide

Dear Developer Team, Have u ever try ur own product? have u experience how hard it is after these years? why this formula guide always blocking the column alphabet? how r we supposed to click it to select the column? this is the most annoying ms excel…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T07:15:48.29+00:00
Haris Hidayatulloh 0 Reputation points
commented 2025-12-05T13:49:56.34+00:00
Phoebe-N 6,805 Reputation points Microsoft External Staff Moderator
1 answer

Excel showing symbols instead of letters when typing

I seem to have pressed something by accident when leaving paperwork on my keyboard as when I type symbols are displaying instead of letters on excel only.

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-04T11:38:39.59+00:00
Chris Garnett 0 Reputation points
commented 2025-12-05T13:41:27.45+00:00
Tamara-Hu 8,240 Reputation points Microsoft External Staff Moderator