BookmarkPrint
Contents
Home > Microsoft Office > Excel > Cells and Data Organization - Excel


Cells and Data Organization - Excel
How to manipulate cells and organize data in Excel.

Quick links to sections in this article:
Cell Navigation     
Adding and Removing Cells    
Tables     
Charts     
Functions

Cell Navigation
Your workbook is organized by a series of rows and columns called cells. Columns are indicated by letters. Rows are indicated by numbers. An individual cell is named first by its column, then its row (like A1).

You can select multiple cells by first clicking on one cell and clicking another cell while holding down [Shift].
Excel will automatically fill in every cell in between the two cells you clicked on.

Move a cell by clicking on the border of a selected cell and dragging it to your desired location.

Use the same process for moving a group of cells.

Adding and Removing Cells

Adding Cells
Step 1:
Click on a cell.


Step 2:Click Insert, located in the Cells section under the Home tab.

Step 3:Click Insert Rows to insert an entire row above the selected cell. Click Insert Columns to insert an entire column to the left of the selected cell. Clicking Insert Cells & Shift Right inserts a single cell and moves the other content in the row to the right one space. Clicking Insert Cells & Shift Down inserts a single cell and moves the other content in the column down a space.

Deleting Cells
Step 1:
Click on a column, row, or group of cells that you want to delete.
Step 2:Click Delete, located in the Cells section under the Home tab.

Step 3:Click Delete Sheet Columns, Delete Sheet Rows, or Delete Cells... depending on what you want to do. Click Delete Cells & Shift Left to delete the selected cell(s) and shift the remaining content (the content that's to the right of the selected cell(s)) in the row to the left. Click Delete Cells & Shift Up to delete the selected cell(s) and shift the remaining content (the content that's below the selected cell(s)) in the column up.
You can also remove a row by selecting the row, right-clicking, and selecting Delete.


Tables


Step 1:Type out the data you wish to use. Shown below is an example of monthly sales data.

Step 2:
Select the data.

Step 3:Click the Insert tab and click Table.

Step 4:Click OK.

Step 5:
If your table did not have headers, give each column a header by typing in the indicated cells.



Charts


Step 1:Type out the data you wish to use. We'll use the same example of monthly sales data that we used before.


Step 2:
Select the data.


Step 3:
Under the Insert tab, choose the type of chart that you would like to use. This data will use a bar chart.

Step 4:To edit text, simply click on the text box. Use the plus icon to include different aspects of the chart to match your level of specificity.


Functions

This particular set of data is in a table format. Your data does not necessarily have to be in a table format to execute mathematical functions.

AutoSum Tool:Click in the cell where you wish to execute the function. Under the Home tab, click AutoSum. Click on the function that you would like to use. For this data, we'll use Sum.

Function Notation:
Once you've selected the type of function you would like to execute, you can input the cells that you would like to include in your function in the text bar above your spreadsheet. Click on the cells that you wish to be included in the function. Separate multiple cell sections with commas.
If you wish to use a range of cells: rather than inputting every single cell, choose the first and the last cell and separate them with a colon. This will include every cell in between the two endpoints in your function.

End your function with a parenthesis and press [Enter].
Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=cells_and_data1