joining worksheets
"how do i move text from one worksheet to another without it changeing the
colum width of either part?" say i have 2 coums one width is 10 and the second is 15, that is worksheet 1, what i want to do is move info from worksheet 2 and there are 2 colums, one with a width of 5 and the other is 20. Is it even possible to move the text to the first worksheet without changing the colum size of either page? |
joining worksheets
Brion,
1) Use linking formulas, then convert to values 2) Copy just the cells of interest, not the entire column, and paste HTH, Bernie MS Excel MVP "Brion" wrote in message ... "how do i move text from one worksheet to another without it changeing the colum width of either part?" say i have 2 coums one width is 10 and the second is 15, that is worksheet 1, what i want to do is move info from worksheet 2 and there are 2 colums, one with a width of 5 and the other is 20. Is it even possible to move the text to the first worksheet without changing the colum size of either page? |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com