Use a Tabular Format in Excel

Sponsored ADS  

  • Step 1

    Open Microsoft Excel. The program always be enumerated in the "Programs" line of the "Start" menu. A bond to the software may too appear on the Windows desktop.

  • Step 2

    Type a column Heading into the initially cell of the initially row. This is cell "A1." For example, if your assessment will to contain information about people, you could type "Name" in this cell.

  • Step 3

    Type the afterwards column Heading into the in the second place cell of the initially row, cell "B1." For example, this cell may to contain the Heading "Phone Number" if you to want to to include this data in your spreadsheet.

  • Step 4

    Type additional column Headings as wished in any of the to remain columns of row 1. You may, for example, type "Street Address" in cell "C1," "City" in cell "D1" and "Zip" in cell "E1."

  • Step 5

    Type the initially record of your data to start in row 2. In cell "A2," for example, you could type an individual's name if that column Heading says "Name."

  • Step 6

    Type the additional fields structured by the tabular format in row 2, use the column Headings as a guide. Once you to have entered data under all the Headings for column 2, this disc is complete.

  • Step 7

    Add others record of data in row 3. This is the in the second place record. Type data in the cells that to correspond to the column headers, in the exact Mode as entered for row 2.

  • Step 8

    Right-click on any column letter if you the need to insertion new columns as needed. The column letters are the letters above row 1, and they beginning with "A" and movement to the right-hand side alphabetically. Right-click any of those and a pop-up menu appear. chosen the "Insert" option and a new column appears. You may then type the new column Heading into the row 1 of the new column.

  • Step 9

    Right-click any column letter and to choose "delete" if you to want to in a permanent way delete that column.

  • Step 10

    Right-click any column letter and to choose "hide" if that column is required but you wish not to see it. This is a useful device of the Excel tabular format. Sometimes data need be maintained and not deleted, but the presence of the column is not necessary when really viewing the data majority of the time.


  • Sponsored ADS
     

    Make a CUE File With Nero | Delete the Ask Jeeves Toolbar | Create a Slide Show in Windows | Make a Screenshot of a Webpage | Convert iTunes Movies to Windows Media Player | Uninstall All Versions of SpySweeper | Reset Microsoft Digital Rights Management Software | Draw a Graffiti Skyscraper | Install Java for a Linux Bin | Create a Uml Class Diagram Using MS WordReinstall Java | Convert Microsoft Files to PDF | Compare MP3 to WMA | Erase My Hard Drive Clean | Convert WMA Files to MP3 in Windows Media Player | Create a Workbook With Embedded Macros | Use Photoshop CS2 With YouTube | Run an AOL Computer Checkup | Create a Google gmail account | Update Virus amp; Spyware Definitions | Delete Microsoft FrontPage | Configure Wireless Adapter Settings on Netgear | Make a Concert Photo Poster | Convert an ODS File to an XLS | Copy a DVD to an SD Card for a Mix Max Player