G
Guest
How can I apply a forula to numerous rows at the same time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Select the range that gets the formula.
Write the formula using the active cell in that selection
Instead of hitting enter, hit ctrl-enter to fill all the cells in that
selection.
Excel will adjust the formula for each of those cells. Just like when you
copy|paste.
Write the formula using the active cell in that selection
Instead of hitting enter, hit ctrl-enter to fill all the cells in that
selection.
Excel will adjust the formula for each of those cells. Just like when you
copy|paste.
G
Guest
Thanks for the help. When I tried this, it did not work for me. Rather than
calculate the formula independently for each different row, excel used the
numbers that were in the initial formula and applied them to all the rows and
colums selected... The formula is the same for all rows but because the
figures are different in each row the calculations for eary row should be
different.
calculate the formula independently for each different row, excel used the
numbers that were in the initial formula and applied them to all the rows and
colums selected... The formula is the same for all rows but because the
figures are different in each row the calculations for eary row should be
different.
N
Niek Otten
Tools>Options>Calculation tab, check Automatic
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thanks for the help. When I tried this, it did not work for me. Rather than
| calculate the formula independently for each different row, excel used the
| numbers that were in the initial formula and applied them to all the rows and
| colums selected... The formula is the same for all rows but because the
| figures are different in each row the calculations for eary row should be
| different.
|
| "Dave Peterson" wrote:
|
| > Select the range that gets the formula.
| > Write the formula using the active cell in that selection
| > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > selection.
| >
| > Excel will adjust the formula for each of those cells. Just like when you
| > copy|paste.
| >
| > ManhattanRebel wrote:
| > >
| > > How can I apply a forula to numerous rows at the same time?
| >
| > --
| >
| > Dave Peterson
| >
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thanks for the help. When I tried this, it did not work for me. Rather than
| calculate the formula independently for each different row, excel used the
| numbers that were in the initial formula and applied them to all the rows and
| colums selected... The formula is the same for all rows but because the
| figures are different in each row the calculations for eary row should be
| different.
|
| "Dave Peterson" wrote:
|
| > Select the range that gets the formula.
| > Write the formula using the active cell in that selection
| > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > selection.
| >
| > Excel will adjust the formula for each of those cells. Just like when you
| > copy|paste.
| >
| > ManhattanRebel wrote:
| > >
| > > How can I apply a forula to numerous rows at the same time?
| >
| > --
| >
| > Dave Peterson
| >
M
ManhattanRebel
Thank you.. I am using Microsoft Office Excel 2007.. I do not see a Tool
option. Where should I look for it?
option. Where should I look for it?
N
Niek Otten
Office button (top left)>Excel Options>Formulas tab, check Automatic
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thank you.. I am using Microsoft Office Excel 2007.. I do not see a Tool
| option. Where should I look for it?
|
| "Niek Otten" wrote:
|
| > Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Thanks for the help. When I tried this, it did not work for me. Rather than
| > | calculate the formula independently for each different row, excel used the
| > | numbers that were in the initial formula and applied them to all the rows and
| > | colums selected... The formula is the same for all rows but because the
| > | figures are different in each row the calculations for eary row should be
| > | different.
| > |
| > | "Dave Peterson" wrote:
| > |
| > | > Select the range that gets the formula.
| > | > Write the formula using the active cell in that selection
| > | > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > | > selection.
| > | >
| > | > Excel will adjust the formula for each of those cells. Just like when you
| > | > copy|paste.
| > | >
| > | > ManhattanRebel wrote:
| > | > >
| > | > > How can I apply a forula to numerous rows at the same time?
| > | >
| > | > --
| > | >
| > | > Dave Peterson
| > | >
| >
| >
| >
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thank you.. I am using Microsoft Office Excel 2007.. I do not see a Tool
| option. Where should I look for it?
|
| "Niek Otten" wrote:
|
| > Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Thanks for the help. When I tried this, it did not work for me. Rather than
| > | calculate the formula independently for each different row, excel used the
| > | numbers that were in the initial formula and applied them to all the rows and
| > | colums selected... The formula is the same for all rows but because the
| > | figures are different in each row the calculations for eary row should be
| > | different.
| > |
| > | "Dave Peterson" wrote:
| > |
| > | > Select the range that gets the formula.
| > | > Write the formula using the active cell in that selection
| > | > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > | > selection.
| > | >
| > | > Excel will adjust the formula for each of those cells. Just like when you
| > | > copy|paste.
| > | >
| > | > ManhattanRebel wrote:
| > | > >
| > | > > How can I apply a forula to numerous rows at the same time?
| > | >
| > | > --
| > | >
| > | > Dave Peterson
| > | >
| >
| >
| >
M
ManhattanRebel
Thank you.. I found it and it is checked. Can you walk me through how to
write a simple formula and how to apply it to multiple rows and columns at
one time?
write a simple formula and how to apply it to multiple rows and columns at
one time?
N
Niek Otten
What are your formulas?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thank you.. I found it and it is checked. Can you walk me through how to
| write a simple formula and how to apply it to multiple rows and columns at
| one time?
|
| "Niek Otten" wrote:
|
| > Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Thanks for the help. When I tried this, it did not work for me. Rather than
| > | calculate the formula independently for each different row, excel used the
| > | numbers that were in the initial formula and applied them to all the rows and
| > | colums selected... The formula is the same for all rows but because the
| > | figures are different in each row the calculations for eary row should be
| > | different.
| > |
| > | "Dave Peterson" wrote:
| > |
| > | > Select the range that gets the formula.
| > | > Write the formula using the active cell in that selection
| > | > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > | > selection.
| > | >
| > | > Excel will adjust the formula for each of those cells. Just like when you
| > | > copy|paste.
| > | >
| > | > ManhattanRebel wrote:
| > | > >
| > | > > How can I apply a forula to numerous rows at the same time?
| > | >
| > | > --
| > | >
| > | > Dave Peterson
| > | >
| >
| >
| >
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thank you.. I found it and it is checked. Can you walk me through how to
| write a simple formula and how to apply it to multiple rows and columns at
| one time?
|
| "Niek Otten" wrote:
|
| > Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Thanks for the help. When I tried this, it did not work for me. Rather than
| > | calculate the formula independently for each different row, excel used the
| > | numbers that were in the initial formula and applied them to all the rows and
| > | colums selected... The formula is the same for all rows but because the
| > | figures are different in each row the calculations for eary row should be
| > | different.
| > |
| > | "Dave Peterson" wrote:
| > |
| > | > Select the range that gets the formula.
| > | > Write the formula using the active cell in that selection
| > | > Instead of hitting enter, hit ctrl-enter to fill all the cells in that
| > | > selection.
| > | >
| > | > Excel will adjust the formula for each of those cells. Just like when you
| > | > copy|paste.
| > | >
| > | > ManhattanRebel wrote:
| > | > >
| > | > > How can I apply a forula to numerous rows at the same time?
| > | >
| > | > --
| > | >
| > | > Dave Peterson
| > | >
| >
| >
| >