Excel for Mac should have the new Stocks functionalty. In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.
These keyboard shortcuts help you work with formulas in Excel. Edit active cell shortcuts: “F2” and then “Esc” If you press “F2” on your keyboard you will find you have a shortcut to edit the formula in the active Excel cell. Pressing “Esc” on your keyboard will allow you to exit Excel formula editing. Absolute referencing keyboard shortcuts: “F4” Whilst editing a formula inside the active Excel cell, if you press “F4” on your keyboard, “$” signs will be added in front of the letter and also the row of the cell reference closest to your cursor, locking new formulas to that cell reference. Imagine you have a formula that makes use of a key model input at A1 of the Excel spreadsheet. If you press “F4” dollar signs will be added so that the cell reference appears as $A$1.
If you then fill the formula across, the new formulas will remain ‘locked’ to $A$1. As described above, if you press “F4” on your keyboard, $ signs will be added in front of the row and column of the cell reference (e.g. If you press “F4” a second time you will find you have a $ sign against the row number only (e.g. A$1), locking the row.
If you press “F4” a third time, you have the shortcut to lock the column (the $ sign will remain on the column only e.g. If you toggle with “F4” on your keyboard again, and press it repeatedly, you will notice you are cycling through all the different options ($ signs on both column and row, $ signs on row only, $ signs on column only, no $ signs). These keyboard shortcuts, which help you lock Excel formulas using $ dollar signs, are known as “absolute referencing”. Insert Excel function keyboard shortcuts: “Alt =” and “Shift F3” These keyboard shortcuts help you when you are inserting new Excel formulas. If you press “Alt” followed by “=” (at the same time) on your keyboard, you will find you have a shortcut which inserts Excel’s sum function. If you press “Shift” and “F3” you have a keyboard shortcut which brings up Excel’s insert function wizard (it’s the same as clicking on “fx” on your formula bar).
With Commander One you can compress (except for RAR compression), extract, open archive as a folder, or copy files from archive without even extracting. Commander One is a free dual pane file manager for Mac OS X working flawlessly with ZIP, RAR, 7Zip, TBZ, TGZ archives.
Force formula calculation: “F9” If you have set your Excel formulas to calculate manually, and want to ‘force’ your spreadsheet to calculate, the keyboard shortcut you need is “F9”. Many analysts working with large models routinely set Excel so that formulas don’t automatically recalculate every time a change is made in their spreadsheet.
In a large Excel model calculations can slow down. Repeatedly making changes in a model, and waiting each time for Excel formulas to recalculate, can become tiresome.
To stop formulas calculating automatically so that your work speeds up, in Excel you need to go to the file menu. Under “Options”, “Formulas”, “Calculation options” click on “Manual”. This will stop Excel formulas calculating automatically in a large spreadsheet, speeding up your work if you have a large model that has slowed down. The keyboard shortcut you then need when you want your Excel spreadsheet to recalculate its formulas is “F9”. This shortcut saves you the alternative of having to go back through Excel’s menu items to set formula calculation back to automatic. View formulas shortcut: “Ctrl ¬” If you want a shortcut to view all the formulas in your Excel spreadsheet, press “Ctrl” on your keyboard, followed by the “¬” button at the same time.
Check the top left hand side of your keyboard if you are not sure where to find the “¬” key. Press “Ctrl ¬” again and you will be viewing Excel normally again. Keyboard shortcuts for comments in Excel: “Shift F2” If you want a shortcut to insert a comment attached to an Excel formula, press “Shift” followed by “F2” at the same time. The same keyboard shortcut will allow you edit an existing Excel comment. If you want to delete a comment, right mouse click on the cell that contains the comment and select “Delete Comment” (“Shift F10” is the keyboard shortcut for accessing Excel’s right click menu).
Formula auditing Excel keyboard shortcuts: “Ctrl Alt ]” and “Ctrl Alt [“ Formula auditing can help you work out how formulas are linked within an Excel model. If you access formula auditing manually, and click on “Trace Dependents”, Excel will draw blue arrows from your current cell into all cells that make use of the current cell. “Trace Dependents” is normally accessed from Excel’s “Formulas” tab, under “Formula Auditing” “Trace Dependents”. You can shortcut that process by pressing “Ctrl Alt ]”. The formula auditing Excel keyboard shortcut for “Trace Precendents” is “Ctrl Alt” followed by the other square bracket “[“. Formula auditing shortcuts: “Ctrl ]” and “Ctrl [“ If you press “Ctrl” on your keyboard followed straight away by the right facing square bracket “]”, you will have discovered a tool that shortcuts part of Excel’s “Trace Dependents” function. Pressing “Ctrl ]” on your keyboard takes you directly forward to the first cell that the active cell points to.
- четверг 29 ноября