Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If I copied a cell (A10) form another worksheet to B10 of my current
worksheet. If I copy B10 from my current worksheet and paste it to N10, what symbol should I use to maintain the information from A10 insted of I10. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Back in B10 of the current worksheet there should be a formula that looks like:
=[Book1]Sheet1!$A$10 If it is missing the $ symbols, put them into it. Now no matter where you copy that cell to, the column and row references will remain the same. This is called absolute addressing. If the $ in front of the column reference is not there, then the column indicator will change as you copy left or right of the original column; if the $ is missing in front of the row indicator then the row number will change as you copy it into rows above or below the original location. These rules apply to cell references within a book also. See Help on Absolute and Relative addressing. "Need HELP" wrote: If I copied a cell (A10) form another worksheet to B10 of my current worksheet. If I copy B10 from my current worksheet and paste it to N10, what symbol should I use to maintain the information from A10 insted of I10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying the data in and format of a cell to another cell | Excel Discussion (Misc queries) | |||
When copying a cell to another cell the information is duplicated. | Excel Worksheet Functions | |||
Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Copying excel format from cell to cell | Excel Discussion (Misc queries) |