Excel sheet increases when using Paste Special's Multiply option.

[bnkolev]

Hi all,

I have a lot of columns in excel that I want to multiple by the same number, but want to do it in the same cells without having to create new sheets etc. I found the Paste Special + Multiply option. It does the job, but it increases the size of my excel sheet by a significant number. It seems it is multiplying the empty cells in the selected columns and I could not find a way around it. is there a way to do this without increasing the size of my excel sheet?

Thanks, Boris

 

[JLGWhiz]

Hi all,

I have a lot of columns in excel that I want to multiple by the same number, but want to do it in the same cells without having to create new sheets etc. I found the Paste Special + Multiply option. It does the job, but it increases the size of my excel sheet by a significant number. It seems it is multiplying the empty cells in the selected columns and I could not find a way around it. is there a way to do this without increasing the size of my excel sheet?
Thanks, Boris

Try using

SkipBlank:=True

argument.

Or if doing it manually, check the 'Skip Blanks' box.

 

[bnkolev]

Even with Skip Blanks box, it multiplies the empty cells and gives a value "0" to where previously the cells where empty.

 

[bnkolev]

Try using

SkipBlank:=True

argument.

Or if doing it manually, check the 'Skip Blanks' box.

Even with Skip Blanks box, it multiplies the empty cells and gives a value "0" to where previously the cells where empty.

 

[JLGWhiz]

that is odd. On my system, the blanks remain blank.