Excel Shortcut For Copyright Symbol

The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feature. Typing (c), (tm), or (r) will accomplish this. The other way to enter special symbols in Excel is by going to

  1. Excel Shortcut For Copyright Symbol
  2. Excel Shortcut For Copyright Symbol Mac
  3. Excel Shortcut For Copyright Symbol Without

Excel shortcut keys. Excel shortcut keys can greatly improve your speed when conducting analysis. 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. To Type Copyright Symbol in Excel. ALT Codes for Symbols and Characters. On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the ALT key and then using the numeric keypad to type the ASCII or Unicode code for that character. For example, holding down ALT and then typing 184 on the numeric keypad, prints ©, the copyright symbol. Euro Symbol in Excel. In MS Excel, there are various ways to enter the ‘EURO’ symbol and the usage of the symbol. Here we discuss top 5 methods to type Euro Symbol along with examples #1 – Using Shortcut Key. We can use a shortcut key to insert the ‘EURO’ symbol in the cell of MS Excel. The shortcut key is ‘Alt+0128’.

Insert > Symbol.
You can actually create your own keyboard shortcuts for inserting other special symbols in Excel such as the micro symbol (µ), delta symbol (∆), degree sign (°), plus-minus sign (±), common superscripts such as ² or ³, common fractions such as ¼, ½, ¾, dot sign (·), partial differential (∂), infinity (∞), etc.
To do this in Excel, go to Tools > Options > Spelling tab > Autocorrect Options button > Autocorrect tab. Add the entries in the table listed below. Because the Autocorrect options apply to the other Office applications, you'll find that after you add these using Excel, you can use the same shortcuts in Word, PowerPoint, Outlook, etc.
Note that not all of the unicode characters will be displayed correctly on other computers.
By the way! If you ever want to undo when Autocorrect makes an unwanted change, such as when you really want to use (c) for the copyright symbol and not ©, right after Autocorrect changes the text, press Ctrl+z to undo and go on typing.

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. 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
FunctionWindowsMac
New fileCtrl + N + N
OpenCtrl + O + O
SaveCtrl + S + S
Save asCtrl + Shift + S + Shift + S
PrintCtrl + P + P
Print previewCtrl + F2
Close workbookCtrl + W + W
Close ExcelCtrl + Q + Q
Excel shortcut for copyright symbol
Working with data
FunctionWindowsMac
CopyCtrl + C + C
CutCtrl + X + X
PasteCtrl + V + V
Paste specialCtrl + Alt + VControl + + V
UndoCtrl + Z + Z
RedoCtrl + Y + Y
FindCtrl + F + F
Find previousCtrl + Shift + F4 + Shift + G
Find nextShift + F4 + G
Find and replaceCtrl + HControl + H
Moving within a workbook
FunctionWindowsMac
Move right
Move left
Move up
Move down
Move right to next full cellCtrl + Control +
Move left to next full cellCtrl + Control +
Move up to next full cellCtrl + Control +
Move down to next full cellCtrl + Control +
Move to beginning of rowHomeFn +
Move to last cellCtrl + EndFn + Control +
Move to first cellCtrl + HomeFn + Control +
Scroll right one screenAlt + PgDnFn + Option +
Scroll left one screenAlt + PgUpFn + Option +
Scroll up one screenPgUpFn +
Scroll down one screenPgDnFn +
End modeEndFn +
Selecting cells
FunctionWindowsMac
Go to cellCtrl + GControl + G
Select allCtrl + A + A
Select rowShift + SpaceShift + Space
Select columnCtrl + SpaceControl + Space
Select current regionCtrl + Shift + *Shift + Control + Space
Select current arrayCtrl + /Control + /
Select all precedentsCtrl + Shift + {Control + Shift + {
Select direct dependentsCtrl + ]Control + ]
Select all dependentsCtrl + Shift + }Control + Shift + }
Select only visible cellsAlt + ; + Shift + Z
Add cell range to selectionShift + ClickShift + Click
Add one-off cells to selectionCtrl + Click + Click
Move active cell right to non-adjacent selectionCtrl + Alt + Control + Option +
Move active cell left to non-adjacent selectionCtrl + Alt + Control + Option +
Move selection one column leftOption + Tab
Move selection one column rightOption + Shift + Tab
Toggle selection add modeShift + F8Fn + Shift + F8
Clear selectionEscEsc
Expand selection to the rightShift + Shift +
Expand selection to the leftShift + Shift +
Expand selection upShift + Shift +
Expand selection downShift + Shift +
Expand selection to last full cell to the rightCtrl + Shift + + Shift +
Expand selection to last full cell to the leftCtrl + Shift + + Shift +
Expand selection to last full cell upCtrl + Shift + + Shift +
Expand selection to last full cell downCtrl + Shift + + Shift +
Expand selection up full screenShift + PgUpFn + Shift +
Expand selection down full screenShift + PgDnFn + Shift +
Expand selection to beginning of rowShift + HomeFn + Shift +
Expand selection to first worksheet cellCtrl + Shift + HomeFn + Control + Shift +
Expand selection to last worksheet cellCtrl + Shift + EndFn + Control + Shift +
Toggle extend selection modeF8Fn + F8
Select only cells with commentsCtrl + Shift + OFn + Control + Shift + O
Select row differencesCtrl + Control +
Select column differencesCtrl + Shift + |Control + Shift + |
Select direct precedentsCtrl + [Control + [
Working with active cells
FunctionWindowsMac
Only select active cellShift + BackspaceShift + Delete
Show active cellCtrl + Backspace + Delete
Move active cell clockwiseCtrl + .Control + .
Move active cell downEnterReturn
Move active cell upShift + EnterShift + Return
Move active cell rightTabTab
Move active cell leftShift + TabShift + Tab
Editing formulas
FunctionWindowsMac
Edit active cellF2Control + U
Cancel entryEscEsc
Delete to end of lineCtrl + DeleteControl + Delete
Delete character in back of cursorBackspaceBackspace
Delete character in front of cursorDeleteFn + Delete
New line within cellAlt + EnterControl + Option + Return
Add character to the right to selectionShift + Shift +
Add character to the left to selectionShift + Shift +
Move one word rightCtrl + Control +
Move one word leftCtrl + Control +
Add word to right to selectionCtrl + Shift + Control + Shift +
Add word to left to selectionCtrl + Shift + Control + Shift +
Select from beginning of cell to current positionShift + HomeFn + Shift +
Select from current position to end of cellShift + EndFn + Shift +
Insert commentShift + F2Fn + Shift + F2
Entering data
FunctionWindowsMac
Commit and move downEnterReturn
Commit and move upShift + EnterShift + Return
Commit and move rightTabTab
Commit and move leftShift + TabShift + Tab
Commit and stay in same cellCtrl + EnterControl + Return
Enter data in multiple cellsCtrl + EnterControl + Return
Insert current dateCtrl + ;Control + ;
Insert current timeCtrl + Shift + :Control + Shift + :
Fill from cell aboveCtrl + DControl + D
Fill from cell to leftCtrl + RControl + R
Fill formula from cell aboveCtrl + 'Control + '
HyperlinkCtrl + K + K
Display AutocompleteAlt + Option +
Using the Ribbon
FunctionWindowsMac
Show / hide RibbonCtrl + F1 + Option + R
Enter Windows hotkey combinationAlt
HelpF1
Formatting cells
FunctionWindowsMac
Open format dialogueCtrl + 1 + 1
Re-apply formatF4Control + Y
Align centerAlt + H + A + C + E
Align leftAlt + H + A + L + L
Align rightAlt + H + A + R + R
IndentAlt + H + 6Control + Option + Tab
Un-indentAlt + H + 5Control + Option + Shift + Tab
Increase font sizeAlt + H + FG + Shift + >
Decrease font sizeAlt + H + FK + Shift + <
Format as generalCtrl + Shift + ~Control + Shift + ~
Format as currencyCtrl + Shift + $Control + Shift + $
Format as percentageCtrl + Shift + %Control + Shift + %
Format as scientificCtrl + Shift + ^Control + Shift + ^
Format as dateCtrl + Shift + #Control + Shift + #
Format as timeCtrl + Shift + @Control + Shift + @
Format as numberCtrl + Shift + !Control + Shift + !
BoldCtrl + B + B
ItalicCtrl + I + I
UnderlineCtrl + U + U
StrikethroughCtrl + 5 + Shift + X
Add shadow + Shift + W
Add outline + Shift + D
Border allCtrl + Shift + & + Option +
Border rightAlt + R + Option +
Border leftAlt + L + Option +
Border topAlt + T + Option +
Border bottomAlt + B + Option +
Border interior horizontalAlt + H
Border interior verticalAlt + V
Remove bordersCtrl + Shift + _ + Option + _
Calculations
FunctionWindowsMac
Toggle reference (relative vs. absolute)F4 + T
Calculate all sheetsF9Fn + F9
Calculate only active sheetShift + F9Fn + Shift + F9
AutosumAlt + = + Shift + T
Insert functionShift + F3Fn + Shift + F3
Show function argumentsCtrl + Shift + AControl + Shift + A
Commit array formulaCtrl + Shift + EnterControl + Shift + Return
Evaluate part of formulaF9Fn + F9
Toggle formula barCtrl + Shift + UControl + Shift + U
Show formula builderCtrl + AControl + A
Define nameCtrl + F3Control + L
Create nameCtrl + Shift + F3Control + Shift + F3
Paste name into formulaF3
Worksheets and workbooks
FunctionWindowsMac
New worksheetShift + F11Shift + F11
Next worksheetCtrl + PgDnFn + Control +
Previous worksheetCtrl + PgUpFn + Control +
Next workbookCtrl + TabControl + Tab
Previous workbookCtrl + Shift + TabControl + Shift + Tab
Next paneF6F6
Previous paneShift + F6Shift + F6
Minimize windowCtrl + F9 + M
Maximize windowCtrl + F1
Select multiple worksheetsShift + ClickShift + Click
Select one-off single worksheetsCtrl + Click + Click
Rows and columns
FunctionWindowsMac
Insert rows / columns dialogueCtrl + Shift + + Control + I
Insert rowsCtrl + Shift + + Control + I
Insert columnsCtrl + Shift + + Control + I
Delete dialogCtrl + -Control + -
Delete rowsCtrl + -Control + -
Delete columnsCtrl + -Control + -
Delete cellsCtrl + -Control + -
Clear cellsDeleteFn + Delete
GroupAlt + Shift + + Shift + K
UngroupAlt + Shift + + Shift + J
Group dialogAlt + Shift + + Shift + K
Ungroup dialogAlt + Shift + + Shift + J
Hide columnsCtrl + Control +
Hide rowsCtrl + 9Control + 9
Unhide rowsCtrl + Shift + 9Control + Shift + 9
Unhide columnsCtrl + Shift + Control + Shift +
Toggle outline symbolsCtrl + 8Control + 8
Charts, filters, and pivots
FunctionWindowsMac
Create chartAlt + F1Fn + Option + F1
Create chart (new sheet)F11Fn + F11
AutofilterCtrl + Shift + L + Shift + F
Open filtersAlt + Option +
Insert tableCtrl + TControl + T
Group pivot table itemsAlt + Shift + + Shift + K
Ungroup pivot table itemsAlt + Shift + + Shift + J
Hide pivot table itemCtrl + -Ctrl + -
Create pivot chartAlt + F1
Create pivot chart on new sheetF11Fn + F11
Pivot table wizardAlt + D + P + Option + P
Helper modules
FunctionWindowsMac
Spell checkF7F7
ThesaurusShift + F7Shift + F7
VBA editorAlt + F11Fn + Option + F11
MacrosAlt + F8Fn + Option + F8
Hide or showCtrl + 6Control + 6
DuplicateCtrl + D + D
Modify cell styleAlt + ' + Shift + L
Control menuAlt + Space?
Shortcut menuShift + F1Fn + 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. Toontown rewritten important tips.

  • 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.