Page 9 - Excle-En-V3

Figure 25: coloring the worksheet tab ....................................................................................................................................... 26
Figure 26: Changing the color of grid lines ................................................................................................................................. 27
Figure 27: Hide or show gridlines, column and row headers ...................................................................................................... 27
Figure 28: On the right, the grid lines, column and row headers are visible, and on the left they are hidden ............................ 27
Figure 29: Switch between Open Files ....................................................................................................................................... 28
Figure 30: Workbook Views ....................................................................................................................................................... 28
Figure 31: Zoom the workbook (zoom in - zoom out) ................................................................................................................ 29
Figure 32: Select one cell or more .............................................................................................................................................. 29

Figure33 : Select nonadjacent cells .......................................................................................................................................... 29

Figure 34: Select coloumns/rows ............................................................................................................................................... 30
Figure 36: select the entire worksheet....................................................................................................................................... 31
Figure 35: Select a table or list ................................................................................................................................................... 31
Figure 37: Naming cell or range of cells...................................................................................................................................... 31

Figure38 : Naming cell or range of cells using Defined Names.................................................................................................. 32

Figure 39: Using name in formula .............................................................................................................................................. 32
Figure 40: Summation of May, June and July ............................................................................................................................. 33
Figure 41: Create from selection ................................................................................................................................................ 33

Figure42 : column width / row height ...................................................................................................................................... 35
Figure43 : Inserting Column / Row........................................................................................................................................... 36
Figure44 : Removing Column / Row ......................................................................................................................................... 36

Figure 45: Hiding columns steps/ Hiding columns result ............................................................................................................ 37
Figure 46: Unhiding column ....................................................................................................................................................... 37
Figure 47: Freeze rows and columns .......................................................................................................................................... 38

Figure48 :Unfreeze rows and columns ..................................................................................................................................... 38

Figure 49: Defining a set of columns and rows as a table ........................................................................................................... 39

1 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024