LEAVE THE FUCKING_NUMLOCK ON. FUCK_YOU_MICROSOFT.

A very much need function which should allow Excel users to convert number to word.

Example :
1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.

Note : the conversion should be based on regional setting and user should be able define the currency code.

=SpellNumber([cellReference],"CurrencyCode")

Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.

1)atan(x,y)=pi-pi/2*(1+sgn(x))*(1-sgn(y^2))-pi/4*(2+sgn(x))*sgn(y)

-sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

2)atan(E,N)=pi-pi/2*(1+sgn(N))*(1-sgn(E^2))-pi/4*(2+sgn(N))*sgn(E)

-sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1

3)atan2(x,y)=pi/2*(1-sgn(x))*(1-sgn(y^2))+pi/4*(2-sgn(x))*sgn(y)

-sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

For dx=dy=0 the result is indefinite .

Currently there is only a line around the row number or the cell.

E.g., you are on row 12 or on row 12, column L, the entire row or a cell will highlight in a pale color different than the worksheet. This would work well for those who have 10 or more columns going across. The end-user could choose a color and it could be a toggle for those who do not opt to have the row/cell highlighted.

When protecting sheets / worksheets with a password, there is no "eye" icon to display the password so you can verify that you've typed it in correctly. It would be great to have this function to help reduce errors and reduce the risk of locking yourself out of a file.

It will be good to have Freezing Option under Properties for Graphs, Shapes, Linked Pictures/Objects etc. where a user can have an option to lock the objects on screen... and the same should be appearing as constant even if the user scrolls to the left-right & up-down.

This will give End-user a dynamic webpage view/feel especially for huge excel dashboards with specific KPI - graphs and charts appearing on top or on either sides

Like: Don't Move or Size or Scroll with the Cells

Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

still have to hit escape to deselect copied items. FUCK_YOU_MICROSOFT.

Can you make it so that features are less useful and more difficult to access with future version of excel?

If my data has leading zeros, then I want leading zeros!.... How is that so hard to understand!?!... Make truncating leading zeros an optional setting, not the default.

I have a long list of formulas, and want to nest every formula within another if statement. Using find and replace to replace the beginning and end of every formula (the parts that don't differ between each one), this should be very easy. However, excel won't let me change a single one because, when I try to replace the text, "the formula is missing an opening or closing parenthesis."

I can appreciate having error checking for formulas, but there should be SOME way to either bypass this error checking or turn it off! This is frustrating me to no end.

Upon upgrading to Excel version l 365 16.0.11328, I lost the ability to anchor formula ranges with the period key instead of the colon. Prior to this version, hitting the period would insert a colon so that I could complete a cell range. Could this functionality be added back to the "Transition Navigation Keys" option?

Having started with Lotus 123 back in the 1980's, I still use "Transition Navigation Keys." Using the period during formula entry has become second nature and is embedded in my muscle memory. Please kindly consider this for your more "seasoned" Excel users.

STOP TURNING OFF THE ******* NUMLOCK. ******* YOU MICROSOFT.

Named conditional formatting rules - If you could name your rules they would be easier to identify. Also, it would be nice if you could right click a cell and have a choice to add it to a named conditional formatting rule. Excel would need to be intelligent enough to be able to add the cell or group of cells to the rule correctly.