Web Applications Stack Exchange
Web Applications Stack Exchange

Questions tagged [excel-online]

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

Excel Online is a lightweight, web-based version of Microsoft Excel, available as part of the Office Online suite of products.

See also:

For questions about regular Microsoft Excel, please visit Super User.

For questions about the Android or iPhone/iPad versions of Microsoft Excel, please visit Android Enthusiasts and Ask Different respectively.

35 questions
9
votes
8 answers

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://stackoverflow.com/a/16231345/1603711 But I am unable to…
Russell England
  • 291
  • 1
  • 4
  • 8
6
votes
4 answers

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
  • 416
  • 2
  • 4
  • 15
6
votes
1 answer

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 represents a "status" (To do, In progress, Done, Won't…
Alex
  • 161
  • 1
  • 1
  • 4
4
votes
1 answer

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-b606fcda0ff9 explains the steps. When the instructor tried…
user3063785
  • 43
  • 2
4
votes
1 answer

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 online, the "Create new cell style" option doesn't seem to…
Franck Dernoncourt
  • 19,429
  • 42
  • 122
  • 201
3
votes
1 answer

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)) function transposed down the C column. The top-left of the…
Brooke
  • 143
  • 5
3
votes
2 answers

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/Mac/Web, so FILTERXML or VBA won't work. In…
jpfieber
  • 35
  • 1
  • 6
2
votes
0 answers

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 bar I wish to have the actual header being My Excel…
Daniel
  • 235
  • 1
  • 2
  • 9
2
votes
1 answer

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 of the information each month. e.g on the sheet I…
Annette
  • 21
  • 2
1
vote
1 answer

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
  • 133
  • 6
1
vote
1 answer

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 hidden, but I can't see any pattern to it. There's…
Joshua Frank
  • 329
  • 6
  • 16
1
vote
1 answer

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 after clicking in my PivotTable:
Franck Dernoncourt
  • 19,429
  • 42
  • 122
  • 201
1
vote
0 answers

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 need a sheet where i put a search query…
user2593287
  • 11
  • 1
1
vote
2 answers

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 type 24200 on C1, it calculates all the other…
Victor Santos
  • 563
  • 2
  • 5
  • 6
1
vote
0 answers

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 "Not Started" otherwise the value will automatically…
Valid Information
  • 11
  • 1
1
2 3