it is better to copy a column than to create an empty column

copy column does not work when auto-filter is on


sample formula
--------------
=n649/j649


copy column n and insert it at n
--------------------------------
rt-click column n, choose copy
rt-click, choose insert copied cells
if it just says "insert", then turn off filter                                                                                                                                                                        
copy a cell
-----------
rt-click on the cell to copy (or Ctrl-C)
choose "copy"
up-arrow (only once)
hold shift
up-arrow to top (many times while holding shift)
let go of shift
rt-click on grey area (or Ctrl-V)
choose "paste" (first clipboard)

to copy down
------------
use down-arrow like up-arrrow

to "warp" to the end of the data
--------------------------------
hit "End" key
hit arrow (up/left/down/right)