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.

Ao clicar com o botão direito do mouse, podemos ter uma opção para mostrar o "histórico de edições", e com isso temos o(s) usuário(s) que fizeram a modificações e quais os dados que foram digitados.

Currently in Excel Online, when I format the colour of text in a single cell it changes the colour of all text in that cell. I would like the ability to change the colour of highlighted text only so I can have multiple colours of text in one cell.

After looking on multiple forums, I can see this has been an issue for many users for a number of years.

Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

Don't go destroying developer's programs, just add interoperability, functions, and facelift.

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

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.

Some mainstream Microsoft products already support side scrolling inputs from mouse inputs that are capable of doing so with a notable exception of Excel. Ironically, I feel Excel would benefited the most of this feature. I understand that a user can side scroll with the Scroll Lock enabled but if the user already has their hand on the mouse to scroll vertically then it would make sense to allow horizontal scrolling.

Again, this capability is natively there for may popular applications with the notable exception of Excel.

Thank you for your consideration.

Jon

Please update Excel so that it can open multiple workbooks in a single instance, like it used to. Having multiple instances open hinders my efficiency: I can't ctrl-Tab between workbooks and I can't Paste-Special from different Excel instances the same way I can within the same instance.

Thanks

In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.

As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”

A formula to convert text to a formula; which is essentially the exact opposite of the FORMULATEXT function, or in a way, what the INDIRECT function does with cell references but with formulas.

Allow conditional formatting to be applied so that cell widths and heights can be specified.

LEAVETHEFUCKINGNUMLOCKON. FUCKYOUMICROSOFT.

LEAVE THE FUCKINGNUMLOCK ON. FUCKYOU_MICROSOFT.

Proposal for a built-in function for: Count distinct/unique values in a range

There might be a dedicated function for counting distinct values in a specific range.
Currently the following function is a solution:
=SUMPRODUCT(1/COUNTIF([RANGE],[RANGE]))

However beginner-level users would like probably a predefined parametric function, sg like this:
=COUNT.DISTINCT([RANGE])

Thank you.

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.