for the issues the ribbon afforded us an opportunity to perform was to make current Excel functionality (that means functionality currently on hand in existing variations of Excel) more convenient to search out and quicker to implement. Today I thought I would walk through a few (but in no way exhaustive) examples. can be more than just find
Most users are likely familiar with Edit|Come across, which allows users to look for text in their Excel document. Not as many are familiar with the fact that you can acquire all cells that have conditional formatting applied, all cells that contain formulas, or all cells that contain comments,
win 7 home basic license, primarily because there is a separate UI path to get at these capabilities (Edit|Go To … and then the “Special” button). In Excel 2007, we have merged “Find”, “Go To Special”,
office Home And Student 2010 x64, and a few other capabilities in one control in the Ribbon, which our research shows helps users discover and take advantage of functionality they did not previously know existed. to enlarge) can be Special too
In a similar vein, we have taken the most heavily used Paste Special commands and merged them into the Paste control in the Excel 2007 Ribbon. Again, we believe that this will serve two purposes – advertising capabilities like “Transpose” to users that may not have otherwise discovered the feature,
win 7 starter key, and putting commonly used Paste Special commands fewer clicks away. to enlarge) text to the forefront
Our research shows that “Wrap Text” is a very heavily used command in Excel, yet in recent variations of Excel, it is only available as a checkbox on one with the tabs in the Format Cells dialog. In Excel 2007, we have added a button on the first Excel tab that allows users to toggle “Wrap Text” on and off. simply need to jab the button or use a keyboard shortcut to toggle “Wrap Text”. Again, the benefits are feature visibility and efficiency. orientation too
Another example of a commonly used feature that is only accessible on the Format Cells dialog is text orientation. We have added a drop-down to the first Excel tab that allows users to orient text with one or two clicks. that these features are still obtainable on the Format Cells dialog; we have simply made them on the market front and centre on the Ribbon. format
The final example from the front tab for the Excel Ribbon is setting number formats. Excel 2007 has a control that allows uses to set the most common number formats without needing to launch the Format Cells dialog. to enlarge) Names Renamed … A "Formula" tab example
Folks that use names frequently may be familiar with Excel’s Insert|Name|Paste feature. In its present-day incarnation,
office Professional keygen, the feature brings up a dialog listing names accessible in a workbook which users can then insert into formulas they are building. In Excel 2007,
microsoft office 2007 Pro keygen, we have shifted the UI to the ribbon, again making the feature (hopefully) more discoverable and more efficient to make use of. To build a formula using names is as simple as clicking the drop-down control in the ribbon and picking the names that you want to use. Here are a few screenshots that should give you an idea of how this works ... in this case, I am building a formula that subtracts “Cost” from “Sales” by simply picking those two names from the “Use In Formula” drop down in the “Named Cells” chunk. to enlarge) to enlarge) to enlarge) it for today. Next week, I will start a series of posts on work we have done to create producing professional-quality documents simple and fast.