In this comprehensive article, you will learn how to work with cells (cells) in Excel software in a visual and step-by-step manner.
This tutorial does not make any difference for the 2010 to 2016 versions and you can use it in any version.
When you work with Excel software , you bring information or content into homes. Houses are the main building blocks of a computer screen. Need to learn the concepts of houses and the content of houses to calculate, analyze and organize work in Excel. Understanding Homes – All computer programs are made up of thousands of squares called houses.
A house consists of the cross section of a row (row) and a column (column) (as shown below). Columns are denoted by the letters ABC, while rows are denoted by the numbers 1, 2, and 3.
Each house has a specific name or home address and is specified based on columns and rows. For example, the selected house intersects column C and row 5 so that the house shown is C5. The home address is displayed in the name box. Note that the column headings and rows of cells are displayed when the cells are selected.
You can also select different houses at the same time. A group of houses is called a house area. In addition to a single home address, you can refer to the home area using the home addresses of the first and last column of homes in the home area. For example, you can write the area of a house, which includes cells A1, 2, 3, 4, and 5, as A1: A5. In the following command, two items from different house ranges are selected:
House range A1-8
House range A1-B8
If the columns on your computer screen are marked with numbers instead of letters, you need to change the default reference style for Excel. Examine the extras in the resource style. To learn how.
To select a cell:
To enter or edit home content, we need to select home first. Click a house to select it. A house border is marked around the selected house and the column header and row header are displayed. The house is selected until you click on another house on the computer screen. You can also select houses using row clicks on your keyboard.
To select a cell range: Sometimes your goal is to select a larger group of cells or a range of cells. Click, hold, and drag until all adjacent cells you want to select are displayed. Release the mouse to select the desired home area. The cells remain selected until you click on another cell on the computer screen.
Home Content – Any information that enters a computer screen is stored in a home. Each box can contain different types of content, including text, format, formula, and functions.
Text – Boxes can contain text such as formulas, numbers, and dates.
Formatting Features – Homes can include formatting features that change the way letters, numbers, and dates are displayed. For example, the percentage can be displayed as 15 or 15%. You can even change the background color of the house. You must know that Excel software is part of the international icdl test or the seven computer skills. So follow the work with the cells carefully.
Formulas and Functions – Houses can contain formulas and functions that calculate the value of cells. In this example, SUM increases the value of each of these cells in the range of cell B2 to B8 and shows their total value in cell B9.
To place content: Click on a house by selecting it.
Type the content in the selected box and then press Enter on the keyboard. Content is displayed in the home and formula bar. You can also enter and edit home content in the formula bar.
To delete home content
Select the home with the content you want to delete.
Press the delete key or the backspace on your keyboard. House content is deleted.
You can use the delete key on the keyboard to delete content from multiple cells at once. Clickback can only delete one cell at a time.
To delete houses – There is an important difference between deleting the contents of a house and deleting that house itself. If you delete the entire cell of the house, the cells below it can go up and replace the deleted cells. Select the cells you want to delete.
Select the delete command from the Home tab on the ribbon.
The following houses come up.
To copy and paste the contents of the houses: Excel allows you to copy the content that is entered into the computer screen and paste this content to other houses, which can save you time and effort. Select the cells to which you want to paste the content.
The copied houses have a dotted box around them.
Click on the track tab on the Home tab or press the + V control on the keyboard.
Content is pasted in selected cells.
To cut and paste the contents of the houses:
Unlike copying and pasting, which doubles the content of the houses, cutting allows you to move the content between the houses. Select the houses you want to cut.
Click the cut command on the Home tab or press the X + control on your keyboard.
Select the boxes in which you want to paste the content. The cut houses have a dotted box around them.
Click on the track command on the Home tab or press the V + control on your keyboard.
Cutting the content takes it out of the main houses and puts it in the selected houses.
To access more Paste options:
You can access more track options, which is especially convenient when working with homes that include formulas or formatting. To access more track options, click on the drop down row on the track command.
In addition to selecting commands from the ribbon, you can access the commands by right-clicking. Simply select the cells you want to format. Next, right-click on the mouse. A drop-down list is displayed, in which you can find several commands located in the ribbon.
To stretch and remove cells:
In addition to cut, copy, and paste, you can drag and drop cells to move their contents. Select the cells you want to move. Move the mouse over the selected margins until the cursor changes from a white cursor to a black cursor with four rows of cursors.
Click, hold and drag the cells to the desired position.
Release the mouse and the cells are deleted in the selected position.
To use the fill application – in some cases you need to copy the contents of one cell to several other cells on your computer screen. You can copy and paste content into any home, but this can be time consuming. Alternatively, you can use the fill section to quickly copy and paste content into adjacent cells in the same row and column.
Select the cells that contain the content that you intend to use.
The fill part is seen as a small circle in the lower right margin of the selected cells. Click, hold, and drag until all the cells you want to fill are released, release the mouse.
To be able to fill the selected cells.
For all or a set with a filling handle
The filling handle can be used to continue a series. When the contents of a row or column follow a content order, such as numbers 1, 2, 3, or on Mondays, Tuesdays, and Wednesdays, the fill batch can indicate what is seen in the rest of the series. In various cases, you may need to select multiple cells before using the fill handle to help determine the axial order of the series. In the following example, the fill handle is used to expand a set of dates in a column.
To use Flash Elephant: A new feature in Excel 2013 is Flash Elephant, which can automatically insert data into the page, saving time and effort. Like the elephant handle, the elephant flash can guess what types of information you are entering into a computer screen. The following example uses the elephant flash to generate a list of names using a list of available email addresses. Enter the desired information on your page. The elephant flash overview is shown below the selected cell when the elephant flash is available.
Enter. Elephant Flash data is added to the worksheet.
To modify or change the status of FlashFalle, click on the FlashFil button next to the recently added FlashFal data.
Find and replace
When working with data sets in Excel, putting specific information will be difficult and time consuming. You can easily search for your assignments using the find phrase, which allows you to modify the content using the replace phrase .
To find content:
For example, we used the term find to place or display a long list of employees. From the Home table , click on Find and Select, and then select Find. Do this from the drop-down list.
The Find and Replication dialog box is revealed. Enter the content you want to find. For example, we can type the name of the employee.
Click on Find next . If the list is viewed, the house is selected from this list. Click on Find next to find other sentences and examples, or find all items with so you can see all examples of search terms.
When you are done, click close to close the dialog box below and replay
. You can also access the find phrase by pressing Ctrl + F on your keyboard. Click Options to view the Advanced Search Criterion Dialog Box below and Replace.
To replace the content of the house:
Over time, you can discover that you have consistently made a mistake in your homework (such as the name of a person mispronounced) or you can exchange a particular word or phrase with each other. Kurds. You can use Find and Replication Excel for quick fixes. In this example, we used Find and Reply to correct a list of email addresses. From a Home tab, click on Find and Select, and then select Replay, which is done from the drop-down list. The Find and Replication dialog box is revealed. Type the text you want to find in Find.
Type the text you want to replace with Replay and then click FindNext. If the content is viewed, the cell containing this content is selected. Review the text and make sure your goal is to replace it.
If your goal is to replace this item, select one of the alternatives. Replace it by replacing specific samples. Its replica replaces all text instances in the assignment. In this example, we have selected this option to save time.
The dialog box appears. Verification is done for replacements. Click to continue.
The contents of the selected cell are replaced.
When done, click close to exit the drop-down dialog and replace.
This is the most complete tutorial on working with cells or cells in Excel software that you can find. If you have a problem with working with Excel cells, be sure to raise it in the comments section with the quick and easy website so that we can answer it.