liteleads.blogg.se - Short cut key on excel mac for paste special

#Short cut key on excel mac for paste special how to#
#Short cut key on excel mac for paste special download#

Copy and perform an arithmetic operation.

Examples of using Paste Specials in Excel.

Excel Paste Special options and shortcut keys.

But did you know that apart from pasting a whole cell, you can paste only a certain attribute such as value, formula, formatting or comment? That's where Paste Special comes in.Įxcel Paste Special makes the pasting operation smoother by letting you choose which formatting (source or destination) to keep or by stripping all formatting and just pasting the values or formulas. I believe everyone knows the shortcut to copy a cell ( Ctrl+C) and to paste it ( Ctrl+V).

#Short cut key on excel mac for paste special how to#

Tomorrow: The (selective) return of smart quotes in Microsoft Word.The tutorial explains how to use Paste Special in Excel and how to make the process more efficient by using paste special shortcuts to paste values, formulas, comments, formats, column width, and more.Ĭopy pasting in Excel is easy. Click Yes to make the shortcut available when you reopen the application.

When you close Excel, you'll be asked if you want to save the changes in the Personal Macro Workbook. In Excel 2007, click Home*Paste*Paste Special*Text*OK*View*Stop Recording. In Excel 2003, click Edit*Paste Special*Text*OK, and press the Stop Recording button on the tiny toolbar that popped up when you closed the Record Macro dialog box. Click in the "Shortcut key" box, type t (or the letter of your choice, as long as it isn't already assigned to a shortcut that begins with Ctrl), and press OK. Enter a name in the "Macro name" field, beginning with a character, and without any spaces or punctuation. In Excel 2007, click View*Macros*Record Macro. In Excel 2003, click Tools*Macro*Record New Macro. Here's the fastest way I know of to create a plain-paste keyboard shortcut in Microsoft Excel: First, select any text and press Ctrl-c to place it in the clipboard. Give Excel a plain-paste keyboard shortcut Set a keyboard shortcut for your plain-paste macro in Word. Scroll to and select Macros in the Categories window, select the PlainPaste macro in the window to the right, click in the "Create new keyboard shortcut" field, type Ctrl-t (or your choice of combination, beginning with Ctrl, Alt, and/or Shift), click Assign, then Close, and finally OK. To assign the keyboard shortcut in Word 2007, click the Office button in the top-left corner, choose Word Options at the bottom of the window, click Customize in the left pane, and then the Customize button to the right of "Keyboard shortcuts" at the bottom of the Word Options dialog box. Choose PlainPaste (or whatever you named the macro) in the right pane, click in the "Press new shortcut key" box, type Ctrl-t (or the unused key combination of your choice, beginning with Ctrl, Alt, and/or Shift), select Assign and then Close twice. Scroll down the Categories list in the top left and select Macros. Next, assign a keyboard shortcut to the macro: In Word 2003, click Tools*Customize*Commands, make sure Normal.dot is selected in the "Save in" drop-down menu, and click the Keyboard button. Only the text should appear, in the format of the document, not of the source. Now test the macro: Select a mix of text and other elements in your browser or some other application, press Ctrl-c to place it on the clipboard, return to Word, click Tools*Macro*Macros in Word 2003, or View*Macros in Word 2007, select PlainPaste in the list of Macros, and click Run. Type this text in the penultimate line of your macro to paste plain text. Press Ctrl-s to save the macro, and click File*Close and Return to Microsoft Word. The only space in the line is between "PasteSpecial" and "Datatype:". Place the cursor at the beginning of the line just above "End Sub" and type Selection.PasteSpecial DataType:=wdPasteText.

In both versions, type PlainPaste in the Macro name field (you can name it anything you like, but the name must begin with a letter, have no spaces, and use no punctuation), and choose Create. Paste plain text in Word via the keyboard my thanks to the reader below for pointing out this error.) If both the source and destination programs are open when you initially copy the text, you need only press PureText's shortcut key to paste the text without images, formatting, and other non-text elements. This is true only if you open the destination app after the material you want to paste has been added to the clipboard. (Note that the original post of this tip reported that PureText required that you click its icon in your system tray before you press the shortcut keys to paste plain text.

#Short cut key on excel mac for paste special download#

You can create a macro to get the same functionality in Word and Excel, without having to download anything. Last week I described the PureText utility that lets you paste plain text in Word and other applications via a keyboard shortcut.