Thread
:
Excel 2003 should have "multiply multiple cells" macro / shortcut
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
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
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy