1,810,045 questions

Sort by: Updated
9 answers One of the answers was accepted by the question author.

variable xlookup

i have a number in cell AR20 and AR21 - these numbers will change when my spreadsheet is in use so lets assume my numbers initially are 21 and 22 respectively I have a look up chart in B20 to AL56 i want Xlookup to read AR20 [no. 21] down column B - that…

Microsoft 365 and Office | Excel | For home | Windows
asked 2023-05-10T09:20:50+00:00
Anonymous
10 answers

how do I add my name and initials to track changes

I need to add my name and initials to track changes

Microsoft 365 and Office | Word | For home | Windows
asked 2023-04-24T15:57:37+00:00
Anonymous
3 answers

VBA MACRO - COPY DATA FROM MULTIPLE CSV FILES IN A CONSTANT FOLDER TO A NEW WORKBOOK (IN .XLS)

To whom it may concern, I would like to ask you if you can help me on this issue. I am writing a Macro in VBA to automatize a process. What I want to do is listed as follow: I have many *.csv files in a folder and I want to copy some dates from these…

Microsoft 365 and Office | Excel | Other | Windows
asked 2023-03-17T14:48:00+00:00
Anonymous
1 answer

Excel 365 On Line: End-Shift-Down Arrow button does not work

I use End-Shift-Down Arrow to highlight columns of numbers all of the time. Now that we are working on the online/web version of Excel, it does not work and I am stuck scrolling down thousands of rows. What is the work around? I've searched but…

Microsoft 365 and Office | Excel | For business | Windows
asked 2023-03-13T21:48:15+00:00
Anonymous
16 answers

Where can I find folders locally on Android that I have set as "available offline", such that other apps can make use of them?

I'm trying to synchronise notes on the program/app Obsidian on Windows and Android. One important feature of this app is that it can take any folder and use it as the "vault" where notes are stored. Using the Windows version of the app, I have…

Microsoft 365 and Office | OneDrive | For home | Android
asked 2023-06-09T14:25:18+00:00
Anonymous
1 answer

my SEND button has disappeared. How do i get it back

my send button on hotmail has disappeared. how can i restore it

Microsoft 365 and Office | Install, redeem, activate | For home | Windows
asked 2023-01-13T16:20:58+00:00
Anonymous
1 answer

how to safely find and remove duplicate files

how to safely find and remove duplicate files

Microsoft 365 and Office | Word | For home | Windows
asked 2023-02-13T02:16:56+00:00
Anonymous
1 answer

ORG CHART SMART ART DISAPPERED

I made a whole organizational chart saved it and now I'm having a very difficult time trying to edit the whole diagram. The text panel won't appear in addition to all the other smart art design features. Please help. I am in a time crunch to fix this…

Microsoft 365 and Office | PowerPoint | Other | Windows
asked 2023-03-24T13:33:37+00:00
Anonymous
2 answers

Trying to change date format from MM-DD-YYYY to DD-MM-YYYY

I am trying to change the date format from MM/DD/YYYY to DD/MM/YYYY after changing the region setting. The date on formula bar shows the correct one but does not reflect it in the cell,I have restarted the computer but no change in the outcome. I am…

Microsoft 365 and Office | Excel | For home | MacOS
asked 2023-06-05T01:28:02+00:00
Anonymous
2 answers

Why is Forms not refreshing after it's completed?

Once the form is completed and submitted, it does not refresh to a new form anymore, it stays on the previous one. Before I would complete the form, save as a pdf and then it would give me the option to click "submit another response" now it…

Microsoft 365 and Office | SharePoint | Other | Windows
asked 2023-01-23T14:45:38+00:00
Anonymous
4 answers One of the answers was accepted by the question author.

How do I delete a line of special characters in Word?

How do I delete a line of special characters in Word? In a Word document I entered three asterisks then I inadvertently hit the Enter Key and the asterisks repeated to the end of the line as little squares. I am unable to delete the line. A backspace at…

Microsoft 365 and Office | Word | For home | Windows
asked 2023-01-28T22:56:31+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Can and how when using TEXTSPLIT can it be converted to show as a colunn instean of a row.

When I use PivotData, all the results appear as per screenshot in row 5. How using TEXTSPLIT can it be converted to each cell down. (DAX codes interfere with what I…

Microsoft 365 and Office | Excel | For home | Windows
asked 2023-06-26T19:17:33+00:00
Anonymous
5 answers

Your account was not set up on this device because device management could not be enabled.

This message used to appear when logging in, but nowadays I can't authenticate my student college's MICROSOFT 365 account because of this. I connect nowadays and it doesn't even show any messages, just simply won't authenticate. And it will work in any…

Microsoft 365 and Office | Install, redeem, activate | For education | Windows
asked 2023-03-12T13:18:31+00:00
Anonymous
1 answer

Can a SharePoint list automatically create subtasks when a new item is created?

I'm trying to develop an Engineering change log, where when a new change is being implemented an item is added to a SharePoint list that will automatically populate subtasks, or child tasks, that can be assigned out to different departments. Looking to…

Microsoft 365 and Office | SharePoint | For business | Windows
asked 2023-05-04T14:38:20+00:00
Anonymous
15 answers

Excel Function and VBA Coding

Dear Sir, I want to know if there is a function in Excel or VBA feature in Excel wherein we can insert particular value say cell no AA87 value in Table of Cells like below table in appropriate cell based on row and column number , Column Number is…

Microsoft 365 and Office | Excel | For home | Windows
asked 2023-02-09T08:39:49+00:00
Anonymous
6 answers One of the answers was accepted by the question author.

Force a spreadsheet to re-calculate each day using VBA

This question is a re-statement of mu previous question "How to force a spreadsheet to recalculate even when no changes are made REPOST". I'm posting this new question because that question has had little response. This is not to disparage the…

Microsoft 365 and Office | Excel | For home | Windows
asked 2023-04-07T04:02:43+00:00
Anonymous
3 answers

I need an excel formula for a truck load out for our company vs invatory

Looking to look at our inventory of equipment which consist of different values of each piece. Which I have done so far and had a value returned to how much = per load out for each piece of equipment. Now I need to make a formula that if all the columns…

Microsoft 365 and Office | Excel | For business | Windows
asked 2023-01-23T13:09:59+00:00
Anonymous
19 answers

OneDrive Can't Start - How to remediate?

1 This "OneDrive can't start" error has been reoccurring on a number of our User's devices. Reset commands within the Package contents of OneDrive have been unsuccessful in efforts to remediate the issue. This error has been present primarily…

Microsoft 365 and Office | OneDrive | For business | MacOS
asked 2023-01-31T17:37:49+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

Non-Programmer Needs to Disable "Excel Found a Problem With One or More References"

Hi! I'm working on my custom 2023 budget in Excel and keep encountering the most ANNOYING issue: I'm patterning this year's custom budget after last year's. However, despite copying the sheets over, I've made multiple changes to each sheet for 2023,…

Microsoft 365 and Office | Excel | For home | MacOS
asked 2023-01-08T22:00:15+00:00
Anonymous
2 answers

Help with Microsoft forms and formulas populating in workbook

Hello, I am using Microsoft Forms and have noticed that when respondents enter free-text numbers in the form, the resulting data in the connected Excel workbook is not recognized as numeric values. This issue is hindering my ability to perform…

Microsoft 365 and Office | Excel | For business | Windows
asked 2023-06-15T20:46:54+00:00
Anonymous