ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Paste link does not work properly (https://www.excelbanter.com/excel-worksheet-functions/28175-paste-link-does-not-work-properly.html)

kurb

Paste link does not work properly
 
Hello

I want the column and row headings in all workshhets to follow what I
have in Sheet 1.

When I do a Paste Link with All option I encounter the following problems:

1. The formatting is not copied (merged cells are not merged, bold fonts
are not bold)

2. All blank cells in original have the value 0 in the copied (Paste
Link option not permitted when selecting Skip Blanks)

Appreciate any suggestions
Thanks
K

Duke Carey

What results do you get if you first paste in regular fashion, then paste
speicalpaste links?

"kurb" wrote:

Hello

I want the column and row headings in all workshhets to follow what I
have in Sheet 1.

When I do a Paste Link with All option I encounter the following problems:

1. The formatting is not copied (merged cells are not merged, bold fonts
are not bold)

2. All blank cells in original have the value 0 in the copied (Paste
Link option not permitted when selecting Skip Blanks)

Appreciate any suggestions
Thanks
K



All times are GMT +1. The time now is 05:20 PM.

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