Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

Ao copiar dados de uma coluna com vários dados repetidos.
Como temos a opção com o botão direito do mouse de Colar Especial > Valores, poderia ter uma opção de Colar Especial > Valores Únicos.

I've always wanted the option to copy multiple selections to the clipboard. When you paste, you'd be presented with the option of everything on your clipboard, to be able to pick which selection(s) you want to paste.

Please add double strikethrough to Excel. I've often wished that it was available in Excel as it is in Word. It seems if it's available in Word, it'd be easy enough to add it to Excel.

Please consider this addition.

Thanks!!!

In Excel, the only way to make your worksheets/reports that you build in Excel a dark theme, is to add a background image.
On the PowerPivot/Sharepoint server, background images are not supported.

It would be nice if you could save an Excel sheet with dark background color as a configurable default, so that you don't have to change cell backgrounds (which go away with PowerPivot refresh), and don't have to do a background image (which is incompatible with server refresh/presentation).

Even outside of server refresh, we find issues on file exchange too.

Couldn't find an area relevant to the answers.microsoft forums so I will try here.

If you paste a long Excel formula into the forums it truncates to ****
e.g =IF(OR(AY$2={"awt"****N3)))

A lot of the users are having to post images of the formula to combat this, and most experts know this is a problem, but for new users this may be difficult.

Data no longer stays on clipboard after pasting one time.

The STOCK data type gives inaccurate data for ETP/PRD and for EPD.
Also transposed SFIX and SCHW. See attached Workbook.

When we use Filter for updating data in excel, excel does not have a capability to remember my filter.
Example If I filter the column with Error, Then I update some row, but when i go to the filter, i do not see the keyword with which i filter

Is now February 2019 - Any chance that VBA Integration with the Undo Stack is on the roadmap or in Development? Workarounds are extremely lengthy (codewise) and complicated.

The "copy link to clipboard" button on the File|Info screen that allowed a user to copy a link (path + file) to the clipboard is missing. Whoever took this button please kindly return it. Thank you ever so much!

when you open a comment with many lines (high form) it is moved: it does not stay next to the cell.
Unable to return to the cell leaving the comment.
You must press ESC ESC Arrow LEFT ARROW Right

Why comment shape move and not stay near the cell ?

Thanks

We can hide several worksheets at once, but we can only show them individually.

Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.

I have an old sheet with book titles entered into the A column. I would like to be able to click on the title and know when I entered the book title so that I can know the date I finished the books.

In Power Query, you can convert a date in year, month, day, first day of the month, day of the week, .... You can also convert a date in month name or in day name.

But there is no option to convert a date with the short name (Jan, Feb, Mar, ...) and the same for the day (Mon, Tue, Wed, ...)

Is it possible to add these options on the ribbon?

https://support.office.com/en-us/article/ideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4?ui=en-US&rs=en-US&ad=US

Could someone let me know when "Ideas" will be available in Excel?

I am an Office Insider user an I currently use Version Build 11126.20002