Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values are not visible
I have a worksheet with column "c" showing a result of a formula. I'm just
simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values are not visible
Not sure what's happening, but if you want to link to col C,
you could try this in say, E1: =IF(C1="","",C1) Copy E1 down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Milan" wrote: I have a worksheet with column "c" showing a result of a formula. I'm just simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values are not visible
Milan
When you move data, which is the results of a formula, with the drag handle (plus"+" sign) those references that are not absolute will increment to the appropriate cells when you drag. If you want to move the data it would be better to copy then Paste special/values. Mike Rogers "Milan" wrote: I have a worksheet with column "c" showing a result of a formula. I'm just simply trying to copy this number to another cell/column by using +. Though the number is visible on column "C" it is not visible on the column that I'm trying to copy with +. Please help. Thanks a million in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum visible cells only | Excel Discussion (Misc queries) | |||
sum visible row only | Excel Discussion (Misc queries) | |||
sum only visible cells | Excel Worksheet Functions | |||
can i sum up only visible cells? | Excel Worksheet Functions | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |