5
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 many online file converter services.
4
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 rows, and the filtering only works on those rows. I had to reformat ALL of my data as a table, and now it works. This is really non-obvious.
3
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 for complete feature list.
2
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 excel file online
copy contents of the clipboard.
Excel should properly separate the tabs into separate cells
2
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 a wizard asking you to create questions.
If you want to make people answer all of them then mark each question as Required.
Add as many questions necessary
...
2
I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.
2
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 sheet "Main". "Working" has a new row inserted every month; "Main" must maintain a link to "Working" Cell E13 despite the ...
1
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 row 1 in each sheet contains headers.
Enter this formula in Sheet1, Cell B2:
=arrayformula(iferror(match(A2:A,Sheet2!$A$2:$A,0),""))
This tests for a ...
1
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, then Site Settings > Regional settings.
Confirm that both the Time Zone AND the Region Locale are set to US time zone and English (United States) respectively....
1
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 correctly to DD-MM-YYYY. Then, TO_TEXT will work.
FINAL CONCATENATED FORMULA:
=TEXT('90diaspessoas'!A16,"dddd dd-mm-yyyy")
1
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 > Pick your style. If you need to clear an existing format you can choose the Clear Rules option.
If you want to apply other Conditional Formatting options, and ...
1
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 links: in our Tenant, and turned it off for all site collections except the one we will use only for Excel Surveys.
Only top voted, non community-wiki answers of a minimum length are eligible