Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
When I insert a row, it will give me a blank row. I am trying to insert a
row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
Copy the row above where you want the new row. Select the row immediately below. Right-click the row header and choose "Insert Copied Cells" from the popup menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "JDNETTC" wrote in message When I insert a row, it will give me a blank row. I am trying to insert a row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
Here is the problem though....I have a database query that returns data into
a table...which from what I understand is treated differently from regular work sheet rows. When i refresh the data, it adds rows automatically, which is why I want to know how to automatically update a row with the formulas above it. Copying and pasting is too time consuming for the amount of refreshes that I do. Is it something I have to do with my settings? I use Excel 2007. "Jim Cone" wrote: Copy the row above where you want the new row. Select the row immediately below. Right-click the row header and choose "Insert Copied Cells" from the popup menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "JDNETTC" wrote in message When I insert a row, it will give me a blank row. I am trying to insert a row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
I have four versions of Excel but none of them are the 2007 version. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "JDNETTC" wrote in message Here is the problem though....I have a database query that returns data into a table...which from what I understand is treated differently from regular work sheet rows. When i refresh the data, it adds rows automatically, which is why I want to know how to automatically update a row with the formulas above it. Copying and pasting is too time consuming for the amount of refreshes that I do. Is it something I have to do with my settings? I use Excel 2007. "Jim Cone" wrote: Copy the row above where you want the new row. Select the row immediately below. Right-click the row header and choose "Insert Copied Cells" from the popup menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "JDNETTC" wrote in message When I insert a row, it will give me a blank row. I am trying to insert a row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting rows while keeping cell contents the same
I figured out my own problem. Essentially, since my data was part of an
Excel table, when it updated, it updated independently of my worksheet rows/columns. I grabbed the little handle on the lower right of my table and included all the columns to the right that included my formulas. Now, when I refresh my ODBC data, everything updates very nicely. "JDNETTC" wrote: When I insert a row, it will give me a blank row. I am trying to insert a row in the middle of many rows of formulas, and I want the row to be auto-populated with the correct formula. Instead of: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted and blank) Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk I want: Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk My actual spreadsheet is more complicated, but the principle is what I need to get working. JD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting rows keeping the merged cells | Excel Discussion (Misc queries) | |||
Keeping Formulas the same when inserting columns | Excel Discussion (Misc queries) | |||
Keeping contents of cell A1 showing when scrolling. | Excel Worksheet Functions | |||
Taking contents of a cell an inserting them into a phrase. | Excel Discussion (Misc queries) | |||
Inserting new row but keeping formulae | Excel Worksheet Functions |