Tip & How-To about Computers & Internet

Deleting Rows & Columns from the table

You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.

  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
OR
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

Posted by on

Computers & Internet Logo

Related Topics:

Related Questions:

2 Answers

how to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    DataTable to DataColumn


    private void PrintValues(DataTable table) { foreach(DataRow row in table.Rows) { foreach(DataColumn column in table.Columns) { Console.WriteLine(row[column]); } } }

    Jan 16, 2009 | Microsoft Visual Studio 2005 Professional...

    1 Answer

    Deleting rows with odd row numbers in one go


    Hi,
    I have found ASAP-Utilities to be excellent for this.

    http://www.asap-utilities.com

    After you download (free) and install, then in the ASAP menu, go to Columns/Rows, and select the first item ("Conditional Row and Column, select, hide or delete"). The options are clear.



    Thanks
    Proton

    Sep 13, 2008 | Microsoft Computers & Internet

    1 Answer

    about formula


    One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.

    If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.

    Hope that helps.

    Aug 08, 2008 | Microsoft Computers & Internet

    1 Answer

    Flex Grid


    The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
    To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
    lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
    lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
    lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
    lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
    Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


    Private Sub Form_Load()
    Call SizeCells
    Call CenterCells



    grdGrid.Row = 0
    grdGrid.Col = 1
    grdGrid.Text = "Single Sided; Low Density "
    grdGrid.Col = 2
    grdGrid.Text = "Double Sided; Low Density"
    grdGrid.Col = 3
    grdGrid.Text = "Singled Sided; High Density"
    grdGrid.Col = 4
    grdGrid.Text = "Double Sided; High Density"

    grdGrid.Row = 1
    grdGrid.Col = 0
    grdGrid.Text = "3 1/2 inch"
    grdGrid.Col = 1
    grdGrid.Text = "$2.30"
    grdGrid.Col = 2
    grdGrid.Text = "$2.75"
    grdGrid.Col = 3
    grdGrid.Text = "$3.20"
    grdGrid.Col = 4
    grdGrid.Text = "$3.50"



    grdGrid.Row = 2
    grdGrid.Col = 0
    grdGrid.Text = "5 1/4 inch"
    grdGrid.Col = 1
    grdGrid.Text = "$1.75"
    grdGrid.Col = 2
    grdGrid.Text = "$2.10"
    grdGrid.Col = 3
    grdGrid.Text = "$2.60"
    grdGrid.Col = 4
    grdGrid.Text = "$2.95"

    End Sub
    Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


    Private Sub SizeCells()
    Dim intColumn As Integer

    grdGrid.ColWidth(0) = 1100

    For intColumn = 1 To 4
    grdGrid.ColWidth(intColumn) = 2200
    Next intColumn

    End Sub

    Private Sub CenterCells()
    Dim intColumn As Integer

    For intColumn = 1 To 4
    grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
    Next intColumn

    End Sub

    Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
    Here is the final result:
    lesson97-7.jpg

    Mar 26, 2008 | Computers & Internet

    Not finding what you are looking for?

    141 people viewed this tip

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Doctor PC
    Doctor PC

    Level 3 Expert

    7733 Answers

    kakima

    Level 3 Expert

    102366 Answers

    David Payne
    David Payne

    Level 3 Expert

    14161 Answers

    Are you a Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Loading...