Is there a keyboard shortcut shortcut to paste and match destination formatting in Excel for Mac 2016? If there isn't, can I create one?
Active27 days ago
lucianoluciano
Shift-Command-Down Arrow or Shift-End Select multiple words or blocks of text that aren't next to each other Select the first text you want and select additional text while holding down the Command key. Your original question suggested that you were interested not only in knowing the keyboard shortcuts in Word 2011 for moving text up and down but also in being able to change them (for example, so you could use Option+Shift+Up Arrow to move the text up and Option+Shift+Down Arrow to move the text down). Click Shortcuts. To navigate only to text boxes and lists on the screen, select 'Text boxes and lists only.' Down Arrow to decrease values). Mac accessibility. This article is a cheatsheet of the keyboard shortcuts in Mac OS X. Mac OS X Keyboard Shortcut CheatSheet + Download. By Charnita Fance – Posted on Apr 17, 2013 Apr 17. What is default text editor for bash in mac terminal. Shift-Option-Down Arrow: Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.
1 Answer
There isn't any direct shortcut for what you are asking. However, you could try one of the following methods.
To use this Office keyboard shortcut, you must first turn off the Mac OS X keyboard shortcut for this key. On the Apple menu, click System Preferences. Under Hardware, click Keyboard.
1. Use Paste Special dialog
When pasting text from some other application, open Paste Special dialog with ctrl+⌘ cmd+v, choose 'Unicode text' with ↓ down arrow (if not already selected) and then hit ↩︎ return. (If you have set Full Keyboard Access in System Preferences on, you have to hit ⇥ tab first in Paste Special dialog.)
When pasting formulas or values inside Excel, open Paste Special with the same shortcut ctrl+⌘ cmd+v and then hit either f to select Formulas or v to select Values depending on what you want to paste. Then hit ↩︎ return.
2. Create a macro
Record a macro in Excel with commands explained above. You can assign a custom shortcut for your macro and save it to your Personal Macro Workbook so that it's available whenever you use Excel. This is probably the easiest method.
Another possibility is to write a Visual Basic script.
3. Edit cell and paste
Start editing the cell with F2 (or fn+F2 if you haven't changed the behavior of the function keys) and then paste normally with ⌘ cmd+v.
Note that when pasting a formula, only the value will be pasted.
Also note that if there's line breaks in the pasted text, all the lines will be pasted into the same cell instead of pasting them to different rows.
In addition, this method doesn't replace the existing cell value. After hitting F2, the cursor will be placed after the existing content.
4. Create an Automator service
Create a service with Automator that receives no input in Excel and has one Run AppleScript action with the following code:
Note that this only works when pasting text from some other application. It doesn't work with Excel formulas.
Also note that if the language of your user interface is not English, you have to replace 'Unicode text' with what is displayed in Paste Special dialog.
If you want to paste formulas inside Excel with a script, instead of
paste special.. line above, use:
And the values of formulas inside Excel can be pasted with the following code:
Of course, you can create a new workflow for each of the three cases.
After creating the service, you can assign a shortcut for the service in System Preferences. https://pentree278.weebly.com/blog/convert-pdf-to-text-for-mac.
You should be able to check the contents of the clipboard in code and then decide which command to run, but I couldn't get the
get clipboard formats command of Excel to work as expected so I'm not sure how to implement that.
olalahtiolalahti
Not the answer you're looking for? Browse other questions tagged macosmicrosoft-excelmacmicrosoft-officecopy-paste or ask your own question.
Active5 months ago
You often see people using
-> as an arrow, but I hate how it looks. I always use the → symbol. However, I always have to insert < symbol to use this, which is annoying.
Is there anyway (shortcut) to insert this symbol in Word (2013)?
phuclv
12.2k77 gold badges5050 silver badges105105 bronze badges
Bram VanroyBram Vanroy
64499 gold badges2323 silver badges4949 bronze badges
6 Answers
You need to use the Numpad (the other numbers won't work!).
Community♦
Matt SmithMatt Smith
People who type
-> probably don't know that if you type --> you get the default arrow in Word.
If you actually want TerryTerry
--> to be shown in Word, you can type --> and press backspace, which will undo the automatical conversion to the arrow image.
1,23422 gold badges1414 silver badges2121 bronze badges
You could try just using alt codes of these characters:
12.2k77 gold badges5050 silver badges105105 bronze badges
FenixpFenixp
This is probably only relevant in a few cases, but I'll still write it. It did help me. It's a three-step method that can be performed without leaving the keyboard.
12.2k77 gold badges5050 silver badges105105 bronze badges
Marcus BlankMarcus Blank
There are various ways to do that
By default
--> will be changed to a light right-pointed arrow. Similarly > will be a heavy right-pointed arrow. There are also other types of arrows and you can also insert your own ones so you don't need any shortcuts
Of course this needs AutoCorrect to be turned on. If it was turned off, you need to turn it on again by selecting File > Word Options > Proofing > AutoCorrect Options.. > Replace text as you type
A downside of this is that many of the arrows are from the private use area like U+F0E0 U+F0E8, therefore you can't copy them around to other applications easily, but of course if you only use them in Word then it'll be fine
With this feature
-> will be converted into → by default without doubling the hyphen.
There are even more types of arrows, including curved ones and diagonal ones like
asmash hsmash hsphantom mapsto lrhar searrow swarrow .. Can you download art text 2 for mac.
This needs Use Math AutoCorrect rules outside of math regions to be turned on beside the normal AutoCorrect.
Just type the codepoint in hex (with or without
U+ ) and then press Alt+X, Word will do the conversion for you. This works for any Unicode characters
Down Arrow Icon On Keyboard
For example
↗ is U+2197 so just type 2197 then Alt+XHowever sometimes you need to type 2 followed by U+0197 (i.e. 2Ɨ) then you must type 2U+197 or 2U+0197 then Alt+X
You can find the codepoints for most arrows in the below wikipedia article (or just copy them directly)
By default it'll only work for codepoints smaller than 256, hence you can just type a few arrows like Matt Smith's answer above.
To type codepoints above 255 you need to use hex numpad by setting
EnableHexNumpad to 1 in HKEY_CURRENT_USERControl PanelInput Method . After that to type ↗ like above you can press Alt++2197
Again you can find hundreds of arrows in my linked Wikipedia articles above
phuclv
12.2k77 gold badges5050 silver badges105105 bronze badges
You can also go Insert > Symbol > More Symbols > Font = Times new Roman > Subset = Arrows
lazycoderlazycoder
protected by Community♦Nov 30 '18 at 16:17Arrow In Word Shortcut
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead? Keyboard Shortcut For Text Down Arrow MachiningNot the answer you're looking for? Browse other questions tagged microsoft-wordkeyboard-shortcutscharacterstypingsymbols or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |