column

Tue
16
Jun
Dennis Faas's picture

Add a Smart Column in MS Excel 2007

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)

Tue
10
Feb
Dennis Faas's picture

Copy Hundreds of Rows of Formulas in MS Excel

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)

Thu
15
Jan
Dennis Faas's picture

Hiding a Row or Column in MS Excel

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)

Wed
12
Dec
Dennis Faas's picture

Consecutively Number Table Rows in MS Word

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)

Wed
07
Mar
Dennis Faas's picture

Sorting Data: MS Excel

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)

Thu
26
Oct
Dennis Faas's picture

Sort Rows in a Table: MS Word

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)

Wed
25
Oct
Dennis Faas's picture

Manage Text in a Table: MS Word

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)

Tue
24
Oct
Dennis Faas's picture

Manage Numeric Data in Tables: MS Word

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)

Thu
05
Oct
Dennis Faas's picture

Insert Rows and Columns in Tables: MS Word

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)

Wed
27
Sep
Dennis Faas's picture

Changing Table Structure: MS Word

Once you've begun a table, you can easily change its structure. You can change the width of the columns to fit the text, and you can also insert, delete and rearrange the rows and columns any way you like. Even though you established the overall ... table structure when you first created it, you may find that more or fewer columns or rows are needed after you start entering text. It would be a real pain if you had to delete the table and start all over again just because you needed to rearrange or restructure. Luckily, Word gives you great flexibility in modifying the table structure. Change ... (view more)

Pages

Subscribe to RSS - column