Home |
Search |
Today's Posts |
#1
|
|||
|
|||
enter data into multiple formulas at once
I am using Microsoft Outlook 2003 (work) and XP (at home)
All I would like to do is enter the same data range (ie D12:D56) into multiple formulas. An example would be: one formula to count the numbers in that range, and another to sum those numbers. This would save time by eliminating the need to copy the same range into different cells over and over again. Instead you could somehow paste the range into multiple cells at once (or something similar) If this is already possible, please let me know, I have searched the online help extensively and have not found any answers. Thanks ---------------- 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...et.f unctions |
#2
|
|||
|
|||
enter data into multiple formulas at once
Give the Range a RangeName...........Insert Name Define...........then
use the RangeName in the formulas............ Vaya con Dios, Chuck, CABGx3 "Fen" wrote: I am using Microsoft Outlook 2003 (work) and XP (at home) All I would like to do is enter the same data range (ie D12:D56) into multiple formulas. An example would be: one formula to count the numbers in that range, and another to sum those numbers. This would save time by eliminating the need to copy the same range into different cells over and over again. Instead you could somehow paste the range into multiple cells at once (or something similar) If this is already possible, please let me know, I have searched the online help extensively and have not found any answers. Thanks ---------------- 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...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge multiple row cells of text corresponding to one row of data | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) |