Create a Worksheet

Create Excel Worksheet When you fire up Excel, it opens a fresh workbook file. If you've already got Excel open and you want to create another workbook, just select Office button > New. This step pops up the New Workbook window as showing in image below.

 

The New Workbook window lets you create a new, blank workbook or a ready-made workbook from a template.

Adding the Column Headings

The most straightforward way to create a worksheet is to design it as a table with headings for each column. For example, in a worksheet that stores a mailing list, you could have two columns: one for names and another for addresses. But if you create more than two columns, your life will probably be easier since you can separate first names from street addresses from Zip codes, and so on.

If you enter the first and last names together in one column, Excel can sort only by the first names. And if you clump the addresses and Zip codes together, you give Excel no way to count how many people live in a certain town or neighborhood because Excel can't extract the Zip codes.

The benefits of a six-column table are: it lets you sort your list according to people's last names or where they live. It also allows you to filter out individual information when you start using functions.

The first step in creating your worksheet is to add your headings in the row of cells at the top of the worksheet. Adding information is easy just click the cell you want and start typing. When you're finished, hit Tab to complete your entry and move to the next cell to the right or Enter to head to the cell just underneath.

For a simple expense worksheet designed to keep a record of your most prudent and extravagant purchases, try these headings: 1. Date Purchased stores the date when you spent the money, 2. item stores the name of the product that you bought and 3. price records how much it cost. As showing in figure below:

The standard width of an Excel column is 8.43 characters, which hardly allows you to get a word in edge wise. To solve this problem, position your mouse on the right border of the column header you want to expand so that the mouse pointer changes to the resize icon. Now drag the column border to the right, as you drag a tooltip appears, telling you the character size and pixel width of the column.

Adding Data

Now begin adding your data, simply fill in the rows under the column titles. Each row in the worksheet represents a separate purchase (or record ). As the first column is for dates, the second column is for text, and the third column holds numbers (price). Excel doesn't impose any rules on what you type, so you're free to put text in the Price column. But if you don't keep a consistent kind of data in each column, you won't be able to easily analyze and understand your information later.

Data Editing

Every time you start typing in a cell, Excel erases any existing content in that cell. If you want to edit cell data instead of replacing it, you need to put the cell in edit mode.
Move to the cell you want to edit, you can use the mouse or the arrow keys to get to the correct cell. Put the cell in edit mode by pressing F2 or you can also get a cell into edit mode by double-clicking it. Edit mode looks almost the same as ordinary text entry mode. The only difference is that you can use the arrow keys to move through the text you're typing and make changes. When you aren't in edit mode, pressing these keys just moves you to another cell.

Once you've modified the cell content, press Enter to commit your change or Esc to cancel your edit and leave the old value in the cell. Alternatively, you can turn off edit mode by pressing F2 again, and then move to a new cell. As long as you stay in edit mode, Excel won't let you move to another cell.

Text Wrapping

Overlapping cells can create big headaches. For example, if you type a large amount of text into A1, and then you type some text into B1, you see only part of the data in A1 on your worksheet. The rest is hidden from view. But if, A3 contains a large amount of text and B3 is empty, the content in A3 is displayed over both columns, and you don't have a problem. One way to fix this problem is to manually resize the column, as described earlier. Another option is to use wrapping to fit multiple lines of text in a single cell.

Wrap text automatically in a cell

In a worksheet, select the cells that you want to format, on the Home tab, in the Alignment group, click Wrap Text.
Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.
Note: If you set the height and data is larger than height then you can not see the whole data.