Một số phím tắt trong excel mà các bạn có thể sử dụng, giảm 30% thời gian di chuyển chuột và rất tiện dụng, các bạn thử xem nhé! 1. Basic excel short cut Bold whole row (Shift Space Dog + Bold whole column (Control + Space) Insert row (Shift + Space to bold row, (Ctrl + +) to insert whole row 1. Basic excel short cut Paste fomular only (Alt + E + S + F) Paste change row to colunm (Alt + E + S + E) Change from worksheet to other worksheet (Ctrl + Tab) Insert column (Ctrl + Space to bold column, (Ctrl + +) to insert whole column Delete row (Shift + Space to bold row, (Ctrl + -) to delete whole row Insert column (Ctrl + Space to bold column, (Ctrl + -) to delete whole column Copy all (Control + C) Paste all (Control + V) Paste value only (Alt + E + S + V) Paste format only (Alt + E + S + T) Change working window (Alt+ Tab) Open new worksheet (Ctrl + N) Close 1 window (Alt + F + C) Close window (Alt + F4) Save as (F12) Free panes: (Alt + W + F) Hide row: (Ctrl + 9) Hide column (Ctrl + 0)
Posted on: Fri, 23 Aug 2013 08:50:11 +0000
Trending Topics
Recently Viewed Topics
© 2015