| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy cells
Switch between relative, absolute, and mixed references
1.. Select the cell that contains the formula. 2.. In the formula bar , select the reference you want to change. 3.. Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Formula being copied Reference (Description) Changes to $A$1 (absolute column and absolute row) $A$1 A$1 (relative column and absolute row) C$1 $A1 (absolute column and relative row) $A3 A1 (relative column and relative row) C3 -- Don Guillett SalesAid Software "Pass Codes" wrote in message ... .I'm trying to copy a cell range in a cell, then copy down that cell without the range changing in each cell. It seems to automatically drop down the range per cell. Does this make sense? Geo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Threaded Mode
