 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2007Trouble copying info into a spreadsheet
When I copy info from a spreadsheet into another (blank) spreadsheet, why doesn't it copy the same format as it was in the old spreadsheet? I do "paste special" but it never comes out quite the same. No doubt I'm doing something wrong :) I just don't know what it might be!! Thanks :) Meenie Exactly what is not being copied in the way of formats? What version of Excel do you have. When you say spreadsheet are you talking about another worksheet in the same workbook, or to a sheet in a separate workbook (.xls file) completely? I ask because some people use the term spreadsheet to mean a single worksheet while others use it mean a .xls file. And you're probably not doing anything wrong - just doing something not-quite-completely right (to Excel's way of thinking, but probably not to the rest of the world). > When I copy info from a spreadsheet into another (blank) spreadsheet, why > doesn't it copy the same format as it was in the old spreadsheet? I do "paste > special" but it never comes out quite the same. > No doubt I'm doing something wrong :) I just don't know what it might be!! > Thanks :) > Meenie Sorry J :) I have Excel 2000, and this is from one worksheet in a workbook to another page in the same workbook (altho it seems to behave the same way if it's to a new worksheet in a new workbook also). and it's the formatting that isn't being copied - mostly the sizes of the cells. I see in "paste special" you can paste it in then return to "paste special" again and click on "column height" and the column height will change to the correct one, but there is no "row width" so you have to go and fix that manually. Why is that? When you first do the "paste special" it defaults to "all" but it doesn't really copy it ALL in ! :) Yes, I've noticed that excel thinks a bit differently than I do, lol (but Word is much much worse!!) Thanks > Exactly what is not being copied in the way of formats? What version of > Excel do you have. [quoted text clipped - 14 lines] > > Thanks :) > > Meenie OOOPS I wrote height and width backwards!!! Sorry. YOU know what I mean :D > Sorry J :) > I have Excel 2000, and this is from one worksheet in a workbook to another [quoted text clipped - 31 lines] > > > Thanks :) > > > Meenie It sounds to me as if things are working properly. Not the way you'd like them to, but properly. Cell width is still not copied in Excel 2007. Why it should adjust in one dimension and not the other is another of those mysteries that may one day end up on the wide screen as a Speilburg or Peckinpaw epic. What's interesting is that if you go to your original sheet and click the column header then use the Format Painter (little paint brush tool) and then click the column header in the copied-to sheet, then you get width/height adjustments also. > Sorry J :) > I have Excel 2000, and this is from one worksheet in a workbook to another [quoted text clipped - 31 lines] > > > Thanks :) > > > Meenie Are those guys distantly related to Spielberg and Peckinpah? Gord >It sounds to me as if things are working properly. Not the way you'd like >them to, but properly. Cell width is still not copied in Excel 2007. Why it [quoted text clipped - 42 lines] >> > > Thanks :) >> > > Meenie Distant cousins - twice removed by alien abduction. Most famous for 'B' movies and low budget copycat films of current big money makers. > Are those guys distantly related to Spielberg and Peckinpah? > [quoted text clipped - 46 lines] > >> > > Thanks :) > >> > > Meenie Thanks I think... lol. You'd think it'd work better by the time they got to 2007! :) The paint feature works sometimes and sometimes doesn't. It's a sad sad thing :) Any clue why "print preview" is so poor? :D > It sounds to me as if things are working properly. Not the way you'd like > them to, but properly. Cell width is still not copied in Excel 2007. Why it [quoted text clipped - 42 lines] > > > > Thanks :) > > > > Meenie Sorry, no real explanation for a poorer quality print preview. I've noticed what I'd call a general degradation of appearance on LCD monitors in most of the new products coming out: IE 7 and Office 2007 - I don't know whether it's choice of font styles, colors or a really strange engine driving it all. Or maybe I'm just getting old and picky and just don't like change for simply change's sake. > Thanks > I think... lol. You'd think it'd work better by the time they got to 2007! :) [quoted text clipped - 48 lines] > > > > > Thanks :) > > > > > Meenie I was making a workbook with 4 sheets, each sheet had exactly the same information on it. I created the first one, then copied the info to the other three. But when I looked at them in print preview - and when I printed them out - I discovered that each one was a different size! The original fit perfectly on the page. The second one didn't - even though I looked at each column and the measurements were the same, it went off the page! If I went to "print preview" and moved the lines, then the graph was very small on the page. And each page the size was proportionatly different! Finially I discovered that when I copied the first spreadsheet, the margins changed on the left and right from 0.25 each side to 0.75 on each side!!!! Good heavens... and I thought row height and column width were a pain!! Meenie > Sorry, no real explanation for a poorer quality print preview. I've noticed > what I'd call a general degradation of appearance on LCD monitors in most of [quoted text clipped - 55 lines] > > > > > > Thanks :) > > > > > > Meenie |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.