Hi,
refer the attached file
mathan
On 7/29/09, balbirkumar . wrote:
>
>
> Hi Friends
>
> I want to multiply all cells in the excel sheet with a particular number.
>
> please help
>
> With
> Thanks & Regards
>
> Balbir Kumar
>
> >
>
--~--~-~--~~~---~--~~
---
Could you send your requirement as attachment, then we can give solutions
for that
On Wed, Jul 29, 2009 at 2:03 PM, balbirkumar . wrote:
>
> Hi Friends
>
> I want to multiply all cells in the excel sheet with a particular number.
>
> please help
>
> With
> Thanks & Regards
>
> Balbir Kumar
>
> >
Hello.
Enter this number in one cell in another sheet; copy it; select the sheet
you want to multiply; select all cells (Ctrl+A)
Paste / Paste special / Multiply, OK.
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Be
Dear Balbir,
Please follow the steps below.
1) Write the number in a cell in the sheet.
2) Copy the cell containing the number
3) Select the range you want to Multiply/divide
4) Right Click on the Selected Range and choose "Paste Special"
5) In Paste Special dialog box. Under Operation Group, you