Skip to main content

Questions tagged [excel-online]

Questions about Excel Online, part of the Office Online suite of web applications from Microsoft

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

Add Row Pointer Hand Cursor Adding Unintended Rows When Hovering Between Two Rows - Online Excel

Users are reporting that their cursor changes to a pointer hand when hovering between two rows on the row numbers. What is this new feature and how do I turn it off? It is causing unintended rows to ...
ComputerGiant's user avatar
0 votes
0 answers
13 views

How can I access files using Sheets or Excel Online from Dropbox when it's blocked by my organization?

I have a Dropbox account which has a few Microsoft Excel files that I want to edit from work. My organization has disabled Dropbox access and, as a result, I can't access the files from work. I don't ...
shahkalpesh's user avatar
1 vote
1 answer
2k views

How can I automatically refresh a pivot table in Excel 365 (web)?

I found https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2#ID0EBBF=Web, which says: However, I don't see the PivotTable Tools on the ribbon, even ...
Franck Dernoncourt's user avatar
0 votes
1 answer
154 views

Repeat a table for each row of another table

I have this table in Microsoft Excel Online: Col A (Month) Col B (Date) January 1/1/2023 January 1/2/2023 January 1/3/2023 And I have another table: Col C (Dept.) Col D (KPI) Dep1 KPI1 Dep1 ...
Sarah's user avatar
  • 35
2 votes
1 answer
141 views

How is alphabetization determined in Excel and Google Sheets?

I was recently sorting data in Google Sheets that involved the word "hello" in various languages. An excerpt of this sheet is below. Column C was calculated using the =UNICODE(LEFT(B2,1)) ...
Brooke's user avatar
  • 133
3 votes
2 answers
4k views

How to repeat a cell a set number of times in Excel?

I have two columns, the first with a description of an item, the second with the quantity of the item. I'd like to turn this into a list of the described items. I need the solution to work on Windows/...
jpfieber's user avatar
0 votes
1 answer
98 views

How to use data validation based on 2D array or row and column of tickboxes in google sheets?

Here, I'm attaching the part of the sheet which contains the tickboxes. Objective is to format the column A with green or red background colour. Rules: Data in column A should be green, if any of ...
Ganishk D's user avatar
1 vote
0 answers
58 views

Bulk Check Google Results Count with Google Docs

I need to extract the number of results by a given search in google, for example: 1 I search in Google.es Dinosaurs wallpapers and it returns to me: Approximately 77,000,000 results (0.48 seconds) I ...
user2593287's user avatar
4 votes
1 answer
287 views

How can I use a dark background theme for the cells for Microsoft Excel 365 (online)?

How can I use a dark background theme for the cells for Microsoft Excel 365 (online)? For Microsoft Excel 365 offline, I use the "Create new style" option. However for Microsoft Excel 365 ...
Franck Dernoncourt's user avatar
1 vote
2 answers
35 views

How get the cost price?

I have the following spreadsheet: For column B, the formula is simple: B1 + (B1 * A2) The question is: how to get the numbers in column C? I manually typed all values on column C but the idea is if I ...
Victor Santos's user avatar
0 votes
1 answer
54 views

Google Sheets Formula Not Working in Excel

I have this formula pasted below that works in Google Sheets, but not in Excel. I've looked up possible solutions, but just cannot find what may be the problem with it. The return I get is just the ...
plet9090's user avatar
0 votes
1 answer
215 views

Google sheets reference Text in Cell in Array Formula & Countif formula

So, I have a Array Formula and Countif formula in place because I need to know the total of entries in a combination of ranges. I need to know the sum of the number of cells that have "X" ...
Diana Teles's user avatar
0 votes
1 answer
2k views

When Excel 365 online indicates that a formula in a cell contains an error, where do I see the error message?

When Excel 365 online indicates that a formula in a cell contains an error, where do I see the error message?
Franck Dernoncourt's user avatar
0 votes
1 answer
2k views

How can one swap 2 columns in Microsoft Excel 365 if the sheet contains a sortable table?

I have a Microsoft Excel 365 file with a sheet containing a sortable table: How can I swap 2 columns in this sheet (e.g., swap column H with column I)? What I have tried unsuccessfully: Select ...
Franck Dernoncourt's user avatar
-1 votes
1 answer
20 views

I'm attempting to link a Master sheet with a Google Form for clock in/out hours. How would I do this?

I'm attempting to add hours to each person by having them submit a Google Form, which will display their ID and time logged into a linked sheet(This is done). I then need the hours to be filtered by ...
AnotherUser's user avatar
0 votes
0 answers
30 views

Max sum held over a month

I need help with a formula that needs to calculate the max sum held at one time for each month. In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
vaidab's user avatar
  • 1
0 votes
1 answer
841 views

Bulk Search Or Find a bunch of values at once

I have a list of order numbers that I get from one sheet & cross check whether they are there in another sheet (they shouldn't be, they would be the orders that we don't need so we delete them ...
Genny's user avatar
  • 365
1 vote
0 answers
56 views

Changing the value of a single cell based on 2 different cells

By using the IF function I am controlling the value of a cell based on the values of a different cell. For example: If the date in Column G is bigger than TODAY() then the value of column N is "...
Valid Information's user avatar
2 votes
1 answer
1k views

Keeping a cell formula set to the same cell even when a row is inserted

I have one sheet that needs to pick up singles sells for a lot of other sheets. On the other sheets I have to change the information each month and I work across the rows so I insert a row at the top ...
Annette's user avatar
  • 21
1 vote
0 answers
1k views

How to use relative file paths in Excel files hosted on OneDrive?

I created an Excel file that contains a column whose cells are links to HTML files in a subdirectory of the directory in which the Excel file resides. The links use a relative path structure, ie ...
joshuasundance's user avatar
1 vote
1 answer
91 views

Copying a cell and pasting in another app pastes the formula not the value

Excel-online is copying the cell formula, not the cell value to the computers clipboard, e.g. Given that I copy a cell showing a value in Excel online When I paste, the formula is pasted instead of ...
Andy Joiner's user avatar
1 vote
1 answer
131 views

Built-in functions in Excel Online are in a different language from the user interface

Previously I was using my Microsoft account in Turkish, but I set to English a few years ago. All applications were working as expected until I tried the built-in functions in Excel Online. For ...
user avatar
1 vote
0 answers
20 views

Finding source data behind errors in Excel 365 unpivot operation

I am working with Excel 365. My main worksheet has these fields: Ref-field1, ref-field2, ref-field3, ... ref-field30, value1, value2, value3 … value13, total Ref-field1 thru 30 ...
MaryC.fromNZ's user avatar
  • 7,320
0 votes
1 answer
2k views

Office 365 Excel set region

I have my laptop, running Windows 10, set to English United States region, my O365 site region is set to United States, all excel formatting is set to display dates in US format mm/dd/yyyy, however ...
Tim Wilkinson's user avatar
1 vote
1 answer
64 views

Format Google Analytics Date

I'm using the following formula to retrieve week day and day from a Google Analytics report in Google Spreadsheet: =CONCATENATE(CHOOSE(WEEKDAY('90diaspessoas'!A16),"Domingo","Segunda","Terça","Quarta"...
023023's user avatar
  • 123
1 vote
0 answers
35 views

Referring to another workbook in Excel Online

I'm trying to do a COUNTIF in Excel Online that counts the number of times a word appears in another workbook in Excel Online. Unfortunately, this doesn't seem to work the same way in Excel Online as ...
Michael's user avatar
  • 11
1 vote
0 answers
619 views

Strange language settings in Excel Online

I've a personal Office account, and using Excel Online I've realized that the language of OneDrive and Excel is English, and I see everything in English, except formulas. When I type formulas I get ...
Máté Juhász's user avatar
0 votes
1 answer
696 views

Hide the contents filled by each anonymous user on Excel Online

In order to fill a spreadsheet, I need ask to 50 people to fill it using Excel Online. Each person must fill a column in the spreadsheet. After that, when he quits the document, is there any ...
Guuk's user avatar
  • 117
2 votes
0 answers
685 views

How do I move a picture behind text in Excel header?

When you insert a header into Excel you get three bars to work with; left, middle and right. I wish to insert a banner picture into the middle bar and the text shown is: &[Picture] In the left ...
Daniel's user avatar
  • 225
6 votes
4 answers
31k views

Is it possible to set up conditional formats using Excel Online?

Is it possible to set up conditional formats using Excel Online? The cell's context menu doesn't have the option, and I can't find it in the ribbon either.
Matt's user avatar
  • 416
4 votes
1 answer
444 views

Using an Excel survey in Office 365 for business

A instructor in our community college is trying to create a survey using Office 365. The link https://support.office.com/en-us/article/Surveys-in-Excel-hosted-online-5fafd054-19f8-474c-97ec-...
user3063785's user avatar
1 vote
1 answer
1k views

Different permission for different user on Excel Online

I need to create Excel on-line workbook with different permissions sheets. more like some users can see some sheets while other can't edit, etc. can I achieve this?
iJay's user avatar
  • 133
1 vote
1 answer
7k views

Filtering doesn't work right in Excel online

The filter function in the Excel web app simply doesn't work. Here I'm choosing to show all statuses except Done, and it shows it anyway: There actually are some rows with a status of Done that are ...
Joshua Frank's user avatar
8 votes
8 answers
38k views

How to import a csv file into Excel on Microsoft Office Live

I'm working with Moodle to export a csv file. The file is encoded as UTF-8 but Excel doesn't recognise it and so displays odd characters. I've modified the code to insert a BOM as per https://...
Russell England's user avatar
6 votes
1 answer
13k views

Does Excel Online support filtering columns by value?

One of our customers shared to us an Excel Online document for exchanging notes and bug reports, the file is starting to grow quite a bit, and could benefit from filtering: one of the columns ...
Alex's user avatar
  • 161
-1 votes
1 answer
1k views

Embed Google / Microsoft Excel spreadsheet [closed]

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsoft Excel web app and Google spreadsheets, but none of them ...
Alecs's user avatar
  • 127