Freezing data: For those who have a column with a formula like =A2*B2 and you would like how to mass copy google docs lock in The end result, you may copy the column and paste it about itself as Values. The formulas will get replaced by their benefits. Push Ctrl + C to copy. Excel will sign this by Placing a marching ants border about Just about every visible cell or block of cells. For subcomponent assets, copy the mother or father asset 1st. Then copy the subcomponent asset, defaulting the asset everyday living according to the subcomponent daily life rule you described with the tax category and the mother or father asset everyday living. You need to arrange the depreciation strategy for the subcomponent asset life before You can utilize the method and lifestyle. It really is Extremely Repetitive: If this can be a job you repeat day-to-day, weekly, or every month, the drudgery can be draining and consider you away from more essential strategic Examination.