搜尋此網誌

2023年11月26日星期日

Excel skill

How to select two sets of data in excel?

Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

support.microsoft.com


Esc Key cancels an entry in the cell or Formula Bar.

www.excelhowto.com


How to select the cells of one column until the last used cell?

Selecting the first cell and then pressing CTRL+SHIFT+ARROW key. Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.

support.microsoft.com

沒有留言:

發佈留言