1. Click the 'Page Layout' button on the menu ribbon at the top of the screen.2. Click the 'Margins' button.3. Click 'Custom Margins' at the bottom of the menu.4. Click in each text box, and enter the amount you want the margins to be. Do the same for the header and footer.5. Check the two 'Center on Page' boxes to center the image horizontally and vertically, then click 'OK' to finalize the formatti...
Browse » Home » All posts
Monday, December 23, 2013
Sunday, December 22, 2013
How to Adjust the Right Margin in Excel
1. Open Microsoft Excel.2. Click the 'Page Layout' tab.3. Click 'Margins' and select 'Custom Margins.'4. Change the value of the right margin to whatever you need.5. Click 'OK' to close the 'Custom Margins' b...
How to Make a Line Graph From a Data Table
1. Open the Excel worksheet.2. Click and drag to select the data and categories on the worksheet. A dark outline appears around the range of cells.3. Click the 'Insert' tab on the command Ribbon.4. Click the 'Line' arrow in the 'Charts' group. A list of chart thumbnails appears, such as '2-D Line' and '3-D Line.'5. Click the 'Line' button from the 'Line' section. The data converts to an embedded line graph that hovers over the worksheet. The 'Chart Tools' ribbon appears.6. Edit the chart using the buttons in the 'Design,' 'Layout' or 'Format' tabs, if preferred. The 'Design' commands...
How to Use Ticks in Excel
1. Open the Excel file.2. Click 'Developer Tools' on the command ribbon.3. Click the down arrow on the 'Insert' button in the 'Controls' group. A list of controls appears.4. Click the 'Check Box' button. This button displays a check mark inside of a square. The pointer changes to a ' ' symbol.5. Click on the cell to place the check box. A square and the text 'Check Box 1' display on the worksheet.6. Edit the text if desired. For example, delete 'Check Box 1' and type an item or a step to compile a list.7. Click the text to insert a check or tick in the check box. To remove the check,...
Friday, December 20, 2013
How to Plot a Secondary Axis on Microsoft Excel
Secondary Vertical Axis1. Open the spreadsheet in Excel that contains the chart to which you want to add a secondary axis. Click the 'Microsoft Office' button, then click 'Open' and then locate the file on your computer. Click 'Open' to open the file. Your existing chart should pop up on the screen when you open the spreadsheet. Depending on the type of graph you created, it could be a bar chart, line graph or other graph type.2. Click the data series in the chart you want to plot on a secondary axis.3. Click the 'Format' tab, then click 'Format Selection' in the 'Current Selection' group.4....
How to Open Excel 2007 in an Earlier Version of Excel
1. Go to the Microsoft Download Center online.2. Click on the Microsoft Compatibility Pack. Click 'Download.'3. Click 'Run' in the box that appears on the screen.4. Click 'Run' in the next box that appears on the screen.5. Check the box 'Accept' to accept the terms.6. Click 'OK' in the next box to appear on the screen. Wait for the loading to finish.7. Open Excel and double-click on the Excel 2007 file that needs to be opened. Wait for the file conversion to complete.8. Makes changes and work in the file, saving it when do...
Thursday, December 19, 2013
How to Insert a Tab Name in a Cell
1. Open Microsoft Excel. Choose the spreadsheet you want to work with.2. Click on the cell where you want to insert the tab name.3. Enter the following formula into the cell:=MID(CELL('filename',A1),FIND(']',CELL('filename',A1)) 1,2...
How to Convert Excel to DAT
1. Double click to open your Microsoft Excel 2010 file.2. Click the 'File' tab in the upper-left corner, then select 'Save As.'3. Click the drop-down menu to the right of 'Save As Type' and select 'CSV (Comma Delimited).'4. Click the 'Save' button, click 'OK' to save the active sheet, then click 'Yes' to keep the worksheet in CSV format.5. Right click the CSV file you just created, click 'Open With' and select 'Notepad.'6. Click 'File' at the top of the window, then click 'Save As.'7. Click the drop-down menu to the right of 'Save As Type' and choose 'All Files.'8. Click inside...
How to Change the Macro Security Levels on Excel 2003
1. Open the Microsoft Excel 2003 application on your computer, and then click the 'File' option from the top toolbar menu.2. Click the 'Open' option, and then select the Excel 2003 document you want to work with. Click the 'Open' button.3. Click the 'Tools' option from the top Excel toolbar menu, and then click the 'Options' button.4. Click the 'Security' tab in the new dialog box that appears on the screen. Click the 'Macro Security' option.5. Select the 'Security Level' tab and then select the 'Very High', 'High', 'Medium' or 'Low' option. Click the 'OK' button and close out of the...
How to Delete the First Five Characters in Excel 2007
1. Open your spreadsheet in Microsoft Excel 2007.2. Locate the cell that contains the text you need to truncate.3. Enter the following text in a new cell, replacing 'old_text' with the cell reference of the text you need to truncate.=REPLACE(old_text,1,5,'')As an example, to delete the first five characters from cell A1, you would enter:=REPLACE(A1,1,5,'')Alternatively, you can replace 'old_text' with the actual text encased in quotes. As an example, to delete the first five characters from the text 'truncate me!,' you would enter:=REPLACE('truncate me!',1,5,...
Wednesday, December 18, 2013
How to Calculate Business Quarters in Excel Not Based on Calendar Year
1. Open a new workbook in Excel and enter a list of random dates that can be used for testing.You can copy these example dates to your sheet beginning in cell A1:1/4/20102/11/20103/21/20104/28/20106/5/20107/13/20108/20/20109/27/201011/4/201012/12/20102. Determine the number value of the month in which your 'year' starts (e.g. January is 1 and November is 11). For this example, the year will start in October (month 8).3. Subtract one from your month value. In this example, the result would equal seven (7).4. Substitute your new value into the following equation:=MOD(CEILING(22 MONTH()...
How to Copy Formulas Without Changing Them in Excel
1. Open your Excel document.2. Click on the cell containing the formula you wish to work on.3. Locate your cell references in the formula shown in the Formula Bar. These will be a letter followed by a number, such as A3 or D14.4. Place a dollar sign ($) in front of the letter and number of the cell reference you don't want to change. Examples would be $A$3 or $D$14.5. Copy your formula to the other parts of your spreadsheet--you'll see that Excel does not change your cell referenc...
Tuesday, December 17, 2013
How to Center Horizontally and Vertically in Excel
Center Horizontally1. Click the cell or cells in which you want to center data horizontally.2. Click the 'Home' tab.3. Click the 'Center' button located in the 'Alignment' group. The Center button centers the text horizontally in the selected cell.Center Vertically4. Click the cell or cells in which you want to center data vertically.5. Click the 'Home' tab.6. Click the 'Middle Align' button located in the 'Alignment' group. The Middle Align button centers the text vertically, between the top and bottom of the ce...
Monday, December 16, 2013
How to Lock a Formula in Excel 2007
1. Select the cell containing the formula you wish to lock by highlighting it.2. Click on the 'Home' tab, which is located on the top of the Excel window.3. Navigate to the 'Cells' module, which is on the right half of the Excel window. Select 'Format.' A menu displaying cell formatting options will appear.4. Navigate to the 'Protection' section of the format menu. Click on 'Lock Cell,' highlighting the lock icon.5. Protect the sheet; until you do so, locking the formula cell will not take effect. Repeat steps 2 and 3. Select 'Protect Sheet' from the cell formatting menu. A dialog box...
How to Do Descriptive Statistics in MS Excel 2007
Analysis ToolPak1. Install the Microsoft Office Analysis ToolPak. Click the 'Microsoft Office Button' and then 'Excel Options.'2. Click 'Add-ins' and then 'Excel Add-ins' located in the Manage box. Click 'Go.'3. Select 'Analysis ToolPak' in the Add-ins Available box and click 'OK.' If you do not see the Analysis ToolPak option, click 'Browse' to locate it. Click 'Yes' to install it if a prompt signifies that it is not installed on your computer.Descriptive Statistics4. Collect the data you would like to analyze. The descriptive statistics tool will be used later to organize and interpret...
Subscribe to:
Posts (Atom)