1. Click the 'Home' tab.2. Click 'Conditional Formatting' in the 'Styles' box in the Office ribbon.3. Select 'Highlight Cell Rules' and then 'Duplicate Values.' The 'Duplicate Values' box will open.4. Select 'Duplicate' from the drop-down box and choose the color for the highlighted duplicates. Click 'OK.' Excel will show all duplicate values in the color that was chos...
Browse » Home » All posts
Friday, July 22, 2011
How to Change the Vertical Axis Numbers on an Excel Bar Chart
Using Chart Tools1. Click on the vertical axis numbers on the chart area. This action opens a selection box.2. Click on the 'Layout' tab under 'Chart Tools.'3. Choose 'Axes->Axes->Primary Vertical Axis->More Primary Vertical Axis Options.' Choose the factor you would like to change. For example, if you want to change the interval between tick marks to 100, write '100' in the top box.4. Press 'Close.' Excel will automatically update the graph with the new numbers.Manual Change5. Click on the number you want to change in the Excel worksheet (not on the graph). For example, if...
How to Align Double
1. Create a new Excel 2007 spreadsheet from the circular 'Office' tab of the Ribbon. Select 'New' and then 'Blank Workbook' to create a new, blank spreadsheet. Save your document as an Excel 2007 file format from the 'Save As' button from the 'Office' tab.2. Switch to 'Page Layout' view from the 'View' tab of the Ribbon. Page Layout view allows you to see the parameters of your print document including margins, column width and row height. It also allows you to view the alignment of your cells to prepare them as tags.3. Right-click the column header and select 'Column Width' to input your...
How to Edit a Picture in Excel
1. Right-click on the 'Start' button in the bottom-left corner of the Windows desktop.2. Select 'All Programs' and then select 'Microsoft Office.'3. Scroll down to the bottom of the Microsoft Office programs choices and select 'Microsoft Office Tools.'4. Scroll down in the tool selection category and select 'Microsoft Office Picture Manager.'5. Click 'Pictures' in the pane on the left side of Microsoft Office Picture Manager.6. Select the picture that is in the Excel spreadsheet.7. Click 'Edit Pictures' in the tool bar of the picture manager and an 'Edit Pictures' pane will open.8....
How to Merge Two Excel Workbooks Into One
1. Save your original file as a shared file. With the workbook open, Under 'Tools' select 'Share Workbook.' Check the 'Allow Changes' box, then click the 'Advanced' option. Input the number of days you'd like to allow track changes for. It's a good idea to set this for several days after you plan to merge the two workbooks or meet with the individual(s) in charge of the other workbooks, in case you need to make additional changes at that time. Click 'OK.' Save when prompted.2. Create a copy of the original workbook. Under 'File' select 'Save As' and give the new workbook a different title....
Thursday, July 21, 2011
How to Update Links in Excel
How to Update Links in Excel1. Open Excel workbook in which you want to update links.2. Select the 'Edit' menu from the menu list.3. Select 'Links' from the drop-down list.4. In the 'Edit Links' pop-up window, select 'Update Value...
Wednesday, July 20, 2011
How to Compare Merge Workbooks That Are Greyed Out
1. Share the workbook that needs to be compared and merged. This can be done by clicking 'Tools' then 'Share Workbook.' This is an initial step that needs to be completed before sending the workbook out to be reviewed.2. Save all workbooks that have changes or additions with unique file names that differ from the original workbook's file name. Also, ensure they are all saved in the same folder as the original workbook before attempting to use the Compare and Merge feature.3. Click the 'Compare and Merge Workbooks' buttons located on the toolbar. When prompted, select the workbooks that you...
Tutorial on Microsoft Excel 2003
1. Click 'Start,' 'All Programs,' 'Microsoft Office,' and then Microsoft Office Excel 2003. Excel 2003 will launch.2. Click on any cell in the worksheet to select it.3. Type numerical data or text in a selected cell and then press 'Enter' to enter information into the cell.4. Click on the 'Sheet' tabs at the bottom of the window to work in different worksheets. Each sheet acts as its own separate workspace within the same Excel workbook.5. Click on a cell, hold down the mouse button and then drag the mouse across the spreadsheet to select a block or range of cells. Selecting ranges of...
Tuesday, July 19, 2011
How to Send a Mass Email From an Excel Spreadsheet
Send a Mass Email from an Excel 2003 Spreadsheet1. Make an Excel spreadsheet containing all of the information you will need for your mass email, such as your contacts' names and email addresses. Enter a heading into the first cell in each column. Save and close the Excel spreadsheet.2. Open Outlook and minimize it. Open Word and type your email, leaving blanks where you want the recipients' names and other personal information to go. This data will come from the Excel spreadsheet you created.3. Go to the 'Tools' menu. Point to 'Letters and Mailings' and select 'Mail Merge.' Under 'Select...
How to Make a Ledger
1. Open Excel by double-clicking the Excel icon on your desktop. If you don't have an Excel icon on your desktop, you can click 'Start' and then 'All Programs,' followed by 'Microsoft Office.' Then select 'Microsoft Excel.'2. Enter 'Entry Date' in the A1 field. Enter 'Account Name' in the B1 field. Enter 'Debit/Credit' in the C1 field. Finally, enter 'Amount' in the D1 field.3. Enter your financial transactions into these four fields to create the general ledger. For example, you purchased office supplies on July 1, 2010, in the amount of $50. For this transaction, you'd enter '7/1/10' in...
How to Write an Excel VBA Program
1. Find the Excel file that you want to augment by including a VBA program. Double-click on the file to open the spreadsheet.2. Hold down Alt and press F11 to open the VBA editor. The editor will open up in a new window.3. Right-click on any of your worksheets, which will be listed in the thin column on the left side of the VBA editor. Move your mouse over 'Insert' and select 'Module.' This will add a new module, which is just something to hold your VBA program, to the list. Double-click on the module that appears, and the right half of the VBA editor will turn white.4. Click on the right...
How to Hide Gridlines in Microsoft Excel 2003
1. Open Excel 2003 and select a workbook to print. Click 'File' on the menu bar and select 'Open.' Browse your files for the workbook. Click the workbook and select the 'Open' button.2. Click 'Tools' on the menu bar once the Excel 2003 workbook opens and select 'Options.'3. Click the 'View' tab once the Options dialog box opens.. Locate the 'Windows Options' section and uncheck 'Gridlines.' Click 'OK' to confirm your changes. The gridlines on your spreadsheet are now hidden from vi...
Monday, July 18, 2011
How to Add Cells in Excel
Add Blank Cells to an Excel Spreadsheet1. Highlight the location for the new cells.2. Click on a cell and drag the mouse until all the cells in the location have been highlighted. The number of cells you select should be equal to the number of cells you want to add.3. Click on 'Insert' on the toolbar and select 'cells' from the menu.4. Select 'Shift cells right' or 'Shift cells down.' 'Shift cells right' will move the data in the cells you have selected to the right and put new cells where the old data used to be, while 'Shift cells down' will move the data down, making space for the new...
How to Draw Separating Lines in Excel
Draw a Border Line1. Open the Excel worksheet.2. Click the “Home” tab on the command ribbon.3. Click the arrow next to the “Border” button in the 'Font' group to display a list of border styles. To create a custom line, click the “Draw Border” option in the “Draw Borders” section. The pointer converts to a pencil symbol.4. Click and drag the cursor on the worksheet to start the line.5. Release the mouse to end the line. Press any key to convert the pencil symbol back to a pointer.Insert a Pre-Defined Border6. Open the Excel worksheet.7. Click and drag on the range of worksheet cells...
How to Make a Timeline Using Microsoft Excel
1. Open Excel 2010 and select the 'File' tab on the ribbon. Click 'New.' Type 'Timeline' in the search box. Review the timeline templates that appear. Click 'Timeline.' Click the 'Download' button. The template downloads to your computer.2. Review the timeline and update the default timeline. Click on the existing time in the timeline and add your day, month or year sequence to the timeline.3. Update the text boxes with your timeline data. Remove the timeline guide by clicking the outer edge of the box and selecting 'Delete' on your keyboard. Save your change by clicking the 'Save' icon...
Subscribe to:
Posts (Atom)