what if we can add a choice for users to transfer sheets from bottom to left side instead of column A?
as excel user, I start using first sheet, then second one then third one then I find myself using high NO of sheets which makes finding specific sheet boring and frustrating. and if we have high NO of sheets, it will be harder even if I name the sheets

but what if we had the ability to transfer all sheets from bottom to left side from top as they fill all column A and column A starts the next column? it will be far easier and very helpful, and interesting to use for every one.

In the recent update to excel 2019, the feature to format cells using find and replace has been removed. Please bring this function back!!! If you have a list of thousands of numbers and you need to search out a specific number then you could replace the cell format with a background color to highlight the cell. Basically you could highlight all cells that contained the number you were "finding." Now this isn't possible and I have to sort throug thousands of numbers using the find next and getting out of the function, then highlighting, then moving on to the next one......instead of doing it in one simple action! Please add this back pronto!

When I change existing border settings in cells, rows, or columns the new setting is ignored, and instead, the previous settings are even removed.
I am using Office 2019.
Before when I made changes to border setting, for example replacing a thinner with a thicker line, I just had to select the new line style, click the border I wanted to change and the new line style was set.
Now, when I do the same, the new line style is displayed right after clicking the border I want to change, but when ok'ing back to the form, the border line is entirely gone. No previous and no new border line any longer.
I have to go back and reset the new line style, ok back to see the new setting.

In a previous version of Excel, I could paste a selection of data cells into an image previously pasted on a spreadsheet page. This was usually a column of text used to label electrophoresis bands arranged horizontally on the image. In the previous version, the text would paste independent of the cell background and outline box. This is what I want. I could make the list horizontal by rotating it, and sizing it to fit the columnar data in the image. The text labeled the columns perfectly and clearly. Now that the software has been updated, when I past the column of data from the spreadsheet into the image, it is accompanied by the cell outline and background, which obscures the image behind it, a very unacceptable thing. How can I get the new excel version to behave as the old version did?

How it used to work well:

How it is unacceptable with new version of Excel...:

When I click on "Format Cells..." I get the standard list of various formats. There should be a separate "Duration" format in this list, to handle time duration, AS DISTINCT FROM time-of-day. This is needed when entering time durations, for example, the timings for a piece of music or of a film. Also, this Duration format should include the option of entering MINUTES:SECONDS without hours.

I have tried to find a way to work around the lack of this basic simple format, visiting numerous tech sites and support sites, and I was shocked to discover that there is no way to do it! All existing time formats are linked to a time of day, even if not displayed as such. This is baffling to me. Google Sheets has this format. Apple Numbers has this format. PLEASE add this format option to Excel. I'm sure I am not the first person to ask for this. Thank you.

I work in an international environment and I got the following issue concerning date formatting:

1. CODE SET FOR DATE FORMATTING:
On MacOS, the code set used for number/date... formatting (and also for separators in formulas and default delimiters when opening CSV files) is based on the "region" parameter set up in the region & language preferences of MacOS.
In my case, I often share Excel files with people whose preference are set to "France" or "United Kingdom" or "USA" according to the person.

In English environment, code for "year" is yy or yyyy. But in French environment, it becomes aa or aaaa. Same for the code for "day" (dd/ddd/dddd in non French environment; jj/jjj/jjjj in French environment).
When used in the cell formatting window, there is no problem because Excel will adapt automatically according to the language/region environment.
But when used in the TEXT() function, format codes will not adapt automatically to the environment.
So, for instance a cell with the following formula:
formula:=TEXT(43333,"mm/dd/yyyy") => result: 08/21/2018 in English environment, but:
formula:=TEXT(43333;"mm/dd/yyyy") => result: 08/dd/yyyy in French environment, and vice versa:
formula:=TEXT(43333;"mm/jj/aaaa") => result: 08/21/2018 in French environment, but:
formula:=TEXT(43333,"mm/jj/aaaa") => result:08/jj/aaaa in English environment.
And of course, this stands for all other language-dependent codes

=> Excel should either:
- language independent codes that can be used in all environments;
- make it possible to use either code sets in all environments.

please check the attached file (from download.microsoft.com) in various environments and you will see the problem.
I didn't check for the Windows version, but the problem should be the same (as for mobile versions)

2. MORE GENERALLY SPEAKING:
By the way, there SHOULD BE AN OPTION in the EXCEL PREFERENCES to bypass the OS preferences for all what concerns language (formatting code set, CSV file default delimiters and character set, UI language...) in order to BYPASS THE OS PREFERENCES. (NOT ONLY MacOS, BUT ALL OSs!)