You probably already know how to sort a vertical list in Excel (and here's a refresher if you don't), but what can you do if you want to put your column headings in alphabetical or chronological order? Can you sort your data from left to right?Sort Top to BottomTo quickly sort a column of data from top to bottom, you can click anywhere in the column and then click the A-Z button on the standard toolbar (or click Z-A if you want to sort backwards). The column will be sorted in alphabetical or chronological order.

You may try to enter September 22, 2000 as 9/22/00, but Excel has other ideas about how the date should be displayed. Whether you prefer the style of 22.9.00, 9/22/2000, 9-22, or something completely different, you can leave specific instructions for how your dates should appear.The style that Excel uses to display your date is actually controlled outside of Excel, in the Windows Control Panel.

Is your formula your private property? Are there times when you provide spreadsheets for others to view but you don't want to display the underlying calculations? Once you've created a worksheet and performed all the calculations, you can switch the calculations to the calculated values so only the final numbers appear, both in the work area of spreadsheet and in the formula bar at the top of the spreadsheet.Change the contents of a cell or group of adjacent cells from formula to value by following these steps:1.

Manipulating multiple worksheets is made easy with our latest pivot table tutorial from pivot king David Carter.His latest guide - Consolidating multiple worksheets in a Pivot Table - to this invaluable Excel tool should take only 15 minutes, and shows you how to take a number of worksheets and turn them into one comprehensive spreadsheet.Carter's new tutorial comes in response to a question from AccountingWEB reader Tom Trainer, who wanted to know if pivot tables could be used to

For those of you who have an interest in working with multiple spreadsheets within a single Excel file, here's a quick tip for manipulating numbers in a situation where you have several sheets of identical format, but with different numbers. Say you have 12 active sheets, with sheet 1 as the summary sheet and sheets 2-11 providing the detail, and you want to add the contents of Cell D5 from sheets 2-11 and place the sum in cell D5 of sheet 1. Step 1: Place your cellpointer in cell D5 of sheet 1 and initiate the formula by clicking the AutoSum button on the standard toolbar.

How many times have you entered a list of names, first and last name in the same column, like this:Joe SmithMargaret HowardSherry AndersonMichael WilsonMeredith Morganand so on……only to find that you need to alphabetize the list by last name. Do you have to re-enter the entire list so that the last name appears first? Here's a quick method for sorting a list like the one above by last name.The process involves separating the text into two columns, one for the first name and one for the last name.

Set up your various print ranges first by using your mouse to select a range, then assign a name to the range. Assign a range name by choosing Insert, Name, Define from the menu. In the Names in workbook field, enter the name you want to use to identify this selected range. You cannot use spaces in your range name. Click OK to complete the process. Assign other named ranges in your worksheet in the same manner.

This is one in a series of Excel Pivot Table Tutorials developed by AccountingWEB software consultant David Carter.

This is one in a series of Excel Pivot Table Tutorials developed by AccountingWEB software consultant David Carter.