1 vote2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
I think you mean row height... Setting row heights can be done for a whole worksheet, but the row (of cells) will not 'know' you need to have the sheet adapt to show cells with adjusted row height until you set the auto adjustment option for row height for cells which contain something.
After entering the text and formatting cells to the row heights you want, try using Format, Auto-fit row height. Then you could copy/paste the 'template' rows you have created many times to get the desired line heights you want elsewhere, or in the rest of the table. I expect what you really want is a macro to adjust the whole sheet in advance before entering text, but cells architecture is not really designed this way and it just is not necessary. I think you might be fine, if following a standard procedure to set up a sheet after initial text entry and formatting is done.
You will need to be more specific. Text entered per cell is wrapped if required, and there is no way as far as we know of making a text style. Styles only apply to Cells. Is that your problem? The fact is you can't create "two lines of text" except by inserting a line feed with Alt+Enter. Not sure what it is you need.
8 votes2 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Why do some of the most useful features of the most basic operational use in Excel get pulled out, when it is clear that individual settings and tuning on a personal basis is what people want?
Agreed. I am using Office365 Pro version and the option is not there. It has been driving me crazy today since I need to scroll a Word doc rapidly, whilst reviewing/editing an Excel sheet. BUT previous versions I am sure have had it, and I have changed to scroll one line (necessary when cells are very large and occupy 1/2 the display each, whilst keeping my mouse default to 2 or 3 lines for use in scrolling in Word etc.
WHAT the heck happened to the settings in Excel options menu? PLEASE put this back in.
986 votes842 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!
838 votes155 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!
We need a Workbook-based undo buffer, as we have said, WITH the ability to purge the undo buffer manually, or on a manual save (just like the Accept All Changes and Stop Tracking removes all previous change memory items in Word).
Is there anything new about this issue which was first raised over 6 years ago on other threads? This is a HUGE productivity issue and MUST be prevented from any further drift NOW please. This is a QUALITY issue and relates directly to being able to track version control in Excel - enabling quality controls within a task or a design. We simply have to get it changed. Please. Please STOP adding minor usability innovations like auto-save and concentrate on what matters to power users who pay a lot of money monthly for upgrades that we have no control over. We need proper engineering to address this most fundamental issue. Not bells and whistles.
Most power-users work within multiple workbooks, just as they do with Word, or other apps. Why is Excel deficient: I shall tell you why: There is a lack of standardization and so lack of common architecture for Office applications and things have been allowed to drift at Microsoft. Get it sorted please.
Thanks a lot John and Team. Have a great Easter break. :)
Further to comments by Anon. on 26th March: Re. "Right click on the Excel Tab in Windows taskbar keeping the ALT key pressed" -This option is not available in Windows 10 with Excel 2016. However, the Excel /X option works and a second change-undo buffer is created in the new process. A good work-around. Suggest the Office Excel menu shortcuts put the /X option into the application shortcut set, and/or put a File | New Excel process option on the apps own menu. Transparency of options. But that does not take away from the need for a unique undo per document context.
For goodness sake stop this nonsense of collecting votes and fix this fault. This is an anomaly that NO OTHER Office application would tolerate. PLEASE.
Please note that merely saving the workbook using Excel 2016 / Office 365 ProPlus does not remove the change record buffer on save. Perhaps older versions removed changes?
But it still merges all changes to one change buffer across all workbooks open, which is the major flaw. Microsoft Word does not do this. Hoping for a correction to this soon. Split the buffer please to each workbook having its own.
This Undo issue is a bug and the height of lazy design. No two ways about it. It is one of the MOST inconvenient, non-standard, deviant and lazy things that Excel has just left in there, version after version, despite the fact that many users of so called Office Professional editions and above routinely use mutiple spread sheets and cannot seriously be expected to use an undo buffer that undos (to the user) randomly, across different workbooks!
Unless one in not changing more than one workbook, this is a useless function. The workbook one is correcting requires an undo every so often, not the one being referred to, where only zoom levels are being used. (And please please can we NOT store zoom levels as document changes to undo? This is just silly. Other competitor products have full separation and, by the way, so does Word.
PLEASE harmonize the technology better across Office applications: UNDO, SEARCH and allow colours to default to Window default settings when using Classic desktop scheme.
10 votes6 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
AGREED. There is no proper usability reason for removing the sheet highlight when the Excel application window instance is not in the foreground. Why is this the case? For example, I often require to look at a complex sheet when writing a Word report on the data, or compare sheets, and need to keep my sheet highlighted to see what I am checking whilst working on the other document. This now ubiquitous behaviour in Windows has no user-friendly reason and should be, MUST be removed for common sense. All experienced users, will I am sure agree. It is only beginners who lose the sense of what is actually in the foreground.
6 votes1 comment · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
12 votes2 comments · Excel for Windows (Desktop Application) » Graphics · Flag idea as inappropriate… · Admin →
7 votes4 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Cursor visibility is a serious and annoying problem that would be relatively easily corrected, and made user controllable. It has come up in many different posts. Agreed this is a problem.
1 vote1 comment · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →
There is something wrong with your set-up if you are working offline. Get it checked and consider machine local resources and scanning activity of anti-malware, and other Office processes also active including updates. However, if you are working online on a sharepoint (shared document) you may see some delays to animation (I have seen this in Word, but not Excel yet).
3 votes2 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
The problem is that the cursor has to start somewhere - the application cannot anticipate whether the user will change the 'Find what' or the 'Replace with' string.
Notice that after using find/replace, and then re-opening using Control+F (Find) this is the position of the cursor. The 'Replace with' string also remains until changed. So - if you know you need to search again for something else, just use Cntrl+F. Problem solved? Otherwise, learn to use the voice commands which are now very powerful.
11 votes6 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
I think this has come up on multiple issues/requests, one of which was posted by me relating to the fact that the cursor cannot be seen for several seconds in a large sheet against the background colour selected, or even when there is no background!
1. It is just NOT bold enough (and does not contrast automatically (should automatically contrast intelligently with the background, as used to be the case with Lotus 123).
2. A green cursor is a problem for colour blindness. Did Microsoft design team not think about that when dictating the banal, useless restrictions on colour scheme?
WE HAVE NEVER had a proper answer as to what on Earth they were doing when restricting the ability to use the Windows OS colours. (Lunacy and gross arrogance towards the user). I am slightly colour blind and often find myself unable to find cursor position. There is, as far as I know, no default way to control the cursor colour, and this should be available. GET IT RIGHT please? We are no all little green Martians!
6 votes0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
28 votes12 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →