F9 Evaluate Part Of Formula Excel For Mac

воскресенье 02 февраля22.08.2017admin

Select the cell with formula. Now click on the formula bar Just select the parts the formula and press F9 (for eg: the first average formula) This will evaluate only the selected part and replaces it with the result. Mar 06, 2012 Excel for Mac recalculate -key (= F9 -key in Excel for Window) I´d like to know Excel for Widows F9 -key (recalculate) procedure in Excel for Mac? I tried change Exposes & Spaces and cmd + = and cmd + 0, but Mac`s Excel didn´t recalculate.

Paint S is an easy-to-use drawing tool and image editor which can help you to draw pictures and edit your existing photos. With it you can sketch and crop, rotate, scale images very easily. At the same time, you can and text onto images as you want. The app also supports layers, so you can re-edit them freely. Trusted Windows (PC) download Paint XP 1.5. Virus-free and 100% clean download. Get Paint XP alternative downloads. Paint program for mac. Download Paint XP - Packed with the same useful tools and options this is the MS Paint application before Windows 7 introduced the ribbon to its interface.

Keyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboard layouts might not correspond to the keys on a U.S. keyboard. Keyboard shortcuts for laptop computers might also differ.

Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences. Under Hardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.

Custom Keyboard Shortcuts: In the Mac versions of Excel, you have to go to the Tools menu (it may be under File and then Options depending on the Excel version) and then select Customize Keyboard there to create these shortcuts. These shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently.

F9 Evaluate Part Of Formula Excel For Mac

Tip: To quickly find your search term on this page, press CtrlF or ⌘F (Mac) and use the find bar.

Action	Windows	Mac
General
Open help	`F1`	`⌘/`
Undo last action	`CtrlZ`	`⌘Z`
Redo last action	`CtrlY`	`⌘Y`
Copy selected cells	`CtrlC`	`⌘C`
Cut selected cells	`CtrlX`	`⌘X`
Paste content from clipboard	`CtrlV`	`⌘V`
Display the Paste Special dialog box	`CtrlAltV`	`Control⌘V`
Display find and replace	`CtrlF`	`⌘F`
Display find and replace, replace selected	`CtrlH`	`ControlH`
Find next match	`ShiftF4`	`⌘G`
Find previous match	`CtrlShiftF4`	`⌘ShiftG`
Create embedded chart	`AltF1`	`FnOptionF1`
Create chart in new worksheet	`F11`	`FnF11`
Toggle Autofilter	`CtrlShiftL`	`⌘ShiftF`
Activate filter	`Alt↓`	`Option↓`
Insert table	`CtrlT`	`ControlT`
Select table row	`ShiftSpace Bar`	`ShiftSpace Bar`
Select table column	`CtrlSpace Bar`	`ControlSpace Bar`
Select table	`CtrlA`	`⌘A`
File
Create new workbook	`CtrlN`	`⌘N`
Open workbook	`CtrlO`	`⌘O`
Save workbook	`CtrlS`	`⌘S`
Save as	`F12`	`⌘ShiftS`
Print file	`CtrlP`	`⌘P`
Open print preview window	`CtrlF2`
Close current workbook	`CtrlF4`	`⌘W`
Close Excel	`AltF4`	`⌘Q`
Ribbon
Expand or collapse ribbon	`CtrlF1`	`⌘OptionR`
Activate access keys	`Alt`
Move to next ribbon control	`Tab`	`Tab`
Activate or open selected control	`Space Bar`	`Space Bar`
Confirm control change	`Enter`	`Return`
Get help on selected control	`F1`
Drag and Drop
Drag and cut	`drag`	`drag`
Drag and copy	`Ctrldrag`	`Optiondrag`
Drag and insert	`Shiftdrag`	`Shiftdrag`
Drag and insert copy	`CtrlShiftdrag`	`OptionShiftdrag`
Drag to worksheet	`Altdrag`	`⌘drag`
Drag to duplicate worksheet	`Ctrldrag`	`Optiondrag`
Navigation
Move one cell right	`→`	`→`
Move one cell left	`←`	`←`
Move one cell up	`↑`	`↑`
Move one cell down	`↓`	`↓`
Move one screen right	`AltPgDn`	`FnOption↑`
Move one screen left	`AltPgUp`	`FnOption↓`
Move one screen up	`PgUp`	`Fn↑`
Move one screen down	`PgDn`	`Fn↓`
Move to right edge of data region	`Ctrl→`	`Control→`
Move to left edge of data region	`Ctrl←`	`Control←`
Move to top edge of data region	`Ctrl↑`	`Control↑`
Move to bottom edge of data region	`Ctrl↓`	`Control↓`
Move to beginning of row	`Home`	`Fn←`
Move to last cell in worksheet	`CtrlEnd`	`FnControl→`
Move to first cell in worksheet	`CtrlHome`	`FnControl←`
Turn End mode on	`End`	`Fn→`
Selection
Select entire row	`ShiftSpace Bar`	`ShiftSpace Bar`
Select entire column	`CtrlSpace Bar`	`ControlSpace Bar`
Select entire worksheet	`CtrlA`	`⌘A`
Add non-adjacent cells to selection	`CtrlClick`	`ControlClick`
Move right between non-adjacent selections	`CtrlAlt→`	`ControlOption→`
Move left between non-adjacent selections	`CtrlAlt←`	`ControlOption←`
Toggle add to selection mode	`ShiftF8`	`FnShiftF8`
Cancel selection	`Esc`	`Esc`
Extend Selection
Extend selection by one cell right	`Shift→`	`Shift→`
Extend selection by one cell left	`Shift←`	`Shift←`
Extend selection by one cell up	`Shift↑`	`Shift↑`
Extend selection by one cell down	`Shift↓`	`Shift↓`
Extend the selection to the last cell right	`CtrlShift→`	`ControlShift→`
Extend the selection to the last cell left	`CtrlShift←`	`ControlShift←`
Extend the selection to the last cell up	`CtrlShift↑`	`ControlShift↑`
Extend the selection to the last cell down	`CtrlShift↓`	`ControlShift↓`
Extend selection up one screen	`ShiftPgUp`	`FnShift↑`
Extend selection down one screen	`ShiftPgDn`	`FnShift↓`
Extend selection to start of row	`ShiftHome`	`FnShift←`
Extend selection to first cell in worksheet	`CtrlShiftHome`	`FnControlShift←`
Extend selection to last cell in worksheet	`CtrlShiftEnd`	`FnControlShift→`
Toggle extend selection mode	`F8`	`FnF8`
Active Cell
Select active cell only	`ShiftBackspace`	`ShiftDelete`
Show the active cell on worksheet	`CtrlBackspace`	`⌘Delete`
Move active cell clockwise in selection	`Ctrl.`	`Control.`
Move active cell down in selection	`Enter`	`Return`
Move active cell up in selection	`ShiftEnter`	`ShiftReturn`
Move active cell right in a selection	`Tab`	`Tab`
Move active cell left in a selection	`ShiftTab`	`ShiftTab`
Select Special
Display ‘Go To’ dialog box	`CtrlG`	`ControlG`
Select cells with comments	`CtrlShiftO`	`FnControlShiftO`
Select current region around active cell	`CtrlShift*`	`ControlShiftSpace Bar`
Select current region	`CtrlA`	`⌘A`
Select current array	`Ctrl/`	`Control/`
Select row differences	`Ctrl`	`Control`
Select column differences	`CtrlShift`	`ControlShift`
Select direct precedents	`Ctrl[`	`Control[`
Select all precedents	`CtrlShift{`	`ControlShift{`
Select direct dependents	`Ctrl]`	`Control]`
Select all dependents	`CtrlShift}`	`ControlShift}`
Select visible cells only	`Alt;`	`⌘ShiftZ`
Cell Edit Mode
Edit the active cell	`F2`	`ControlU`
Insert or edit comment	`ShiftF2`	`ShiftF2`
Cancel entry	`Esc`	`Esc`
Select one character right	`Shift→`	`Shift→`
Select one character left	`Shift←`	`Shift←`
Move one word right	`Ctrl→`	`Control→`
Move one word left	`Ctrl←`	`Control←`
Select one word right	`CtrlShift→`	`ControlShift→`
Select one word left	`CtrlShift←`	`ControlShift←`
Select to beginning of cell	`ShiftHome`	`FnShift←`
Select to end of cell	`ShiftEnd`	`FnShift→`
Delete to end of line	`CtrlDelete`	`ControlDelete`
Delete character to the left of cursor	`Backspace`	`Delete`
Delete character to the right of cursor	`Delete`	`FnDelete`
Start a new line in the same cell	`AltEnter`	`ControlOptionReturn`
Entering Data
Enter and move down	`Enter`	`Return`
Enter and move up	`ShiftEnter`	`ShiftReturn`
Enter and move right	`Tab`	`Tab`
Enter and move left	`ShiftTab`	`ShiftTab`
Complete entry and stay in same cell	`CtrlEnter`	`ControlReturn`
Enter same data in multiple cells	`CtrlEnter`	`ControlReturn`
Insert current date	`Ctrl;`	`Control;`
Insert current time	`CtrlShift:`	`ControlShift:`
Fill down from cell above	`CtrlD`	`ControlD`
Fill right from cell left	`CtrlR`	`ControlR`
Copy formula from cell above	`Ctrl``	`Control``
Copy value from cell above	`CtrlShift'`	`ControlShift'`
Add hyperlink	`CtrlK`	`⌘K`
Display AutoComplete list	`Alt↓`	`Option↓`
Formatting
Format (almost) anything	`Ctrl1`	`⌘1`
Display Format Cells with Font tab selected	`CtrlShiftF`
Apply format again	`F4`	`ControlY`
Apply or remove bold formatting	`CtrlB`	`⌘B`
Apply or remove italic formatting	`CtrlI`	`⌘I`
Apply or remove underscoring	`CtrlU`	`⌘U`
Apply or remove strikethrough formatting	`Ctrl5`	`⌘ShiftX`
Add or remove the shadow font style	`⌘ShiftW`
Add or remove the outline font style	`⌘ShiftD`
Align center	`AltHAC`	`⌘E`
Align left	`AltHAL`	`⌘L`
Align right	`AltHAR`	`⌘R`
Indent	`⌘M`
Remove indent	`⌘ShiftM`
Increase font size one step	`⌘Shift>`
Decrease font size one step	`⌘Shift<`
Number Formatting
Apply general format	`CtrlShift~`	`ControlShift~`
Apply currency format	`CtrlShift$`	`ControlShift$`
Apply percentage format	`CtrlShift%`	`ControlShift%`
Apply scientific format	`CtrlShift^`	`ControlShift^`
Apply date format	`CtrlShift#`	`ControlShift#`
Apply time format	`CtrlShift@`	`ControlShift@`
Apply number format	`CtrlShift!`	`ControlShift!`
Borders
Add border outline	`CtrlShift&`	`⌘Option0`
Add or remove border right	`AltR`	`⌘Option→`
Add or remove border left	`AltL`	`⌘Option←`
Add or remove border top	`AltT`	`⌘Option↑`
Add or remove border bottom	`AltB`	`⌘Option↓`
Add or remove border upward diagonal	`AltD`
Add or remove border horizontal interior	`AltH`
Add or remove border vertical interior	`AltV`
Remove borders	`CtrlShift_`	`⌘Option_`
Formulas
Toggle absolute and relative references	`F4`	`⌘T`
Open the Insert Function Dialog Box	`ShiftF3`	`FnShiftF3`
Autosum selected cells	`Alt=`	`⌘ShiftT`
Toggle formulas on and off	`Ctrl``	`Control``
Insert function arguments	`CtrlShiftA`	`ControlShiftA`
Enter array formula	`CtrlShiftEnter`	`ControlShiftReturn`
Calculate worksheets	`F9`	`F9`
Calculate active worksheet	`ShiftF9`	`FnShiftF9`
Force calculate all worksheets	`CtrlAltF9`
Evaluate part of a formula	`F9`	`FnF9`
Expand or collapse the formula bar	`CtrlShiftU`	`ControlShiftU`
Display function arguments dialog box	`CtrlA`	`ControlA`
Name Manager	`CtrlF3`	`ControlL`
Define name using row and column labels	`CtrlShiftF3`	`ControlShiftF3`
Paste name into formula	`F3`
Accept function with autocomplete	`Tab`	`↓Tab`
Pivot Tables
Select entire pivot table	`CtrlA`	`⌘A`
Toggle pivot table field checkbox	`Space Bar`	`Space Bar`
Group pivot table items	`AltShift→`	`⌘ShiftK`
Ungroup pivot table items	`AltShift←`	`⌘ShiftJ`
Hide pivot table item	`Ctrl-`	`Ctrl-`
Create pivot chart on same worksheet	`AltF1`
Create pivot chart on new worksheet	`F11`	`FnF11`
Workbook
Insert new worksheet	`ShiftF11`	`ShiftF11`
Go to next worksheet	`CtrlPgDn`	`FnControl↓`
Go to previous worksheet	`CtrlPgUp`	`FnControl↑`
Move to next pane	`F6`	`F6`
Move to previous pane	`ShiftF6`	`ShiftF6`
Go to next workbook	`CtrlTab`	`ControlTab`
Go to previous workbook	`CtrlShiftTab`	`ControlShiftTab`
Display control menu	`AltSpace Bar`
Minimize current workbook window	`CtrlF9`	`⌘M`
Maximize current workbook window	`CtrlF10`
Dialog Boxes
Move to next control	`Tab`	`Tab`
Move to previous control	`ShiftTab`	`ShiftTab`
Move to next tab	`CtrlTab`	`ControlTab`
Move to previous tab	`CtrlShiftTab`	`ControlShiftTab`
Accept and apply	`Enter`	`Return`
Check and uncheck box	`Space Bar`	`Space Bar`
Cancel and close the dialog box	`Esc`	`Esc`
Grid Operations
Display Insert Dialog box	`CtrlShift+`	`ControlI`
Insert rows	`CtrlShift+`	`ControlI`
Insert columns	`CtrlShift+`	`ControlI`
Display Delete dialog box	`Ctrl-`	`Control-`
Delete rows	`Ctrl-`	`Control-`
Delete columns	`Ctrl-`	`Control-`
Delete cells	`Ctrl-`	`Control-`
Delete contents of selected cells	`Delete`	`FnDelete`
Hide columns	`Ctrl0`	`Control0`
Hide rows	`Ctrl9`	`Control9`
Unhide rows	`CtrlShift9`	`ControlShift9`
Unhide columns	`CtrlShift0`	`ControlShift0`
Group rows or columns	`AltShift→`	`⌘ShiftK`
Ungroup rows or columns	`AltShift←`	`⌘ShiftJ`
Open Group Dialog Box	`AltShift→`	`⌘ShiftK`
Open Ungroup Dialog Box	`AltShift←`	`⌘ShiftJ`
Hide or show outline symbols	`Ctrl8`	`Control8`
VBA Editor
Help	`F1`
Object Browser	`F2`
Find	`F3`
Properies Window	`F4`
Run	`F5`
Switch Split Windows	`F6`
Goto Window Of Object	`F7`
Step	`F8`
Breakpoint	`F9`
Activate Menu Bar	`F10`
Toggle Insert Mode	`Insert`
Delete	`Delete`
Beginning Of Line	`Home`
End Of Line	`End`
Page Up	`PgUp`
Page Down	`PgDn`
Left	`←`
Right	`→`
Up	`↑`
Down	`↓`
Indent	`Tab`
New Line	`Enter`
Delete Prev Char	`BackSpace`
Procedure Definition	`ShiftF2`
Find Prev	`ShiftF3`
Find Next	`ShiftF4`
Procedure Step	`ShiftF8`
Quick Watch	`ShiftF9`
Show Right Click Menu	`ShiftF10`
Paste	`ShiftInsert`
Select To Start Of Line	`ShiftHome`
Select To End Of Line	`ShiftEnd`
Select To Top Of Module	`ShiftPgUp`
Select To End Of Module	`ShiftPgDn`
Extend Selection Left 1 Char	`Shift←`
Extend Selection Right 1 Char	`Shift→`
Extend Selection Up	`Shift↑`
Extend Selection Down	`Shift↓`
Un-indent	`ShiftTab`
Focus To Object Box	`CtrlF2`
Close Window	`CtrlF4`
Run To Cursor	`CtrlF8`
Activate Menu Bar	`CtrlF10`
Select All Text	`CtrlB`
Copy	`CtrlC`
Export Module	`CtrlE`
Find	`CtrlF`
Immediate Window	`CtrlG`
Replace	`CtrlH`
Turn On Quick Info	`CtrlI`
List Members	`CtrlJ`
Show Call Stack	`CtrlL`
Import File	`CtrlM`
New Line	`CtrlN`
Print	`CtrlP`
Project Window	`CtrlR`
Save	`CtrlS`
Show Available Components	`CtrlT`
Paste	`CtrlV`
Cut	`CtrlX`
Cut Entire Line	`CtrlY`
Undo	`CtrlZ`
Copy	`CtrlInsert`
Delete To End Of Word	`CtrlDelete`
Top Of Module	`CtrlHome`
End Of Module	`CtrlEnd`
Top Of Current Procedure	`CtrlPage Up`
End Of Current Procedure	`CtrlPage Down`
Left Word	`CtrlLeft Arrow`
Right Word	`CtrlRight Arrow`
Previous Procedure	`CtrlUp Arrow`
Next Procedure	`CtrlDown Arrow`
Turn On Complete Word	`CtrlSpace Bar`
Cycle Windows	`CtrlTab`
Delete To Start Of Word	`CtrlBackSpace`
Close VBE	`AltF4`
Run Error Handler	`AltF5`
Switch Between Last 2 Windows	`AltF6`
Step Error Handler	`AltF7`
Return To Application	`AltF11`
Add-Ins Menu	`AltA`
Debug Menu	`AltD`
Edit Menu	`AltE`
File Menu	`AltF`
Help Menu	`AltH`
Insert Menu	`AltJ`
Format Menu	`AltO`
Close & Return	`AltQ`
Run Menu	`AltR`
Tools Menu	`AltT`
View Menu	`AltV`
Window Menu	`AltW`
System Menu	`AltSpace Bar`
Cycle Applications	`AltTab`
Undo	`AltBackSpace`
Previous Position	`CtrlShiftF2`
Clear All Breakpoints	`CtrlShiftF9`
Turn On Param Info	`CtrlShiftI`
Turn On List Properties	`CtrlShiftJ`
Other
Open Spelling dialog box	`F7`	`F7`
Open Thesaurus dialog box	`ShiftF7`	`ShiftF7`
Open Macro dialog box	`AltF8`	`FnOptionF8`
Open VBA Editor	`AltF11`	`FnOptionF11`
Duplicate object	`CtrlD`	`⌘D`
Snap to grid	`Alt`	`⌘`
Hide or show objects	`Ctrl6`	`Control6`
Display Modify Cell Style dialog box	`Alt'`	`⌘ShiftL`