F2 in excel is not working
Hi guys, In the past, I could use the F2 key to set the cursor in one cell and to edit its content. Unfortunately, this shortcut is not working anymore. If I push it, the speaker volume is lowered - this is actually the function of this key, but in excel, it worked for the shortcut to directly edit a cell without having to doubleclick on it. I would be pleased to get your help. Thanks, Tobi
"Use in formula" tab missing in my Excel formula ribbon (HELP)
I have the Office professional Plus 2019. In my Excel, if you open the formula ribbon, normally I believe there should be a section where there is (from top to bottom) "Define Name", "Use in Formula", and then "Create from Selection". However, as shown in the picture, my "Use if Formula" is missing. Does anyone else have this problem with the Office professional Plus 2019 Excel version? I'd love to know what's wrong. Thank you!
Conditional Formatting duplicating rules
When trying to use conditional formatting rules to highlight duplicate values it always highlights these same numbers which aren't duplicates. I've formatted the cells every way to prevent this but no fix yet. Shorter numbers work just fine. Attached below..PLease help
data tables & index/match function
As of yesterday, when I create a data table within a Excel 365 file & use that table within an index/match function, when I hit enter, the formula is looking for an external source & never had to do that before. when I ignore, I then get a NA or a #spill! error. Then when I save the file & reopen it, it is trying to update an external link yet there are none anywhere in that file except for the newly created data table. If someone would be able to get me out of this nightmare, it would be greatly appreciated. I have attached a fileMultiple Values for Single Parameter in Power Query
Hello, I have run into an issue in Microsoft Power Query. I have a particular parameter that we use to pull in data for our table, based off of a certain code (i.e, 10, 13, 17) and would like to know if there's a way to see multiple values at once (i.e, 10 and 17, excluding 13). NOTE: This is not filtering a table, but instead a parameter for the query.
