Excel training for almost 20 years, but we pretty good ideas to find what people and easy to use is difficult. From this, here are some suggestions of new features Excel 2020 (or due to the next version of when). Small, big range!
Removes the named range.
Here is how to remove the Excel range names you can.
Click the name box drop-down. Right click on the name you want to delete. Select the delete!
We... keep looking for this feature to all new versions of Excel
Autotyping range names, or functions
You can highlight the option when entering formulas in the range name or function, and then enter to continue. For example, type.
Then, + < c 5 = TotalR
Fill automatically TotalRevenue scope name for you to press TAB key or enter this completely. OK, so we are annoying, but do this in Microsoft Visual Studio and the VBA to managed.
Click the print tab of the Ribbon to the
Why not? Bring all that to one print under the roof of one tab will mean a lot.
Conditional formatting to properly integrate.
First conditional formatting since introduction (is in Excel 97, quite remember this, I think) stood apart from the other formatting features. See the style we would like to.
Numeric format alignment font border background protection; and conditional formatting
You must allow to apply a style to cell can affect all available formats.
Bar side indicating the worksheet and workbook
Blue Sky ideas that this: why all worksheets in the workbook in the current image of the sheet of display all open workbooks, or task pane. Click to go to just click the worksheet can. Just a thought.
Used to move the version of Excel 2003, and press ALT + apostrophe in the style box. Much can also change the style of the current existing cell formatting easily. All new theme very cute, but we sure can have these features back?
At the end (this post is a little if you whingy), we can close the new features are a few good Excel. Ribbon (you are familiar with it and is) a great idea, look and feel better we even Sparklines is like that. Microsoft keep up good work!
Andy Brown is a developer of Excel traner and Wise Owl (http://www.wiseowl.co.uk). You can find details of the differences between the various versions of Excel Http://www.wiseowl.co.uk/versions/excel/index.htm.