View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel 2003 should have "multiply multiple cells" macro / shortcut

In the Sigma Dropdown, Choose more functions and Choose product

--
Regards,
Tom Ogilvy


"Tommy D" <Tommy wrote in message
...
Why cant there be a function that will multiply several highlighted cells
with a simple click, like Sigma does for addition?

Many times I need to multiply 2 to 4 adjacent cells together and I have to
write the formula. I want to be able to highlight the 2 to 4 adjacent

cells
and click a button that means multiply these together. Just like the

"sigma"
or Sum function only for multiplication.

Anyone have suggestions or comments?




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow

this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...el.programming