ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   paste special all and column widths (https://www.excelbanter.com/excel-programming/381406-paste-special-all-column-widths.html)

joeycalisay

paste special all and column widths
 
i've been looking around why the all paste type does not include column
widths, shouldn't it be "all except for column widths", any good reason
for this? thanks!


Joerg

paste special all and column widths
 
No good reason, I guess. "All" actually means "Most" (= all options beneath
"All", not all options in the dialog box). MS could have placed the "Column
width" option (on the right side) below the "All", then you (and I) would
get what we want.

Interestingly: If you copy whole columns, then "All" means "all including
column with". Plain inconsistent.

Joerg


"joeycalisay" wrote in message
ups.com...
i've been looking around why the all paste type does not include column
widths, shouldn't it be "all except for column widths", any good reason
for this? thanks!




joeycalisay

paste special all and column widths
 
i see, thanks for that joerg

Joerg wrote:
No good reason, I guess. "All" actually means "Most" (= all options beneath
"All", not all options in the dialog box). MS could have placed the "Column
width" option (on the right side) below the "All", then you (and I) would
get what we want.

Interestingly: If you copy whole columns, then "All" means "all including
column with". Plain inconsistent.

Joerg


"joeycalisay" wrote in message
ups.com...
i've been looking around why the all paste type does not include column
widths, shouldn't it be "all except for column widths", any good reason
for this? thanks!




All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com