column

Adding a new column to an MS Excel table is as easy as falling off a log! Follow the steps below: Place a formula, such as SUM, in the first cell of a new data column. That formula is then automatically applied to all the cells in that column, which ... can also be sorted and filtered. Add another column and use a different formula, such as AVERAGE, to create a column that leaves out the SUM totals you already added. Very simple isn't it? When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today! (view more)

There are a number of way in which you can copy formulas in MS Excel. You can use the Autofill feature or select the cells you want to copy to, enter the formula in the active cell and press Ctrl + Enter. These methods work very well for you in ... Excel unless you have hundreds of rows that you would like to copy. Let's say you have 100 classes listed in Column A of your spreadsheet and Column B lists the in-state tuition price of each class. Wouldn't it be nice to enter a formula that calculates the price for each class and displays the results in Column C? The practice of selecting hundreds of ... (view more)

There may be occasions when you want to omit a column or row of data from a printed copy of your spreadsheet, but still have the rest of your spreadsheet in your favorite format. Follow the steps below to learn how to hide a row or column: Select ... the column or row you would like to hide. Click Format | Column | Hide. To hide a row, click Format | Row | Hide. Follow the steps below to unhide rows or columns: Select the columns or rows you on either side of the hidden column. Click on Format | Column | Unhide to unhide the column. To unhide a row, click on Format | Row | Unhide. The column or ... (view more)

There may be times when you will want to have numbering in your table. Sometimes the numbering is an important part of your table and other times it is useful in identifying and referencing certain rows. Luckily, this is very easy to accomplish in ... all versions of MS Word from version 2000 forward. Follow the steps below to learn how to insert consecutive numbers in your table rows: Launch MS Word if it is not already open. Create a table with five rows and five columns by doing the following: Click on Table | Insert | Table | 5 rows | 5 columns. Position your cursor above the first column ... (view more)

Sorting data refers to organizing the records in a data list so that they are presented in a certain order. If data is arranged in a list structure, data can be automatically sorted by choosing one individual cell within the list to define the sort ... criteria. All corresponding data will be repositioned on sort order. The Sort Ascending and Sort Descending button on the Standard toolbar can be used to quickly sort a list by one column. Follow the steps below to sort by one column: Select one cell anywhere within the field (column) upon which the sort will be based. Click on the Sort Ascending ... (view more)

You can sort a table in either ascending or descending order. You don't have to select the table before you sort -- the entire table is automatically reordered when you use either of these methods. Click a toolbar button: Place the insertion point I ... n the column you want to sort. Click the Sort Ascending or Sort Descending button on the Tables and Borders toolbar to sort the data in ascending (A-Z, 0-9) or descending (Z-A, 9-0) order. Use the Sort dialog box: To sort more than one column, such as when you want to alphabetize by last name and then by first name, follow the steps below: Choose ... (view more)

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)

Tables are often used to convey sets of numbers, whether times, dates, dollars, or quantities. Even with Table AutoFormat in MS Word, displaying numbers properly is not always easy. For example, you have to be sure to align a column of numbers on ... their decimal points. You may want to sort items in ascending (A-Z, 0-9) or descending order (A-A, 9-0). Also, if you have numbers totaled, you want to be sure to display the correct total, even if you change the figures. Numbers often give the heart of the message in a concise, exact way. Using tables to display figures is a good idea, because the ... (view more)

You've already learned how to add a new row to the bottom of a table by pressing Tab from the bottom-right cell in a table [refer to this article ]. You can also insert rows and columns between existing ones, using the methods below. Choose Table | ... Insert and specify where to insert the new row or column. The menu has a number of choices. To insert a row, first select the row that will move down to make room for the new row. (One way to do this is to move the mouse pointer to the far-left side of the table and click once.) Then click the Insert Row button that appears where the Insert button ... (view more)