Excel 2010 Modifying Columns, Rows, and Cells

Author: mety Nagm Labels:: , ,


Excel 2010

Modifying Columns, Rows, and Cells

Introduction

Lesson 17 
When you open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column widthinsert and delete rows and columnswrap text in a cell; andmerge cells.




Working with Columns, Rows, and Cells

Launch video!Watch the video (3:22). Need help?
Watch the video to learn about modifying columns, rows, and cells in Excel 2010, including wrapping text and merging cells.

To Modify Column Width:

  1. Position your mouse over the column line in the column heading so that the white cross Cursor becomes adouble arrow Double-arrow.
    Positioning mouse over the column linePositioning mouse over the column line
  2. Click and drag the column to the right to increase the column width or to the left to decrease the column width.
    Increasing the column widthIncreasing the column width
  3. Release the mouse. The column width will be changed in your spreadsheet.
    Increasing the column widthIncreased column width

To Set Column Width with a Specific Measurement:

  1. Select the columns you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Column Width.
    Increasing the column widthIncreasing the column width
  4. The Column Width dialog box appears. Enter a specific measurement.
    Increasing column width to 258 pixelsIncreasing column width to 258 pixels
  5. Click OK. The width of each selected column will be changed in your worksheet.
Select AutoFit Column Width from the format drop-down menu and Excel will automatically adjust each selected column so that all the text will fit.

To Modify the Row Height:

  1. Position the cursor over the row line so that the white cross Cursor becomes a double arrow Double-arrow.
    Positioning the mouse over the row linePositioning the mouse over the row line
  2. Click and drag the row downward to increase the row height or upward decrease the row height.
    Increasing the row heightIncreasing the row height
  3. Release the mouse. The height of each selected row will be changed in your worksheet.
    Increased row heightIncreased row height

To Set Row Height with a Specific Measurement:

  1. Select the rows you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Row Height.
    Increasing the column widthIncreasing the column width
  4. The Row Height dialog box appears. Enter a specific measurement.
    Increasing row height to 60 pixelsIncreasing row height to 60 pixels
  5. Click OK. The selected rows heights will be changed in your spreadsheet.
Select AutoFit Row Height from the format drop-down menu and Excel will automatically adjust each selected row so that all the text will fit.

To Insert Rows:

  1. Select the row below where you want the new row to appear.
    Selecting the rowSelecting the row
  2. Click the Insert command on the Home tab.
    Selecting the Insert Cells commandSelecting the Insert Cells command
  3. The new row appears in your worksheet.
    The inserted rowThe inserted row
When inserting new rows, columns, or cells, you will see the Insert Options button Cursor by the inserted cells. This button allows you to choose how Excel formats them. By default, Excel formats inserted rows with the same formatting as the cells in the row above them. To access more options, hover your mouse over the Insert Options button and click on the drop-down arrow that appears.
Accessing Insert OptionsAccessing Insert Options

To Insert Columns:

  1. Select the column to the right of where you want the new column to appear. For example, if you want to insert a column between A and B, select column B.
    Selecting the columnSelecting the column
  2. Click the Insert command on the Home tab.
    Selecting the Insert Cells commandSelecting the Insert Cells command
  3. The new column appears in your worksheet.
    The inserted columnThe inserted column
By default, Excel formats inserted columns with the same formatting as the column to the left of them. To access more options, hover your mouse over the Insert Options button and click on the drop-down arrow that appears.
Accessing Insert OptionsAccessing Insert Options
When inserting rows and columns, make sure you select the row or column by clicking on its heading so that all the cells in that row or column are selected. If you select just a cell in the row or column then only a new cell will be inserted.

To Delete Rows:

  1. Select the rows you want to delete.
    Selecting the rowsSelecting the rows
  2. Click the Delete command on the Home tab.
    Selecting the Delete commandSelecting the Delete command
  3. The rows are deleted from your worksheet.
    The rows are deletedThe rows are deleted

To Delete Columns:

  1. Select the columns you want to delete.
    Selecting the columnsSelecting the columns
  2. Click the Delete command on the Home tab.
    Selecting the Delete commandSelecting the Delete command
  3. The columns are deleted from your worksheet.
    The columns are deletedThe columns are deleted

    Wrapping Text and Merging Cells

    If a cell contains more text than can be displayed, you can choose to wrap the text within the cell or merge the cell with empty, adjoining cells. Wrap text to make it display on multiple lines of the cell. Merge cells to combine adjoining cells into one larger cell.

    To Wrap Text:

    1. Select the cells with text you want to wrap.
      Selecting cells to wrapSelecting cells
    2. Select the Wrap Text command on the Home tab.
      Selecting the Wrap Text commandSelecting the Wrap Text command
    3. The text in the selected cells will be wrapped in your worksheet.
      Cells with wrapped textCells with wrapped text
    If you change your mind, re-click the Wrap Text command to unwrap the text.

    To Merge Cells Using the Merge & Center Command:

    1. Select the cells you want to merge together.
      Selecting A1:D1 (A1, B1, C1, D1)Selecting A1:D1 (A1, B1, C1, D1)
    2. Select the Merge & Center command on the Home tab.
      Selecting the Merge & Center commandSelecting the Merge & Center command
    3. The selected cells will be merged and the text will be centered.
      A1 after merging with A1:I1A1 after merging with B1:D1
    If you change your mind, re-click the Merge & Center command to unmerge the cells.

    To Access More Merge Options:

    Click the drop-down arrow next to the Merge & Center command on the Home tab. The merge drop-down menu appears.
    • Merge & Center: Merges selected cells into one cell and centers the text.
    • Merge Across: Merges each row of selected cells into larger cells. This command is useful if you are merging content across multiple rows of cells and do not want to create one large cell.
    • Merge Cells: Merges selected cells into one cell.
    • Unmerge Cells: Unmerges the selected cells.
    Accessing more Merge optionsAccessing more Merge options

0 comments |

Labels

Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2