Excel For Mac Technical Symbol

Excel For Mac Technical Symbol 8,5/10 1074 votes

Thankfully, typing a degree symbol on your Mac in macOS is just as easy as on your phone using iOS, letting you appropriately express both mathematics and the increasingly erratic weather. There are two ways to type a degree symbol in macOS, and they’re both system-level functions. Free youtube to mp3 converter program for mac download. The sigma summation symbol is known by most as a mathematical symbol that indicades the sum. Sigma Σ is one of the most popular mathematic signs which means a summation of something. Click on a Sigma symbol below to copy it out to clipboard automatically. Or look below to find out how to type sum symbol with keyboard using different techniques depending on your system.

Save an hour of work a day with these 5 advanced Excel tricks

Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.

How to create beautiful table formatting instantly..
Why to rethink the way you do VLOOKUPs..
Plus, we'll reveal why you shouldn't use PivotTables and what to use instead..

Excel shortcut keys can greatly improve your speed when conducting analysis. Voicemod for mac. But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel.

To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. No platform confusion, no unintelligible symbols — just a clear list of shortcuts to make you faster. Happy Exceling!

Working with files
Function	Windows	Mac
New file	`Ctrl` + `N`	`⌘` + `N`
Open	`Ctrl` + `O`	`⌘` + `O`
Save	`Ctrl` + `S`	`⌘` + `S`
Save as	`Ctrl` + `Shift` + `S`	`⌘` + `Shift` + `S`
Print	`Ctrl` + `P`	`⌘` + `P`
Print preview	`Ctrl` + `F2`
Close workbook	`Ctrl` + `W`	`⌘` + `W`
Close Excel	`Ctrl` + `Q`	`⌘` + `Q`

Working with data
Function	Windows	Mac
Copy	`Ctrl` + `C`	`⌘` + `C`
Cut	`Ctrl` + `X`	`⌘` + `X`
Paste	`Ctrl` + `V`	`⌘` + `V`
Paste special	`Ctrl` + `Alt` + `V`	`Control` + `⌘` + `V`
Undo	`Ctrl` + `Z`	`⌘` + `Z`
Redo	`Ctrl` + `Y`	`⌘` + `Y`
Find	`Ctrl` + `F`	`⌘` + `F`
Find previous	`Ctrl` + `Shift` + `F4`	`⌘` + `Shift` + `G`
Find next	`Shift` + `F4`	`⌘` + `G`
Find and replace	`Ctrl` + `H`	`Control` + `H`

Moving within a workbook
Function	Windows	Mac
Move right
Move left
Move up
Move down
Move right to next full cell	`Ctrl` +	`Control` +
Move left to next full cell	`Ctrl` +	`Control` +
Move up to next full cell	`Ctrl` +	`Control` +
Move down to next full cell	`Ctrl` +	`Control` +
Move to beginning of row	`Home`	`Fn` +
Move to last cell	`Ctrl` + `End`	`Fn` + `Control` +
Move to first cell	`Ctrl` + `Home`	`Fn` + `Control` +
Scroll right one screen	`Alt` + `PgDn`	`Fn` + `Option` +
Scroll left one screen	`Alt` + `PgUp`	`Fn` + `Option` +
Scroll up one screen	`PgUp`	`Fn` +
Scroll down one screen	`PgDn`	`Fn` +
End mode	`End`	`Fn` +

Selecting cells
Function	Windows	Mac
Go to cell	`Ctrl` + `G`	`Control` + `G`
Select all	`Ctrl` + `A`	`⌘` + `A`
Select row	`Shift` + `Space`	`Shift` + `Space`
Select column	`Ctrl` + `Space`	`Control` + `Space`
Select current region	`Ctrl` + `Shift` + `*`	`Shift` + `Control` + `Space`
Select current array	`Ctrl` + `/`	`Control` + `/`
Select all precedents	`Ctrl` + `Shift` + `{`	`Control` + `Shift` + `{`
Select direct dependents	`Ctrl` + `]`	`Control` + `]`
Select all dependents	`Ctrl` + `Shift` + `}`	`Control` + `Shift` + `}`
Select only visible cells	`Alt` + `;`	`⌘` + `Shift` + `Z`
Add cell range to selection	`Shift` + `Click`	`Shift` + `Click`
Add one-off cells to selection	`Ctrl` + `Click`	`⌘` + `Click`
Move active cell right to non-adjacent selection	`Ctrl` + `Alt` +	`Control` + `Option` +
Move active cell left to non-adjacent selection	`Ctrl` + `Alt` +	`Control` + `Option` +
Move selection one column left	`Option` + `Tab`
Move selection one column right	`Option` + `Shift` + `Tab`
Toggle selection add mode	`Shift` + `F8`	`Fn` + `Shift` + `F8`
Clear selection	`Esc`	`Esc`
Expand selection to the right	`Shift` +	`Shift` +
Expand selection to the left	`Shift` +	`Shift` +
Expand selection up	`Shift` +	`Shift` +
Expand selection down	`Shift` +	`Shift` +
Expand selection to last full cell to the right	`Ctrl` + `Shift` +	`⌘` + `Shift` +
Expand selection to last full cell to the left	`Ctrl` + `Shift` +	`⌘` + `Shift` +
Expand selection to last full cell up	`Ctrl` + `Shift` +	`⌘` + `Shift` +
Expand selection to last full cell down	`Ctrl` + `Shift` +	`⌘` + `Shift` +
Expand selection up full screen	`Shift` + `PgUp`	`Fn` + `Shift` +
Expand selection down full screen	`Shift` + `PgDn`	`Fn` + `Shift` +
Expand selection to beginning of row	`Shift` + `Home`	`Fn` + `Shift` +
Expand selection to first worksheet cell	`Ctrl` + `Shift` + `Home`	`Fn` + `Control` + `Shift` +
Expand selection to last worksheet cell	`Ctrl` + `Shift` + `End`	`Fn` + `Control` + `Shift` +
Toggle extend selection mode	`F8`	`Fn` + `F8`
Select only cells with comments	`Ctrl` + `Shift` + `O`	`Fn` + `Control` + `Shift` + `O`
Select row differences	`Ctrl` +	`Control` +
Select column differences	`Ctrl` + `Shift` +	`Control` + `Shift` +
Select direct precedents	`Ctrl` + `[`	`Control` + `[`

Working with active cells
Function	Windows	Mac
Only select active cell	`Shift` + `Backspace`	`Shift` + `Delete`
Show active cell	`Ctrl` + `Backspace`	`⌘` + `Delete`
Move active cell clockwise	`Ctrl` + `.`	`Control` + `.`
Move active cell down	`Enter`	`Return`
Move active cell up	`Shift` + `Enter`	`Shift` + `Return`
Move active cell right	`Tab`	`Tab`
Move active cell left	`Shift` + `Tab`	`Shift` + `Tab`

Editing formulas
Function	Windows	Mac
Edit active cell	`F2`	`Control` + `U`
Cancel entry	`Esc`	`Esc`
Delete to end of line	`Ctrl` + `Delete`	`Control` + `Delete`
Delete character in back of cursor	`Backspace`	`Backspace`
Delete character in front of cursor	`Delete`	`Fn` + `Delete`
New line within cell	`Alt` + `Enter`	`Control` + `Option` + `Return`
Add character to the right to selection	`Shift` +	`Shift` +
Add character to the left to selection	`Shift` +	`Shift` +
Move one word right	`Ctrl` +	`Control` +
Move one word left	`Ctrl` +	`Control` +
Add word to right to selection	`Ctrl` + `Shift` +	`Control` + `Shift` +
Add word to left to selection	`Ctrl` + `Shift` +	`Control` + `Shift` +
Select from beginning of cell to current position	`Shift` + `Home`	`Fn` + `Shift` +
Select from current position to end of cell	`Shift` + `End`	`Fn` + `Shift` +
Insert comment	`Shift` + `F2`	`Fn` + `Shift` + `F2`

Entering data
Function	Windows	Mac
Commit and move down	`Enter`	`Return`
Commit and move up	`Shift` + `Enter`	`Shift` + `Return`
Commit and move right	`Tab`	`Tab`
Commit and move left	`Shift` + `Tab`	`Shift` + `Tab`
Commit and stay in same cell	`Ctrl` + `Enter`	`Control` + `Return`
Enter data in multiple cells	`Ctrl` + `Enter`	`Control` + `Return`
Insert current date	`Ctrl` + `;`	`Control` + `;`
Insert current time	`Ctrl` + `Shift` + `:`	`Control` + `Shift` + `:`
Fill from cell above	`Ctrl` + `D`	`Control` + `D`
Fill from cell to left	`Ctrl` + `R`	`Control` + `R`
Fill formula from cell above	`Ctrl` + `'`	`Control` + `'`
Hyperlink	`Ctrl` + `K`	`⌘` + `K`
Display Autocomplete	`Alt` +	`Option` +

Using the Ribbon
Function	Windows	Mac
Show / hide Ribbon	`Ctrl` + `F1`	`⌘` + `Option` + `R`
Enter Windows hotkey combination	`Alt`
Help	`F1`

Formatting cells
Function	Windows	Mac
Open format dialogue	`Ctrl` + `1`	`⌘` + `1`
Re-apply format	`F4`	`Control` + `Y`
Align center	`Alt` + `H` + `A` + `C`	`⌘` + `E`
Align left	`Alt` + `H` + `A` + `L`	`⌘` + `L`
Align right	`Alt` + `H` + `A` + `R`	`⌘` + `R`
Indent	`Alt` + `H` + `6`	`Control` + `Option` + `Tab`
Un-indent	`Alt` + `H` + `5`	`Control` + `Option` + `Shift` + `Tab`
Increase font size	`Alt` + `H` + `FG`	`⌘` + `Shift` + `>`
Decrease font size	`Alt` + `H` + `FK`	`⌘` + `Shift` + `<`
Format as general	`Ctrl` + `Shift` + `~`	`Control` + `Shift` + `~`
Format as currency	`Ctrl` + `Shift` + `$`	`Control` + `Shift` + `$`
Format as percentage	`Ctrl` + `Shift` + `%`	`Control` + `Shift` + `%`
Format as scientific	`Ctrl` + `Shift` + `^`	`Control` + `Shift` + `^`
Format as date	`Ctrl` + `Shift` + `#`	`Control` + `Shift` + `#`
Format as time	`Ctrl` + `Shift` + `@`	`Control` + `Shift` + `@`
Format as number	`Ctrl` + `Shift` + `!`	`Control` + `Shift` + `!`
Bold	`Ctrl` + `B`	`⌘` + `B`
Italic	`Ctrl` + `I`	`⌘` + `I`
Underline	`Ctrl` + `U`	`⌘` + `U`
Strikethrough	`Ctrl` + `5`	`⌘` + `Shift` + `X`
Add shadow	`⌘` + `Shift` + `W`
Add outline	`⌘` + `Shift` + `D`
Border all	`Ctrl` + `Shift` + `&`	`⌘` + `Option` +
Border right	`Alt` + `R`	`⌘` + `Option` +
Border left	`Alt` + `L`	`⌘` + `Option` +
Border top	`Alt` + `T`	`⌘` + `Option` +
Border bottom	`Alt` + `B`	`⌘` + `Option` +
Border interior horizontal	`Alt` + `H`
Border interior vertical	`Alt` + `V`
Remove borders	`Ctrl` + `Shift` + `_`	`⌘` + `Option` + `_`

Calculations
Function	Windows	Mac
Toggle reference (relative vs. absolute)	`F4`	`⌘` + `T`
Calculate all sheets	`F9`	`Fn` + `F9`
Calculate only active sheet	`Shift` + `F9`	`Fn` + `Shift` + `F9`
Autosum	`Alt` + `=`	`⌘` + `Shift` + `T`
Insert function	`Shift` + `F3`	`Fn` + `Shift` + `F3`
Show function arguments	`Ctrl` + `Shift` + `A`	`Control` + `Shift` + `A`
Commit array formula	`Ctrl` + `Shift` + `Enter`	`Control` + `Shift` + `Return`
Evaluate part of formula	`F9`	`Fn` + `F9`
Toggle formula bar	`Ctrl` + `Shift` + `U`	`Control` + `Shift` + `U`
Show formula builder	`Ctrl` + `A`	`Control` + `A`
Define name	`Ctrl` + `F3`	`Control` + `L`
Create name	`Ctrl` + `Shift` + `F3`	`Control` + `Shift` + `F3`
Paste name into formula	`F3`

Worksheets and workbooks
Function	Windows	Mac
New worksheet	`Shift` + `F11`	`Shift` + `F11`
Next worksheet	`Ctrl` + `PgDn`	`Fn` + `Control` +
Previous worksheet	`Ctrl` + `PgUp`	`Fn` + `Control` +
Next workbook	`Ctrl` + `Tab`	`Control` + `Tab`
Previous workbook	`Ctrl` + `Shift` + `Tab`	`Control` + `Shift` + `Tab`
Next pane	`F6`	`F6`
Previous pane	`Shift` + `F6`	`Shift` + `F6`
Minimize window	`Ctrl` + `F9`	`⌘` + `M`
Maximize window	`Ctrl` + `F1`
Select multiple worksheets	`Shift` + `Click`	`Shift` + `Click`
Select one-off single worksheets	`Ctrl` + `Click`	`⌘` + `Click`

Rows and columns
Function	Windows	Mac
Insert rows / columns dialogue	`Ctrl` + `Shift` + `+`	`Control` + `I`
Insert rows	`Ctrl` + `Shift` + `+`	`Control` + `I`
Insert columns	`Ctrl` + `Shift` + `+`	`Control` + `I`
Delete dialog	`Ctrl` + `-`	`Control` + `-`
Delete rows	`Ctrl` + `-`	`Control` + `-`
Delete columns	`Ctrl` + `-`	`Control` + `-`
Delete cells	`Ctrl` + `-`	`Control` + `-`
Clear cells	`Delete`	`Fn` + `Delete`
Group	`Alt` + `Shift` +	`⌘` + `Shift` + `K`
Ungroup	`Alt` + `Shift` +	`⌘` + `Shift` + `J`
Group dialog	`Alt` + `Shift` +	`⌘` + `Shift` + `K`
Ungroup dialog	`Alt` + `Shift` +	`⌘` + `Shift` + `J`
Hide columns	`Ctrl` +	`Control` +
Hide rows	`Ctrl` + `9`	`Control` + `9`
Unhide rows	`Ctrl` + `Shift` + `9`	`Control` + `Shift` + `9`
Unhide columns	`Ctrl` + `Shift` +	`Control` + `Shift` +
Toggle outline symbols	`Ctrl` + `8`	`Control` + `8`

Charts, filters, and pivots
Function	Windows	Mac
Create chart	`Alt` + `F1`	`Fn` + `Option` + `F1`
Create chart (new sheet)	`F11`	`Fn` + `F11`
Autofilter	`Ctrl` + `Shift` + `L`	`⌘` + `Shift` + `F`
Open filters	`Alt` +	`Option` +
Insert table	`Ctrl` + `T`	`Control` + `T`
Group pivot table items	`Alt` + `Shift` +	`⌘` + `Shift` + `K`
Ungroup pivot table items	`Alt` + `Shift` +	`⌘` + `Shift` + `J`
Hide pivot table item	`Ctrl` + `-`	`Ctrl` + `-`
Create pivot chart	`Alt` + `F1`
Create pivot chart on new sheet	`F11`	`Fn` + `F11`
Pivot table wizard	`Alt` + `D` + `P`	`⌘` + `Option` + `P`

Helper modules
Function	Windows	Mac
Spell check	`F7`	`F7`
Thesaurus	`Shift` + `F7`	`Shift` + `F7`
VBA editor	`Alt` + `F11`	`Fn` + `Option` + `F11`
Macros	`Alt` + `F8`	`Fn` + `Option` + `F8`
Hide or show	`Ctrl` + `6`	`Control` + `6`
Duplicate	`Ctrl` + `D`	`⌘` + `D`
Modify cell style	`Alt` + `'`	`⌘` + `Shift` + `L`
Control menu	`Alt` + `Space`	`?`
Shortcut menu	`Shift` + `F1`	`Fn` + `Shift` + `F1`

Save an hour of work a day with these 5 advanced Excel tricks

Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.

How to create beautiful table formatting instantly..
Why to rethink the way you do VLOOKUPs..
Plus, we'll reveal why you shouldn't use PivotTables and what to use instead..

Comments

Please enable JavaScript to view comments.