You change the formula from, say, =B!sheet2!A7 to =B!sheet2!A7/3. Repeat for all cells. Copying the formula using the copy handle makes it rather fast and convenient process.
Kees
Hi
im using MS office excel 2007 enterprise version.
i have a excel with a worksheet full of numbers say 'A' which are linked from another excel file say 'B'. i wanted to divide all the numbers in the excel file 'A' by a single number
can any one tell me how to do it?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic