excel tips

1. how to apply the formula to the while column(ranges)

  • Copy your formula Ctrl + C
  • press ↓
  • Ctrl + Shift + ↓ selects to the last nonblank cell
  • paste Ctrl + V

 

posted @ 2017-02-21 18:04  glf2046  阅读(139)  评论(0)  编辑  收藏  举报