19,666 questions with Microsoft 365 and Office | Excel | For business | Windows tags
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
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
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
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
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
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
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
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
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
“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
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
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
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
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
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
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
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
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
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
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.