paste wrap
I've read several threads on this topic, but they didn't help.
Situation: When I paste a selection from MSAccess into MSExcel, the result always is a wrap (which is a rather extreme wrap when the Access field is wide and the Excel column width is default). My default in Excel is set to "no wrap". After reading the threads, I discovered that if I use paste special, I can say "text" and it won't bring in the formats (which for some reason seems to include text wrapping, even though MSAccess doesn't even have that as a visible option.) But, I'm an old-style cut and paster ( ctrl+c ctrl+v ) Paste special involves a lot of mousing. Is there any way to make the default paste use the default wrap setting? |
paste wrap
Don't know of a way to make paste special values the default, but you can
keep your hands on the keyboard using Ctrl +c, then Alt +e, s, v "makulski" wrote: I've read several threads on this topic, but they didn't help. Situation: When I paste a selection from MSAccess into MSExcel, the result always is a wrap (which is a rather extreme wrap when the Access field is wide and the Excel column width is default). My default in Excel is set to "no wrap". After reading the threads, I discovered that if I use paste special, I can say "text" and it won't bring in the formats (which for some reason seems to include text wrapping, even though MSAccess doesn't even have that as a visible option.) But, I'm an old-style cut and paster ( ctrl+c ctrl+v ) Paste special involves a lot of mousing. Is there any way to make the default paste use the default wrap setting? |
paste wrap
You could select your entire sheet, go to your menu Format|Row|Height, and
press OK. (Note: This is assuming you have changed no row heights and is still at your default row height, i.e.: 12.75). This will 'make' the row heights all the same, and prevent wrapping while pasting. -- John C "makulski" wrote: I've read several threads on this topic, but they didn't help. Situation: When I paste a selection from MSAccess into MSExcel, the result always is a wrap (which is a rather extreme wrap when the Access field is wide and the Excel column width is default). My default in Excel is set to "no wrap". After reading the threads, I discovered that if I use paste special, I can say "text" and it won't bring in the formats (which for some reason seems to include text wrapping, even though MSAccess doesn't even have that as a visible option.) But, I'm an old-style cut and paster ( ctrl+c ctrl+v ) Paste special involves a lot of mousing. Is there any way to make the default paste use the default wrap setting? |
paste wrap
I'm 2 out of 3 with you. (I haven't used the alt+ short-cuts before).
alt+e brings up the edit menu alt+s brings up paste special dialog box Unfortunately, this box presents a set of choices MS Excel 8, Biff5, HTML etc. but they do not have any keyboard shortcuts. (I'm using Excel 2003) "Duke Carey" wrote: Don't know of a way to make paste special values the default, but you can keep your hands on the keyboard using Ctrl +c, then Alt +e, s, v |
paste wrap
Ah yeah, that works.
It doesn't save me any time for a one-off, because it is an extra operation. But if I have to do a session of cut-and-pastes, your suggestion is helpful. Thanks. "John C" wrote: You could select your entire sheet, go to your menu Format|Row|Height, and press OK. (Note: This is assuming you have changed no row heights and is still at your default row height, i.e.: 12.75). This will 'make' the row heights all the same, and prevent wrapping while pasting. -- John C |
paste wrap
With those presented choices, sounds like you are copying between two
separate instances of Excel. Close one instance and open both workbooks in one instance. Alt + E + S will work properly. Gord Dibben MS Excel MVP On Thu, 7 Aug 2008 06:52:02 -0700, makulski wrote: I'm 2 out of 3 with you. (I haven't used the alt+ short-cuts before). alt+e brings up the edit menu alt+s brings up paste special dialog box Unfortunately, this box presents a set of choices MS Excel 8, Biff5, HTML etc. but they do not have any keyboard shortcuts. (I'm using Excel 2003) "Duke Carey" wrote: Don't know of a way to make paste special values the default, but you can keep your hands on the keyboard using Ctrl +c, then Alt +e, s, v |
All times are GMT +1. The time now is 05:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com