answersLogoWhite

0

Paste Special lets you copy cell contents and copy selected cell contents to another cell. The paste special command has a number of useful tools built into it. Besides allowing you to paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

In Excel which Paste option do you choose to paste a linked Access table?

To paste a linked Access table in Excel, you should choose the "Paste Special" option and then select "Paste Link." This creates a dynamic link between the Access table and the Excel worksheet, allowing any updates made in Access to automatically reflect in Excel. Make sure to copy the table from Access first before using the Paste Special feature in Excel.


What is the command that pastes formulas with rows and columns switched in Excel?

From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.From the Paste section of the menu or ribbon, select Paste Special, then click Transpose.In earlier versions of Excel, Paste is under the Edit menu. In current versions it is in the Paste section of the Home ribbon.


How do you insert cells from a clip board on excel 2007?

paste


How do you copy a function to another cell in excel?

Copy and Special Paste formulas.


Can you switch data from Works to Excel?

Yes, you can import MS Works data into MS Excel. thanks you can use two options first is paste and other one is paste special which is linked with excel with word.


What is the button that allows you to copy values with or without formatting or format only?

hi..to paste the selected cells in value/other formats press the folllowing in a sequential order (not simultaneously) 1. alt 2. E 3. V 4. S Then, select the desired option


If you update a date in Excel can that be automatically updated in word For example ABC job Completion date is April 2007 I type that in Excel is there a way it can update word?

The answer is yes. In Excel 2007, make the cell or cells with dates and then copy them. Goto Word and select Edit from the menu and choose Special Paste and/or Paste Link. I think the other way is to start in Word 2007 and click on Insert a Table or Insert something and just follow the wizard


How do you set cells in excel for only copy the content?

You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.You can use the Paste Special option to choose what to copy.


Which Paste Special option can give you trouble with the formatting of your spreadsheet data?

Microsoft office excel worksheet object


Have you linked the files when you connect a Word document to a separate Excel worksheet?

If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.If you do a Paste Link, then there will be a connection maintained between the Word document and the Excel Workbook.


When you copy data and paste in excel sheet it pasting only formulas not the data how can I copy the data when the content is formula made?

Use the Paste Special facility. From there you can then choose to paste the values, rather than the formulas.


What is the name of the button in excel that allows you to copy values with or without formatting?

Paste Special allows copying with or without formatting