2.pdf

Excel To select a column in the Excel sheet, we click on the column name. Also, to select a row, we click on the row name. To select all, either through the keyboard we press CTRL + A, or through the mouse cursor in the right corner of the paper if it is on t...

Excel To select a column in the Excel sheet, we click on the column name. Also, to select a row, we click on the row name. To select all, either through the keyboard we press CTRL + A, or through the mouse cursor in the right corner of the paper if it is on the right side, or in the left corner if it is on the left side. To move the worksheet from right to left or vice versa, we go to the Page Layout menu, then click on Sheet Right to left. Add a custom data series to Excel)‫)أضافه سالسل بيانات مخصصة لالكسيل‬: File → Option→ Advanced → Edit Custom Lists Place the mouse cursor in the List Entries box, then enter the required list items, separating each item with a comma, then click OK. Use the fill button to enter the data series: If you want to enter a series of numbers from 1 to 500 so that each value is 1 greater than the previous one, then resorting to the previous method is considered a waste of time and effort, as you will have to drag with the mouse across 500 rows. To facilitate this, we use the fill button. Home → editing → Fill → series From the dialog box that appears, we enter the increment value and the stop value and make sure that the row or column is selected. Add or delete paperwork To add a new worksheet, we use one of the following methods: Click on the New Sheet button. We press the shortcut keys Shift + F11. In this case, a new sheet will be added before the current sheet. Right-click any worksheet and choose the Insert command. To delete a worksheet, right-click on the worksheet name, then choose the Delete command. To rename the worksheet we use the following: Right-click on the worksheet name and choose the Rename command. Double-click the worksheet name, and then change the name. Change the order of the papers To change the order of one of the worksheets, we use one of two methods: We click with the left mouse button on the desired worksheet, then by continuing to press we drag towards the new location. We right-click on the desired worksheet, then choose the Copy or Move command. The dialog box for moving or copying will appear. We select the sheet from which we will move the current worksheet to the previous one, then press OK. Hide and show worksheets Sometimes you may want to hide some worksheets to make the workbook appear simpler or to hide data within selected worksheets. To hide a worksheet or a group of worksheets, we select the required sheets, click on them with the right mouse button, and then choose the Hide command. To show hidden worksheets, we right-click on the name of any worksheet, then choose the Unhide command, and the dialog box for showing worksheets appears. We select the worksheets we want to show, then click OK. Hide and show rows and columns To hide a row or column, we select the row or column, then right-click anywhere in the selection and choose the Hide command from the menu. To show hidden rows or columns, we select a column before the hidden column and at least one column after it, then right-click on the selection and choose the command Unhide. Merge Cells Merging cells is one of the good formatting options provided by Excel, as it is possible to merge two or more cells into one cell that occupies the same space as the merged cells. When merging cells, the cells must be empty, otherwise Excel will delete the contents of all the merged cells except the cell at the top left of the merged cells. To merge a group of cells, select the required cells, then go to the main page, then to Alignment, then Merge and Center. To cancel the merge, click again. Display text at a specified angle Go to Orientation in toolbar -Borders. Number formatting.