to get an excel cell square what are the values?

Lesson seven: Cell Basics

/en/excel2013/saving-and-sharing-workbooks/content/

Introduction

Whenever you work with Excel, yous'll enter data—or content—into cells. Cells are the basic edifice blocks of a worksheet. You'll demand to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.

Optional: Download our practise workbook.

Agreement cells

Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. Columns are identified past letters (A, B, C), while rows are identified by numbers (1, 2, 3).

A cell

Each jail cell has its own proper noun—or cell address—based on its cavalcade and row. In this example, the selected cell intersects column C and row five, and so the cell address is C5. The cell address will as well appear in the Proper name box. Notation that a cell'southward column and row headings are highlighted when the cell is selected.

Cell C5

You tin can as well select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the prison cell range, separated past a colon. For example, a jail cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.

In the images below, ii dissimilar cell ranges are selected:

• Cell range A1:A8

  Cell range A1:A8
  

• Cell range A1:B8

  Cell range A1:B8
  

If the columns in your spreadsheet are labeled with numbers instead of messages, y'all'll need to change the default reference way for Excel. Review our Extra on What are Reference Styles? to acquire how.

To select a cell:

To input or edit prison cell content, you'll commencement need to select the cell.

1. Click a cell to select it.
2. A edge volition appear effectually the selected cell, and the cavalcade heading and row heading volition be highlighted. The jail cell will remain selected until you click another cell in the worksheet.

   Selecting a single cell

Yous can as well select cells using the arrow keys on your keyboard.

To select a cell range:

Sometimes you may want to select a larger group of cells, or a cell range.

1. Click, hold, and elevate the mouse until all of the adjoining cells you want to select are highlighted.
2. Release the mouse to select the desired prison cell range. The cells will remain selected until you lot click another jail cell in the worksheet.

   Selecting a cell range

Cell content

Any data you lot enter into a spreadsheet will exist stored in a prison cell. Each cell can comprise different types of content, including text, formatting, formulas, and functions.

• Text
  Cells tin can incorporate text, such as letters, numbers, and dates.

  Cell text

• Formatting attributes
  Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, percentages can appear equally 0.15 or 15%. Yous can fifty-fifty change a cell's background colour.

  Cell formatting

• Formulas and functions
  Cells can contain formulas and functions that summate jail cell values. In our example, SUM(B2:B8) adds the value of each jail cell in cell range B2:B8 and displays the total in cell B9.

  Cell formulas

To insert content:

1. Click a cell to select information technology.

   Selecting cell A1

2. Type content into the selected cell, then printing Enter on your keyboard. The content volition announced in the jail cell and the formula bar. You can also input and edit prison cell content in the formula bar.

   Inserting jail cell content

To delete cell content:

1. Select the jail cell with content you want to delete.

   Selecting a cell
   

2. Printing the Delete or Backspace key on your keyboard. The jail cell's contents will exist deleted.

   Deleting prison cell content

You can employ the Delete key on your keyboard to delete content from multiple cells at in one case. The Backspace central will only delete one cell at a time.

To delete cells:

There is an important difference betwixt deleting the content of a cell and deleting the cell itself. If you lot delete the entire cell, the cells below it will shift upwards and supervene upon the deleted cells.

1. Select the cell(s) you want to delete.

   Selecting a cell to delete

2. Select the Delete command from the Home tab on the Ribbon.

   Clicking the Delete command

3. The cells below will shift upward.

   Cells shifted to replace the deleted prison cell

To copy and paste jail cell content:

Excel allows you lot to copy content that is already entered into your spreadsheet and paste that content to other cells, which tin can salvage you fourth dimension and endeavour.

1. Select the cell(southward) you want to re-create.

   Selecting a cell to re-create

2. Click the Copy command on the Home tab, or printing Ctrl+C on your keyboard.

   Clicking the Copy command

3. Select the cell(due south) where you want to paste the content. The copied cells will now have a dashed box around them.

   Pasting cells

4. Click the Paste command on the Habitation tab, or press Ctrl+Five on your keyboard.

   Clicking the Paste command

5. The content volition be pasted into the selected cells.

   The pasted jail cell content

To cut and paste prison cell content:

Unlike copying and pasting, which duplicates cell content, cutting allows y'all to move content between cells.

1. Select the cell(s) you want to cut.

   Selecting a jail cell range to cut

2. Click the Cut command on the Domicile tab, or printing Ctrl+Ten on your keyboard.

   Clicking the Cut control

3. Select the cells where you want to paste the content. The cutting cells will now take a dashed box around them.

   Pasting cells
   

4. Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.

   Clicking the Paste control

5. The cut content will be removed from the original cells and pasted into the selected cells.

   The cut and pasted cells

To access more than paste options:

You can also access boosted paste options, which are especially user-friendly when working with cells that incorporate formulas or formatting.

• To access more paste options, click the drop-down arrow on the Paste command.

Additional Paste options

Rather than choose commands from the Ribbon, you lot can admission commands quickly past right-clicking. But select the cell(southward) you want to format, and then correct-click the mouse. A drop-down menu will appear, where you'll notice several commands that are also located on the Ribbon.

Right-clicking to access formatting options

To elevate and drop cells:

Rather than cutting, copying, and pasting, y'all can drag and drop cells to move their contents.

1. Select the cell(s) you desire to move.
2. Hover the mouse over the border of the selected prison cell(s) until the cursor changes from a white cross to a black cross with four arrows .

   Hovering over the cell border
   

3. Click, concord, and drag the cells to the desired location.

   Dragging the selected cells

4. Release the mouse, and the cells volition be dropped in the selected location.

   The dropped cells

To apply the fill handle:

There may exist times when y'all need to copy the content of one cell to several other cells in your worksheet. Y'all could re-create and paste the content into each cell, but this method would be time consuming. Instead, you can use the fill handle to quickly copy and paste content to next cells in the same row or cavalcade.

1. Select the cell(south) containing the content you desire to use. The fill handle volition appear every bit a small square in the bottom-right corner of the selected prison cell(s).

   Locating the make full handle

2. Click, concur, and drag the fill handle until all of the cells y'all desire to fill are selected.

   Dragging the fill handle

3. Release the mouse to fill up the selected cells.

   The filled cells

To continue a series with the fill up handle:

The fill handle can as well be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, three) or days (Monday, Tuesday, Wednesday), the make full handle can guess what should come next in the series. In many cases, you may need to select multiple cells before using the fill handle to help Excel determine the series social club. In our instance below, the fill handle is used to extend a series of dates in a cavalcade.

Using the fill handle to extend a series

The extended series

Yous can also double-click the fill handle instead of clicking and dragging. This tin be useful with larger spreadsheets, where clicking and dragging may be bad-mannered.

Watch the video beneath to run across an example of double-clicking the fill up handle.

To utilise Flash Fill:

A new feature in Excel 2013, Flash Fill tin can enter data automatically into your worksheet, saving yous fourth dimension and effort. Just similar the fill handle, Wink Fill up can guess what type of information y'all're entering into your worksheet. In the example below, nosotros'll apply Flash Fill to create a list of first names using a list of existing electronic mail addresses.

1. Enter the desired information into your worksheet. A Wink Fill preview volition appear beneath the selected cell whenever Wink Fill is available.

   Previewing Flash Fill data

2. Press Enter. The Flash Fill data will be added to the worksheet.

   The entered Flash Make full data

To change or undo Flash Fill, click the Flash Fill push button next to recently added Wink Fill data.

Clicking the Flash Fill button

Find and Supplant

When working with a lot of data in Excel, it tin can be difficult and time consuming to locate specific information. Yous tin easily search your workbook using the Find feature, which also allows you to alter content using the Replace feature.

To discover content:

In our instance, we'll use the Observe control to locate a specific name in a long list of employees.

1. From the Home tab, click the Find and Select command, then select Find... from the drop-downwards carte.

   Clicking the Find command

2. The Find and Replace dialog box volition appear. Enter the content you want to discover. In our example, we'll type the employee's proper noun.
3. Click Find Next. If the content is establish, the jail cell containing that content will be selected.

   Clicking Notice Next

4. Click Find Next to notice further instances or Find All to see every case of the search term.

   Clicking Find All

5. When yous are finished, click Close to go out the Observe and Supervene upon dialog box.

   Closing the Find and Replace dialog box

You can as well access the Find command by pressing Ctrl+F on your keyboard.

Click Options to come across advanced search criteria in the Find and Supercede dialog box.

Clicking Options

To replace cell content:

At times, y'all may discover that yous've repeatedly made a fault throughout your workbook (such as misspelling someone's proper noun), or that you need to commutation a particular discussion or phrase for another. Y'all can employ Excel'south Observe and Supersede feature to make quick revisions. In our example, we'll employ Find and Replace to correct a listing of email addresses.

1. From the Domicile tab, click the Notice and Select command, then select Replace... from the drop-downwardly menu.

   Clicking the Replace command

2. The Find and Replace dialog box will appear. Blazon the text you desire to find in the Find what: field.
3. Type the text you want to replace it with in the Replace with: field, then click Notice Next.

   Clicking Discover Adjacent

4. If the content is found, the cell containing that content will exist selected.
5. Review the text to make sure yous want to replace it.
6. If you want to replace it, select one of the supersede options:
   • Supercede volition replace individual instances.
   • Replace All will supplant every case of the text throughout the workbook. In our case, we'll choose this option to save fourth dimension.

   Replacing the highlighted text

7. A dialog box will announced, confirming the number of replacements made. Click OK to continue.

   Clicking OK

8. The selected cell content volition be replaced.

   The replaced content

9. When you lot are finished, click Close to exit the Find and Replace dialog box.

   Endmost the Find and Replace dialog box

Challenge!

1. Open an existing Excel 2013 workbook. If you lot want, you tin use our practice workbook.
2. Select cell D3. Find how the cell address appears in the Name box and its content appears in both the cell and the Formula bar.
3. Select a cell, and endeavor inserting text and numbers.
4. Delete a prison cell, and notation how the cells below shift up to fill in its identify.
5. Cut cells and paste them into a dissimilar location. If you are using the example, cut cells D4:D6 and paste them to E4:E6.
6. Try dragging and dropping some cells to other parts of the worksheet.
7. Use the fill up handle to fill up in data to bordering cells both vertically and horizontally. If y'all are using the example, utilize the make full handle to continue the series of dates across row three.
8. Use the Find feature to locate content in your workbook. If you are using the example, type the name Lewis into the Find what: field.

/en/excel2013/modifying-columns-rows-and-cells/content/

cutshawdurette.blogspot.com

Source: https://edu.gcfglobal.org/en/excel2013/cell-basics/1/

Share this post