cell

Even though most of you know how to format text in a Word document, MS Word allows you to handle text in tables in two neat ways. First, within the cell of a table, you can specify not only whether you want text left aligned, centered, right ... aligned, or justified. You can also have text centered vertically within the cell or rest on the bottom edge of the cell. You can even rotate the text in a cell to vertical, like a title on the spine of a book! You will want to use the alignment feature often with your tables. For example, when the content of one cell is short and the adjacent cell is ... (view more)

You know how to use Tabs in MS Word, but more often you will use tables to align text horizontally. Tables are used whenever you must keep items side by side. You do this by laying out a grid. The best thing about tables is that in the grid you can ... align any amount of text -- sentences, paragraphs or even pictures -- side by side. When you want to keep text side by side in a document, create a table. This grid-like structure can contain short text, such as a number, long text, a sentence, paragraph, or several paragraphs. A table keeps the items properly aligned in columns and rows, so you ... (view more)

Credit card numbers. Bank passwords. Business secrets. Proof of adultery. If you give away your cell phone, you may be giving away all of those things -- and more. In the case of a married man who was cheating around, deleting the information on his ... cell wasn't enough to completely eliminate the sordid secrets he had stored there -- even though he did exactly as the manual instructed. Despite that, the guy he sold his phone to on Ebay was quickly able to scoop out the hanky panky. This reads like a bad, cheesy soap opera -- but it's real. And it could happen to you. Even if you aren't ... (view more)

There are several different methods of entering time into a cell. Take a look below to see them. After you've read all about it, open MS Excel and take them for a test drive. I find that if I use a function I'm more likely to remember it the next ... time I need it. To enter the current time into a cell you can use a keyboard shortcut: Select a cell and press CTRL + Shift + ; To enter the current time into a cell by using a formula that returns the current date and time: Enter the formula: =NOW () To get a formula that calculates the current time, change the format of the cell containing the NOW ... (view more)

After you enter text, numbers or a formula into a cell, you may need to change it. You can always retype the entry, if it's short. If it's long, you can easily edit it instead. One way to do this is to click in the formula bar and make changes. When ... the mouse pointer is over the formula bar, it appears as an I-beam, which looks like a capital I. This makes it easy for you to click between letters to place the insertion point where you want to begin making corrections. Sometimes it's easier to make a minor change to the contents of a cell rather than start over from scratch. You can edit the ... (view more)

You can create a budget in MS Excel and track your expenses. To make your budget more readable, you must format it, or change its appearance. To do this, you can click buttons on the Formatting toolbar. If you've used Word or PowerPoint, several of ... these buttons are already familiar to you. You can: Widen columns so that all the text appears. Add dollar signs to help the reader know you are talking about money, and add commas to make it easy to read numbers over 1,000. Make some headings stand out by making them bold or italic, and separate numbers from the total by underlining. The ... (view more)

Cells in an Excel worksheet can contain five kinds of entries; each one is handled a little differently. For example: Text is any word or combination of letters and numbers. Text is automatically left-aligned in the cell. The text too long for the ... cell overlaps any blank cells to the right. Numbers, such as 2,340 or 82%, form the basis for all your calculations. They're automatically right-aligned in the cell to keep the columns of numbers lined up. Dates and times are curious types of numbers. Although they may contain words, such as January and PM, Excel knows what you mean and changes them ... (view more)

When entering numbers in Excel you can type the numbers into a cell by using the keys on the top row of the keyboard or, if Num Lock is turned on, by using the keypad on the right side of the keyboard. To do so, follow the steps below: Type the ... numbers in the cell and press Enter. If you type decimals, such as 1.5000, Excel often eliminates the trailing zeros and displays 1.5. Note that another future article will tell you how to control this. You can also type dollar signs, commas, or percent signs, and Excel displays them with the numbers. Even when you type these symbols, Excel interprets ... (view more)

Need a way to grab attention to a headline? Try accentuating your words using a Table Border in MS word! To do so: Click View | Toolbars, and ensure that 'Tables and Borders' has a checkmark. Using the Tables and Borders toolbar, click the 'Insert ... Table' icon and create a 1 x 1 (single-cell) table. When the table is displayed, right-click over top of the cell and choose the option 'Borders And Shading'. Under the Preview heading, deselect the left, right, and top sides of the cell's border. Under the Style heading, navigate to the Width pull-down menu and choose a heavy line style (such as 4 ... (view more)