Excel Tutorial - Chapter 2: Selecting Cells

in #education5 years ago

The following actions are based on ‘demo.xlsm’. Now move to the tab ‘Selecting cells’ and click on the cell ‘B4’, which is the position of the letter ‘a’.

image.png

Actions Effects
Hold ‘Ctrl’, and then click on ‘f’. Any cells that you click on while holding ‘Ctrl’ will be selected. In this case, ‘a’ and ‘f’ will be selected.
Hold ‘Shift’, and then click on ‘f’. A rectangular block of cells with the original cells and the newly clicked cell as two vertices will be selected. In this case, ‘a’ to ‘f’ will be selected.
Press ‘Ctrl + arrow keys’. The selector will jump to the boundaries according to the specified direction. If you press ‘Ctrl + Down’, ‘g’ will be selected.
Press ‘Shift + arrow keys’. The selector will extend by one row or column according to the specified direction. If you press ‘Shift + Down’, ‘a’ and ‘d’ will be selected.
Press ‘Ctrl + Shift + arrow keys’. The selector will extend till the boundary according to the specified direction. If you press ‘Ctrl + Shift + Down + Right’, ‘a’ to ‘i’ will be selected.
Press ‘Ctrl + End’ The selector will go to the intersection of the furthest used row and column. In this case, E13 will be selected. Note that a cell is said to be ‘used’ even if it is formatted but there is no value in it. So this function can help you to check whether you have made unnecessary formatting which would waste storage space.
Press ‘Ctrl + Spacebar’

OR click on the letter ‘B’

The current column will be selected. In this case, column B will be selected
Press ‘Shift + Spacebar’

OR click on the number ‘4’

The current row will be selected. In this case, row 4 will be selected
Enter the range in the circled area The corresponding region will be selected. For example, if you enter ‘B4:D6, E10’, ‘a’ to ‘i’ together with ‘x’ will be selected.
Enter “myRange” in the circled area ‘j’, ‘k’ and ‘l’ are selected. This is called a named range. You can name a region by selecting the required region and type the desired name in the circled area. You can access the ‘Name Manager’ by going to the tab ‘Formula’.

image.png

 

Exercise

Refer to tab ‘Selecting cells (Exercise)’.


Posted from my blog with SteemPress : http://kenchung.vornix.blog/2018/11/02/excel-tutorial-chapter-2-selecting-cells/

Sort:  

你那里天气如何?请支持中文区的见证人, @abit @bobdos @ety001 @justyy @oflyhigh @partiko (首字母顺序),全投,一个都不要漏。假如我的留言打扰到你,请回复“取消”。

great one, I didn't know there are so many ways to select cells!

Hi @kenchung!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 4.256 which ranks you at #2656 across all Steem accounts.
Your rank has dropped 9 places in the last three days (old rank 2647).

In our last Algorithmic Curation Round, consisting of 275 contributions, your post is ranked at #144.

Evaluation of your UA score:
  • Some people are already following you, keep going!
  • The readers like your work!
  • Try to improve on your user engagement! The more interesting interaction in the comments of your post, the better!

Feel free to join our @steem-ua Discord server

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.040
BTC 70839.13
ETH 3563.41
USDT 1.00
SBD 4.77