row

Ever want to learn how to copy and paste row height in MS Excel? I have had many inquiries regarding this tip and it is such an easy thing to do! Follow the steps below: Select the row you would like to copy. Click on the Format Painter icon on your ... Standard toolbar (or on the Home tab is you are using version 2007). You will now see a small paint brush. Simply drag it where you would like to copy the row height. That's all there is to it! You have now copied the format to your new row. When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles ... (view more)

Ever gotten your table just perfect? Everything is just the way you like it, cell height is perfect and you have text wrap working, every other row is highlighted...then you decide you would like to save it but you have it all full of data! Rest ... easy, this is a no-brainer and can be done with ease!Just select your entire table and depress the Delete key -- that's it! All the text and data is gone and you are left with your perfectly formatted table. Note: Do not use your backspace key as that will delete your entire table. Now that you have that perfect table saved you can use it for any ... (view more)

You can use shortcut keys when evaluating row data in MS Excel. Let's say you had 35 sales during the past year. You list each sale in Row 1, starting in Column B and you list each sales region in Column A. For each sale, you enter the response rate ... for each area. To see which sales had a 75% response rate for the Eastern area, follow the steps below: In the Eastern area row, click on the first cell that contains 75. Press Shift | Space to select the entire row. Press CTRL | \ in a selected row. Excel will select all the cells that did not match the active cell so you can see which sales had ... (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)

You may think you can delete a row or column by selecting it and pressing Delete. But what that does is remove the text, leaving empty cells behind. To remove a row or column completely, you must select it and then choose a menu selection. Choose ... Table | Delete, and then specify Table, Columns, Rows, or certain cells. Right-click and choose Delete from the shortcut menu. If you have a row selected, the shortcut menu will say Delete Row; if you have a column selected, it will say Delete Column. When a column is deleted, the column widths may adjust themselves. The easiest way to delete an ... (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)

When you begin a new workbook, the "active cell" is located at the top-left corner of the worksheet (in Cell A1). To create your worksheet or make changes to it, you must move around in it. Getting around in a worksheet quickly is the mark of an ... experienced Excel user. You want to learn the quickest way to get from place to place so you can use your time more efficiently. Keyboard Shortcuts for Moving Around in a Worksheet You can move around in the worksheet by pressing the arrow keys and other direction keys on the keyboard. When you use the keyboard to move around in the ... (view more)