0
How do you paste content of column of one sheet in the row of other sheet in open office?
Wiki User
∙ 11y ago
- In the source sheet: select the column cells with values (they must be contiguous but cells with no values are OK)
- In the destination sheet select the leftmost cell of the row where you want the values
- Choose the menu item: Edit>Paste special
- A dialog opens in which, towards the bottom, in the Options section there is a radio button labled "Transpose" click that button so it is filled
- Check if any other modifiers are to be used when pasting the values
- Click
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Paste cell to different Excel worksheet?
# Copy the contents (right click, copy or CTRL+C) # Switch to the target sheet and activate the cell where you want to paste. # Paste the contents (right click paste or CTRL+V) Note: If the content was a formula, you will by default paste a cell reference. If you want the actual value, you can Edit, Paste Special, Value. If the target or originating cell are merged with another or other cells, you will have to double click on the original and taget and paste the content inside the cell.
How can you capture content from a webpage for documentation purposes?
You can capture content from a web page for documentation purposes like this. 1. You can copy the content of the web page and paste in doc. file 2. You can take the screen shot and paste in Paint programm and select the content which is useful to you. Copy the selected portion and paste in doc. file
How do you copy a column of numbers from Excel that are calculated with a formula?
Highlight the column of numbers. Copy with either the menu selection or ctrl-c. Go to where you want to paste the column. Go to the menu selection Paste Special. A box will pop up, select Values.
What copies the new items on the office clipboard to the paste area?
paste button
How do you paste Hindi words in Microsoft office word 2007?
just copy and paste it
How do you paste pictures in Microsoft office?
Microsoft Office programs are fully copy-and-paste compatible. Locate the picture, copy it, place the insertion point where you want the picture, and select Paste from the Edit menu.
What is difrrence between paste and paste special?
Paste will just paste whatever you've copied. Paste Special in Wordpad has a few options to paste in different formats which are as a Wordpad document, Rich Text Format, a picture and unformatted text. It is much more limited in options compared to Paste Special in other applications.
Can you embed Excel charts in other Microsoft Office applications?
Yes you can. You can copy the chart and then paste it into other files, such as Powerpoint slides or Word documents.
Why will a column will not change during the copy process?
The source column (where you copy from) will remain the same, but the target column (where you paste to) will change. That is the function of copy. If you are unable to copy to a column, check to ensure protection is turned off.
What content can one find in Paste Magazine?
The content on Paste Magazine centers around pop culture. Enthusiasts can find information on the best of music, movies, games, books, festivals and television.
When you paste text the text is moved from?
Office Cipboard
An alternative to clicking the Paste button is to?
Hit Ctrl V ---------------------- An alternative to clicking the Paste button is to press the Enter Key. The Enter Key completes the paste operation, removes the marquee from the source area, and disables the Paste button so that you cannot paste the copied source area to other destination areas. PAGE EX153 Microsoft Office 2010
