Wednesday, February 13, 2013

How to Do Multicolor Column Charts in Excel 2010

1. Open the Excel worksheet that contains the data for the column chart.2. Click and drag to select the categories and data values for the column chart.3. Click the “Insert” tab on the command ribbon.4. Click the arrow for the “Column” chart in the “Charts” group.5. Click the preferred column chart to add a chart representing the selected worksheet data.6. Click in the chart area to display the Chart Tools ribbon.7. Click the “Format” tab in the Chart Tools ribbon.8. Click one column in the plot area. All the columns will appear highlighted.9. Click the same column once again....
Read more ►

How to Compare Columns With VBA

1. Click the 'Developer' tab in Excel, and then click 'Visual Basic.'2. Click 'Insert.' Click 'Module' to open a new module window.3. Cut and paste the following code into the window:Sub CompareColumns()Dim Column1 As RangeDim Column2 As Range'Prompt user for the first column range to compare...'----------------------------------------------------Set Column1 = Application.InputBox('Select First Column to Compare', Type:=8)'Check that the range they have provided consists of only 1 column...If Column1.Columns.Count > 1 ThenDo Until Column1.Columns.Count = 1MsgBox 'You can only select 1...
Read more ►

How to Unlock Excel 2007 Password Protection

Unlock Document Password1. Open the Excel file in Excel 2007. You will need to enter the correct password to open the file.2. Click on the Microsoft Office Button, located in the upper right corner of the Excel 2007 program. Move your mouse over 'Prepare' on the left hand side of the window. Choose 'Encrypt Document' from the list of options on the right.3. Place your cursor to the right of the password in the box. Use the backspace key to erase the password. Click 'OK' when you are done. The Excel 2007 document is no longer password protected.Unlock Worksheet Password4. Open the Excel...
Read more ►

How to Change the Color Scheme in an Excel Chart

Change Chart Colors in Excel 20071. Open the spreadsheet containing the chart you want to edit.2. Single-click the chart once to select it.3. Single-click the individual piece of the chart you want to change to select the piece.4. Right-click the selected piece and choose the 'Format Data Point' option.5. Click 'Fill' in the left-hand menu, and then choose the fill option that meets your design needs. Select your desired color, gradient, picture or texture and the selected chart shape is updated immediately. Click 'Close' to close the Format Data point window.Change Chart Colors in Excel...
Read more ►

Tuesday, February 12, 2013

How to Remove Security From an Excel Spreadsheet

1. Open the Excel spreadsheet and enter your password.2. Click the 'Review' tab on the Excel toolbar.3. Click the 'Unprotect Sheet' button to remove security from the spreadsheet. Make sure you do not click 'Unprotect Workbook' unless you want to remove security from the entire workbook.4. Enter the password for the spreadsheet if prompted and click 'O...
Read more ►

How to Create a Distribution List to Import Into Outlook 2007

1. Open a blank Excel worksheet. Enter 'First Name' into cell A1. Enter 'Last Name' into cell B1. Enter 'Email Address' into cell C1.2. Enter the first name of the first person you want to add to the distribution list into cell A2. Enter that person's last name and email address into B2 and C2. Enter the names and email addresses of all of the contacts you want to add to the distribution list into the cells in the appropriate columns.3. Click the 'File' tab in Excel 2010. Click 'Save As.' Enter a name for the file, such as 'Distribution List,' into the File Name field. Change the 'Save as...
Read more ►

How to Split a Cell Diagonally

Microsoft Word1. Click anywhere within the table to make the 'Design' tab visible in Microsoft Word.2. Click the 'Design' tab under 'Table Tools.'3. Go to the 'Draw Borders' group and select 'Draw Table.'4. Place your cursor at the top corner of the cell you want to split.5. Click, hold and drag your mouse from the top, right corner of the cell to the opposite corner to split it diagonally.6. Click the 'Draw Table' button to deactivate the 'Draw Table' option.Microsoft Excel or PowerPoint7. Click the 'Insert' tab in Microsoft Excel.8. Go to the 'Illustrations' group and click 'Shapes'...
Read more ►

How to Add a Second Y

1. Create an Excel graph for all the rows and columns. At the end of this step you will have a graph with some very high lines and the rest flat along the bottom.2. Select one of the lines which are causing the skewing of the graph. If more than one line is the culprit, select the highest.3. With the lines selected, right click on the graph and select 'Format Data Series.' This will open another box. In the new box, select 'Secondary Axis.' Then click the Close button.4. Your graph will now display the second Y-axis on the right of the graph and your lines will be spaced o...
Read more ►

How to Disable Cell Drag in Excel

1. Open Excel and click the 'File' menu tab in the top-left corner of the screen.2. Click 'Options' on the bottom-left of the menu to open the Excel Options window.3. Click 'Advanced' in the left window pane.4. Click the box next to 'Enable Fill Handle and Cell Drag-and-Drop' to clear the check mark.5. Click 'OK' to close the window and save the chang...
Read more ►

How to Move Data on an Excel 2007 Worksheet

1. Open the worksheet you want to change. Find the document in your saved documents and select it--double click twice on it. The worksheet will then open in Excel.2. Decide what actions you want to do. For example, you may have made a file that is your address book. When you first put the file together, you put in columns in the following order: first name, last name, phone number, address, city, state and zip code. You now see that it would be easier if you had arranged the data this way: last name, first name, address, city, state, zip code and phone number.3. Add a column. Put your cursor...
Read more ►

Monday, February 11, 2013

How to Retrieve Values From Another Excel 2007 Workbook

1. Determine the location of the workbook you want to retrieve values from. For example, the workbook might be in the same directory as the one you want to display the values in, and it might be named 'other_workbook.xlsx.'2. Find the the row and column of the value you want to bring in from the other workbook. For example, you may be looking for a 'total' that is sitting in cell G4 on Sheet1 in other_workbook.xlsx.3. Type the following formula into the cell you want to display the value from the other workbook on:=[other_workbook.xlsx]Sheet1!A14. Change 'A1' in the formula from Step 3...
Read more ►

How to Extract Pivot Table Data

1. Type the '=' sign, without the quotes, into an empty cell.2. Click on a cell in the pivot table. A formula will appear next to the equal sign.3. Press the 'Enter' key. The cell will now display the data from the Pivot tab...
Read more ►

How to Wrap Text in a Cell

1. Highlight the cells you want the text to be wrapped in. Use your computer's mouse to left-click in the first cell you wish to select and continue to drag it over the desired cells. Release it when the cells are highlighted.2. Click on 'Format' in the Excel task-bar or right-click on the cell block you have highlighted.3. Click on 'Format Cells' and a pop-up window will appear.4. Click on the 'Alignment' tab and check the 'Wrap Text' box on the left-hand side.5. Click 'OK' to close the 'Format Cells' pop-up window. The highlighted cells should now wrap when you resize your cell ...
Read more ►

Monday, January 28, 2013

How to Set 'Do Not Print Cell' in Excel

Hiding blocks of cells1. Launch Microsoft Excel by pressing your 'Start' button and selecting the application from your list of available programs, or click on the icon if you have one saved on your desktop. Open an existing file that contains data rather than a blank worksheet. Create a backup file if necessary to protect yourself from inadvertently deleting data on the spreadsheet.2. Highlight a row, column or specific cells in your spreadsheet. To select an entire row or column, point to the row or column headings (numbers for rows and letters for columns) until the regular mouse pointer...
Read more ►

How to Create Maps in Excel 2007

1. Create your data in an Excel spreadsheet. For example, if you want to map sales figures by zip code, you could put the sales data in one column and zip codes in another. In a third column, write the name of the city that corresponds with the zip code. For example:$50,000_32206_Jacksonville, FL$43,000_12801_Glen's Falls, NY$19,000_80537_Loveland, CO2. Select the data that you would like to include in the map. Highlight the data by holding down the left mouse key while you mouse over the area. When the data is selected, hit CTRL C to copy the data.3. Open a blank map in MapPoint. Paste...
Read more ►

Blogger news