6 votes

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

Is this possible? Nope. The Excel Online App currently does not support importing/opening CSV files. You'll have to convert it to XLSX first, which you could do using Libre/OpenOffice, or one of ...
user avatar
  • 252
4 votes
Accepted

Filtering doesn't work right in Excel online

I figured it out, almost by accident. You see how in the original screenshot, the row colors alternate but then stop at row 23. That's because the "table" part of the worksheet only included the top ...
user avatar
3 votes

Does Excel Online support filtering columns by value?

I'm late in the party but not empty handed. Yes, Excel online does support filtering. Just format your column as table and then select the kind of filter you want to apply. Refer to this technet ...
user avatar
  • 151
2 votes

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

The following steps worked for me: open csv file in notepad++ replace all commas with tabs (you may have to enable search mode extended with \t) Select all and copy to the clipboard. open a blank ...
user avatar
2 votes

Hide the contents filled by each anonymous user on Excel Online

You should create an Excel survey so that nobody knows who else is filling out the form and they can't edit anyone else's responses. Go to OneDrive Select New > Excel survey You will then go through ...
user avatar
2 votes

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

I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.
user avatar
  • 121
2 votes

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

Use INDIRECT to reference a specific cell. You can write the sheet/cell references longhand in the formula, or build it using variables. Let's say that you have a sheet "Working", and a ...
user avatar
  • 4,623
1 vote
Accepted

Bulk Search Or Find a bunch of values at once

You want a fast, effienct way to find matches between two sets of order numbers. Let's assume that one set of order numbers are in Sheet1 and this sheet is to be compared to those on Sheet2, and that ...
user avatar
  • 4,623
1 vote

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

A day later and my excel-online spreadsheets are pasting as expected. Feels like A/B test.
user avatar
1 vote

Office 365 Excel set region

The regional settings for Excel online will be determined by the online host, i.e. OneDrive for Business or SharePoint, not by Excel. In OneDrive for Business, click the cog wheel at the top right, ...
user avatar
  • 251
1 vote

Format Google Analytics Date

You need to use TEXT, instead of TO_TEXT: =TEXT('90diaspessoas'!A16,"dd-mm-yyyy" ) As long as underlying date number is correct, This will work. OR Set formatting in '90diaspessoas'!A16 ...
user avatar
  • 3,048
1 vote

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

Support: YES Set up: NO Edit: NO Excel Online supports Conditional Formatting with Data Bars, Color Scales and Icon Sets. Select a range to be formatted, and go to Home > Conditional Formatting > ...
user avatar
  • 24.5k
1 vote
Accepted

Using an Excel survey in Office 365 for business

We had the same concern. So we created a new site collection specifically for surveys. Then we turned on the setting "Allow both external users who accept sharing invitations and anonymous guest ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible