How to Sort Columns in Excel 2007

1. Open your spreadsheet file in Microsoft Excel.
2. Press 'Ctrl' and 'A' to select all the columns in your spreadsheet.
3. Click 'Sort Filter' near the right side of the ribbon.
4. Choose 'Custom Sort.'
5. Select the first column you want to sort on, such as Column A, in the first drop-down box.
6. Select the criterion on which you want to sort this column, such as the value of the cell or the cell color, in the second drop-down box.
7. Select your desired sort order, such as A-to-Z or smallest-to-largest, in the third drop-down box.
8. Click the 'Add Level' button if you want to sort by additional criteria.
9. Check 'My Data Has Headers' if your spreadsheet has a header row. If you check this box, Excel will leave the header row as the very top row. Otherwise it would sort your column headings as though they were data.
10. Click 'OK.' Your Excel spreadsheet is now sorted by columns according to the criteria you set.

Read more ►

How to Make a Double Bar Graph on Microsoft Excel

1. Open a new Excel 2010 document.
2. Enter the names of the items you want on your double bar chart, starting in cell B1 and continuing to the right of that cell. These headers will become the labels printed at the base of each of the bar sets on the graph.
3. Type the names of the two categories that the double bar graph will track into cells A2 and A3. These labels will be located to the right of the bar graph. Each of these two categories will be assigned a color bar, which will appear next to each of the items on the graph.
4. Input your numerical data into the cells, starting with cell B2 and continuing down and to the right. When you're done entering information, select cell A1 and hold down the mouse button. Move the mouse to the bottom-right cell and release the button.
5. Select the 'Insert' tab at the top of the screen. Click the 'Bar' button located in the 'Charts' area of the ribbon. Choose any of the 'Clustered' bar chart options, as opposed to the 'Stacked' options. Your double bar chart will appear on the spreadsheet.

Read more ►

How to Create a Frequency Table in Excel Using Pivot Tables

1. Highlight the cells containing the data, if you’re starting the pivot table from scratch.
2. Open the Data drop-down menu and select “PivotTable Report…”. A new frame will open. Click the two “Next” buttons that you see. Click “Existing Worksheet” and select a cell to be the upper-left corner of your pivot table.
3. Click “Layout.” A new panel will open. Drag the field name to the square center of the table that you want to know the frequency of. Double-click it and select “Count.” Drag the same field from the far right into the left column where the row labels go. Click “OK” and then click “Finish.” You will be sent back to the Excel spreadsheet, which will now have a pivot table starting in the cell where you requested it be created.
4. Group continuous data by right-clicking your mouse on the column with the field labels. (An example of continuous data is 'revenue,' while an example of discrete or nominal data is “highest degree achieved.”) Select “Group and Outline” in the menu that pops up and then select “Group.” The range of data will be displayed for you. Select the interval width you want the data grouped into, and enter it in the “By:” field. Select “OK.” The table will now collapse into a more-compressed form and the frequencies listed will go up as data points are added together. If an interval width has no data in it, it won’t be given a row in the table.

Read more ►

How to Change the Text Box Size in Excel 2003

Inserting a Text Box
1. Click on 'View' on the main toolbar, then 'Toolbars' and ensure there is a check mark next to the 'Drawing' toolbar.
2. Locate the 'Drawing' toolbar on your screen.
3. Click on either the 'Text Box' or 'Vertical Text Box' commands on the 'Drawing' toolbar. Your cursor changes to the 'Text Box' tool.
4. Click and drag your mouse to create a text box.
Resizing a Text Box
5. Locate the text box that you wish to resize, then click anywhere in the text box to select it.
6. Change the width of the text box by clicking and dragging from the central anchor point on either side of the text box.
7. Click and drag from the central anchor point on the top or bottom of the text box to change the height of the text box.
8. Change the width and height of the text box simultaneously by clicking and dragging from any of the text box's corner anchor points.

Read more ►

How to Format an 'If Statement' in Excel for a Blank or Filled Reference

1. Open the Microsoft Excel 2010 worksheet. Press 'Alt F11' to open the VBA console.
2. Select a module from the list on the left side. If no module exists, right-click on a worksheet in the list, move the mouse pointer over 'Insert' and choose 'Module.' Select the module that appears.
3. Type 'sub testing()' into the first line of the module and press 'Enter.' Change 'testing' to whatever word you want as it is simply the name of the subroutine. Excel VBA automatically adds the 'End Sub' command to the last row of the module.
4. Type 'Dim x as range' into the next line. This will establish 'x' as a variable, which you will need in the next statement.
5. Type 'For each x in range ('XX:YY')' into the next line. Change 'XX' to the top-left cell in the range you want to work with and 'YY' to the bottom-right cell. This will create a loop that will go through each cell in the range one by one.
6. Type 'If IsEmpty(x) Then XXX Else YYY' into the next line. Change 'XXX' and 'YYY' to whatever code you want to run. The IsEmpty command will check each cell and perform the action after 'Then' if the cell is empty. 'Else,' and the code after it, are optional.
7. Type 'Next' on the next line. This tells Excel to loop back to the 'For' statement and move on to the next cell.

Read more ►

How to Determine an MS Excel File Version

1. Click on the Windows “Start” button then on “Computer” to open Windows Explorer.
2. Browse your computer to find the Excel file.
3. Check the file extension. If it is '.xlsx' then the file was created with Excel 2007. The extension '.xls' indicates older program versions.
4. Right-click on the Excel file and choose “Properties” from the pop-up menu.
5. Select the tab “Details” (in Windows Vista or 7) or “Summary” then “Advanced” (in Windows XP).
6. Read the Excel version in the line “Type,” for example, 'Microsoft Office Excel 2003.'

Read more ►

How Can I See Excel 2003 Commands in Excel 2007?

1. Click the 'Office' button, and select 'Customize Quick Access Toolbar.' This action opens a pop-up window.
2. Select 'All Commands' from the 'Choose' menu. This action displays a list of available Excel commands that can be added to the Quick Access Toolbar.
3. Select a command from Excel 2003 that you want to view independent of the ribbon interface. Click the 'Add' button. Repeat this process for each Excel 2003 command that you want to view in the Quick Access toolbar. Click the 'OK' button when you have finished adding Excel 2003 commands.

Read more ►

How to Remove Hyperlinks in Microsoft Excel 2007

1. Open Excel using the 'Start' menu or another shortcut. You may also type 'Excel' in the Start menu search box and click on the resulting link.
2. Click the 'Open' option and select the spreadsheet you want to work with. Locate the cell containing the link.
3. Right-click the link you want to delete and click the 'Remove Hyperlink' option. Repeat for each link you want to remove.

Read more ►

How to Calculate Percentage Increases in Excel 2007

1. Type 'Beginning Number' in cell A1, and then type your beginning number in cell B1. For example, type '50' in cell B1.
2. Type 'Ending Number' in cell A2, and then type your ending number in cell B2. In the example, type '100' in cell B2.
3. Type 'Percent Increase' in cell A3.
4. Type '=((B2-B1)/B1)' in cell B3. In the example, your result will be 1, or 100%.

Read more ►

How Can I Disable All Double Clicking in Excel 2003?

1. Open the document you wish to disable double-clicking on in Microsoft Excel 2003.
2. Press the 'Alt' key on your keyboard and 'F11' key simultaneously. The VBA editor will appear.
3. Double-click 'Workbook' in the upper left window pane in the VBA editor. A new window will appear.
4. Copy and paste the following code into the new window:Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ByVal Target As Range, ByVal Cancel As Boolean)Cancel = TrueEnd Sub
5. Press 'Alt' and 'F11' simultaneously again to save the code and return to Excel. The string of code disables all double-click actions in the Excel workbook.

Read more ►

How to Create a Stacked Bar Graph in Excel

1. Click 'Start,' then 'All programs,' then 'Microsoft Office,' then 'Microsoft Excel.'
2. Press 'Ctrl' 'O,' then locate and open the Excel document which contains the data to be turned into a stacked bar chart.
3. Highlight the data that you want to create the chart from.
4. Click 'Charts,' then 'Bar,' then 'Stacked Bar.' The stacked bar chart will automatically appear in the worksheet. You have now inserted a stacked bar chart into your Excel document.

Read more ►

How to Allow a Shared Workbook

Microsoft Excel 2003
1. Launch Excel 2003, then open the Excel workbook you want to share with other users on the network.
2. Click the 'Tools' option on the menu bar, then click 'Share Workbook.' Wait for the 'Share Workbook' options dialog window to appear.
3. Click and enable the checkbox next to the label that reads 'Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging.' Click the 'OK' button.
4. Click the 'File' > 'Save' option on the menu bar to save the permission changes to the workbook.
Microsoft Excel 2007 or 2010
5. Open Microsoft Excel, then open the workbook you want to share.
6. Click the 'Review' tab on the 'Office Ribbon,' then click 'Share Workbook.'
7. Click the 'Editing' tab, then enable the checkbox next to 'Allow changes by more than one user at a time. This also allows workbook merging.'
8. Click the 'Advanced' tab, then select options for tracking and updating changes to the shared workbook. Click 'OK.'
9. Save the workbook to save the sharing and permission changes for the file.

Read more ►

How to Keep Track of Changes in Excel 2003

1. Open Excel from the Start menu on your toolbar.
2. Open the file for which you'd like to track changes.
3. Go to Tools > Track Changes.
4. If you want to see the changes while you are editing, select 'Highlight Changes.' Then select the boxes labeled 'Track Changes While Editing' and 'Highlight Changes on Screen.' When making a lot of changes, you might not want this option on because it can be distracting.
5. Decide who gets to make changes on your worksheet. Select the 'Who' tab and choose the users who can make changes. If you choose 'Everyone,' your file will be shared on the network.
6. Select the 'When' option to decide when changes are tracked. The most popular is option is 'All.'
7. Click 'OK' to save your options.

Read more ►

How to Convert XML Files Into an Excel Spreadsheet

1. Open Excel.
2. Click the Microsoft Office symbol in the upper left-hand corner. Select 'Open' from the menu.
3. Find the XML document you want to convert and click 'Open.' If the document does not seem to be present where it should be, you may need to select 'XML Files(*.xml)' from the 'Files of type:' drop-down box.
4. A small dialog box will open titled 'Open XML.' In this box select the radio button titled 'As an XML table,' then click 'OK.'
5. If another dialog pops up that has a message relating to creating a 'XML schema,' simply click 'OK.' The XML file should be opened as a spreadsheet.
6. To complete the conversion, save the spreadsheet as an Excel file by clicking the 'Office' button, then 'Save.'

Read more ►

How to Print Grid Lines in MS Word

Show Gridlines
1. Open the Word document that contains your table or labels.
2. Select 'Table' and 'Show Gridlines' from the toolbar to make gridlines visible. You will see the grid lines on your page.
3. Select 'File' and 'Print Preview' from the toolbar. The grid lines will not be visible.
4. Press the 'Escape' key to return to your page.
Add and Print Borders
5. Select the table or labels containing the grid lines you want to print.
6. Click on 'View,' 'Toolbars' and 'Tables and Borders' in the toolbar to open the 'Tables and Borders' toolbar.
7. Expand the 'Border Color' button by clicking on its arrow. Then select 'Gray-25%' (a color similar to that used in grid lines) for the border color.
8. Expand the 'Border' button by clicking on its arrow. Then select 'All Borders' from the list. A border will be applied to your entire table.
9. Select 'File' and 'Print Preview' from the toolbar. The borders you just applied will now be visible. Press the 'Print' icon on the Print Preview page to print your table or labels with the borders.

Read more ►