Right click the sheet tab>Move or copy>Check create a copy> To book select
'new book' and click OK./
If you want multiply the cel values by say (2) enter 2 in a ununsed cell.
copy the cell. Keeping the copy ; select the range of cells you would want to
multiply. Right click >PasteSpecial>Multiply > OK.
1. Right-click the sheet tab and choose Move or Copy, select (new book) from
the To book dropdown and check Create a copy, click OK.
2. Enter the constant in a blank cell of the new workbook and press Ctrl+C
3. Select the entire range you want multiplied and choose Edit, Paste
Special, Multiply.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.