where is the transpose button in excel 2010

The Paste Visible feature of Paste Buddy is a solution to the error message you receive in Excel when attempting to paste to a filtered range with hidden rows or columns. It is especially useful for the commands that you don't use that often. You can use this a reference to help you remember your shortcut keys. This list is formatted for printing so you can print it out and put it on your desk.

How are you going to remember all these? Pressing the “Key List” button on the setup window will create a new Excel workbook with a list of all your shortcut keys. You can create up to 12 different keyboard shortcuts in the Paste Buddy setup window. You can press Ctrl+Z or the Undo button to undo your action. The Paste Buddy shortcut key works just like any other paste special command in Excel. Only the value of the copied cell will be pasted in the selected cell. The formula and formatting will NOT be copied. Select a blank cell and press Ctrl+Shift+V to paste the values of the copied cell.Select a cell in your worksheet that contains a formula and/or formatting and press Ctrl+C to copy it.That's it! The shortcut to Paste Values is now setup as Ctrl+Shift+V Now put it to the test: The Operation drop-down can be left as None for this example. Select Values from the Paste Option drop-down box in row 1.Type the letter V (or any key you want) in the Key text box in row 1.Let's walk through an example of how to setup a keyboard shortcut to Paste Values:Ĭlick the Paste Buddy button in the Add-Ins tab of the Ribbon. These operations include: Add, Subtract, Multiple, Divide, Transpose, & Skip Blanks. Operation – This is the additional operation that can be performed with the paste option.There are a list of 11 different paste special options in the Paste Option drop-down boxes. Paste Option – This is the Paste Special command that will be performed when the keyboard shortcut is pressed.In the example above, the keyboard shortcut for paste values is setup as Ctrl+Shift+V.

The Key is the third key that is required in the keyboard shortcut. All shortcuts begin with Ctrl+Shift.The full keyboard shortcut is Ctrl+Shift+Key. Key – This is the keyboard shortcut combination that will perform the paste special command when pressed.The setup window contains a list of 12 keyboard shortcuts where you can customize the following: In this setup window you can create the keyboard shortcuts that will perform the paste special commands.

Where is the transpose button in excel 2010