flowteam.blogg.se

1. #USE PASTE SPECIAL IN EXCEL FOR MAC HOW TO#
2. #USE PASTE SPECIAL IN EXCEL FOR MAC FULL#
3. #USE PASTE SPECIAL IN EXCEL FOR MAC MAC#
4. #USE PASTE SPECIAL IN EXCEL FOR MAC WINDOWS#

#USE PASTE SPECIAL IN EXCEL FOR MAC WINDOWS#

With Windows Alt key navigation, you can navigate by touch typing even if you're using an infrequently used menu combination by holding down the Alt key and reading the menu, seeing the shortcut (underlined letter), typing it, and moving on to the next submenu (or the next work task). In addition to just being faster, this approach is faster if you get "mouse fatigue" (eye strain or wrist/hand strain or both), especially on multiple and large displays at high resolution. WAO ( window/ arrange/h orizontal), and so on through tens or hundreds of very frequently used menu combinations. What I am looking for is some trickery, macro, add-in, something that replicates being able to hold down the "Alt" (option or command or control on the Mac) key and type TOG (for example), which will instantly execute toggling grid on or off (Tools/Option/Grid). When you need to pound in data, keeping your hands on the keyboard is always faster than typing, the mouse/eye, then hands back to typing, then mouse/eye. What I am interested in is leveraging keyboard commands, since although not GUI and oh-so-not-nouveau- cool, are the old fashioned way expert users get work done really fast. This question is application specific (Office) I know about OS system shortcuts (and use those often as well). I'm also not interested in the Accessibility feature (Ctrl-F2) which is very slow compared to direct access since you're essentially replicating a mouse action, rather than an actual keyboard shortcut.

#USE PASTE SPECIAL IN EXCEL FOR MAC MAC#

In Windows Excel 2003, you can access any menu command through the keyboard in a very efficient way.Ī lot of Mac people respond to Alt-key questions with the standard shortcuts (Command "O" is open) or thinking the problem is that there is user confusion because there is no Alt key ("it's the Option or Command key"). If you've never used Excel on a Windows machine, you will likely misunderstand this request (based on my review of Google search results).

I am looking for Alt-key navigation for the Mac versions of Windows Office (at least as available through Windows Office 2003 versions). Since I can't take "no" for an answer I thought I'd try this forum, although doesn't seem to have a place for non-Apple apps for the Mac.

#USE PASTE SPECIAL IN EXCEL FOR MAC HOW TO#

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.An ongoing shortfall on the Mac (for me) has always been the lack of Alt-key control of the menus in Office-in Word, PowerPoint and especially Excel. Of course, you can create a new workflow for each of the three cases.Īfter creating the service, you can assign a shortcut for the service in System Preferences. line above, use: paste special active cell what paste formulasĪnd the values of formulas inside Excel can be pasted with the following code: paste special active cell what paste values If you want to paste formulas inside Excel with a script, instead of paste special. It doesn't work with Excel formulas.Īlso 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. Note that this only works when pasting text from some other application. Paste special on worksheet active sheet format "Unicode text" After hitting F2, the cursor will be placed after the existing content.Ĭreate a service with Automator that receives no input in Excel and has one Run AppleScript action with the following code: on run In addition, this method doesn't replace the existing cell value. Note that when pasting a formula, only the value will be pasted.Īlso 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. 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. This is probably the easiest method.Īnother possibility is to write a Visual Basic script.

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. Record a macro in Excel with commands explained above. 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.

#USE PASTE SPECIAL IN EXCEL FOR MAC FULL#

(If you have set Full Keyboard Access in System Preferences on, you have to hit ⇥ tab first in 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. However, you could try one of the following methods. There isn't any direct shortcut for what you are asking.