We recently upgraded to Office Pro 2003. I copy several cells from one tab to another. Because of differences in column widths, I use the CTRL-COPY and SHIFT-EDIT > PASTE PICTURE option. In Excel XP when I used the SHIFT-EDIT > PASTE PICTURE menu command, the picture held the color formatting. In Excel 2003 it pastes as black text. Is there a way to get the color formats to be pasted? -- I know enuff to be dangerous.
shift-edit paste picture in Excel
3 posts
• Page 1 of 1
- 1. How convert excel into csv file with Vietnamese support?
I need to convert an excel file into csv file to import into the database. However, I cannot do with Vietnamese file as the font is error. Could anyone show me how to do so? - 2. Create workbook
My school is doing a Call-a-thon to raise some money. I have been asked to create a workbook to keep track of the donations as well as find out the largest donation, most donations (per individual), the most raised (per individual), and the most raised per capita for teams. They have asked for me to be able to edit the names and amounts on a laptop screen while showing just the current winners (with team members) and stats on a projector. I was wondering if anybody could create a workbook or give me some advice. Usually I am pretty good at this kind of thing, but this is just stumping me. - 3. Hide and unhide...what the heck!!??
Okay...I have been working with Excel a long time...and this one has me baffled! A co-worker is trying to hide/unhide columns in a pretty basic worksheet (Office 2003)...when he goes to Window-Hide...it hides the ENTIRE WORKBOOK...not a column, not a line, not even just a worksheet...THE WHOLE WORKBOOK just disappears! You go back to Window-Unhide and it asks if you want to unhide Workbook -(FileName)? When you click okay it is all back. We did discover that you can hide and unhide columns and rows by right clicking and using that route...but for some reason the other way does the funny business of hiding everything! Any thoughts on how to fix this would be GREATLY appreciated! Thanks in advance! - 4. Remove any letter from a referenced cell
Hi all, I would like to know if there is any easy way to filter out the letters off a reference. If A1 contains... aBcD123e-FgH 45i& I would like a formula that would return the following in B1: 123- 45& Any idea??? Thanks in advance for any thinking (even fruitless), comments and answers, F茅lix
Next
shift-edit paste picture in Excel
by UmVhbEdvbWVy » Tue, 27 Feb 2007 23:00:05 GMT
RE: shift-edit paste picture in Excel
by Sm9lbA » Tue, 27 Feb 2007 23:35:12 GMT
When copying from one worksheet to anotherr a keep formating you need to do two steps. first paste the data. Then repeat the paste using the Edit Menu - Select Paste Special. Select format.
RE: shift-edit paste picture in Excel
by Ymo » Wed, 28 Feb 2007 00:05:10 GMT
The time someone in my office had a similar problem, his default printer was a black and white printer and the "copy picture as printed" copied it in black and white, so when he pasted it, it pasted in black and white.
Similar Threads:
1.Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile)
Hi: I am copying a section of an Excel Spreadsheet, and then pasting into word using Paste Special -> Picture (Enhanced Metafile) When I right click on the object in word, one of the menu choices is "Edit Picture" This will allow me to change text in the picture, which seems to be included through the use of text boxes. I make a minor change that is required, but then I cannot seem to revert the image or picture back to its previous form, which seems to be as a normal picture file that has been inserted. The only way I can figure out how to do this is by using the undo command, but I loose my text chance. If the picture stays in the new, editable format, whenever I click into it, all of the text is becomes highlighted, which really slows down my ability to continue work on the rest of the document. The new format seems to be seen by word as a Drawing Canvas. Does anyone know how I can make a text change, and then get Word to see the image as an inserted picture file again as opposed to this drawing canvas? Thanks, Brooks
2.Editing a Table Pasted from Excel into Word as a Picture (Enhanced
If you need to edit the text in the table, I'd recommend pasting special as an Excel worksheet object, not as a picture. It'll show as a metafile anyway, but when you need to edit you can edit in in Excel. -- ----------------------------------------- This posting is provided "as is" with no warranties, and confers no rights.
3.Edit text in a picture in Word (to be pasted into Excel)
I have a word document which contains tables of data. When I am trying to copy the tables of data to Excel, I am right clicking the mouse and it has options to copy a picture. So while the data appears to be a MSWord table, it is actually a 'picture'. I want to just grab the raw text, paste it in excel and start some analysis. Any suggestions how I can edit the picture and get the raw text into Excel?
4.Excel 2007 Beta Pasted Pictures All Turn Into Last Pasted Picture
I created a workbook with several pages. I copy and pasted 3 maps from Microsoft Streets and Trips 2006 onto each sheet. When I close Excel 2007 beta and open it again, all of the pasted images are the same picture as the most recently pasted image. This is something that I am able to duplicate and it happens every time. It does not, however, happen in Excel 2002. Is there something that I can do to fix this? Or should I wait until the next beta release? Geremia Doan
5.Cannot Edit pasted Picture in Word 2003
I recently rolled out Office 2003 to my organization and when we used to be on Office 2000 we would be able to take a print screen and paste it into Word. well now since we are on Office 2003 once the picture is pasted into the word document, you cannot right click on the picture and hit edit, EDIT is grayed out. How can I get this EDIT option available to me? Any help would be appreciated Thanks Keith Schlottman
6. Having trouble pasting a picture from Office Picture Mgr to Excel
7. Excel 2007 Beta Pasted Pictures All Turn Into Last Pasted Pict
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 0 guest