Excel
Pages - Menu
(Move to ...)
Home
▼
Monday, November 18, 2013
How to Set Workbook Share Options in Microsoft Excel 2003
›
1. Open the workbook share menu. Scroll to “Tools” and then click on “Share Workbook.” 2. Set up the workbook to be shared. In the workb...
How to Use AutoFit Tool in Excel
›
Select the Data to AutoFit 1. Open the Excel workbook. 2. Select an entire worksheet by clicking the square in the top left corner. 3. ...
Sunday, November 17, 2013
How to Convert Dates Times Into Decimals in Excel 2003
›
1. Click the Windows 'Start' button and type 'excel' in the search text box. Press 'Enter' to open the Excel 2003 ...
How to Delete Blank Lines in Excel 2007 Lists
›
1. Open the Microsoft Excel 2007 application on your computer. Click the 'Office' button. 2. Click the 'Open' option and...
How to Protect a Workbook in Microsoft Excel 2003
›
1. Open the workbook that you wish to protect. You will need to first open a workbook before you can protect it. You can do this by scroll...
Saturday, November 16, 2013
How to Copy Excel Macros From One PC to Another
›
1. Open the Visual Basic Editor (VBE) on the computer you want to transfer the file from by clicking on 'Alt' and 'F11' on...
How to Round Up to the Nearest 10 in Excel
›
1. Open your spreadsheet and click on a cell next to the cell(s) you would like to round up to the nearest 10. 2. Input the formula ...
How to Add or Subtract Percentages
›
1. Convert the percentage you want to add or subtract to a decimal. For example, 60 percent in decimal form is equal to .60. 2. Multiply...
How to Create a Bar Graph in Microsoft Works
›
1. Open Microsoft Works Spreadsheet by clicking 'Start,' 'All Programs,' 'Microsoft Works' and then 'Microsoft...
Friday, November 15, 2013
How to Track Changes to a Workbook by Others in Excel 2007
›
1. Open Microsoft Excel 2007. Click on the “Office” button. 2. Select 'Open' from the menu. Find and highlight the file where yo...
Thursday, November 14, 2013
How to Draw a Box Plot in Excel
›
1. Launch Excel. It should open up to a blank worksheet. Put your mouse in box A1 and type in the word 'Statistic.' Type 'Medi...
How to Create a Grade Book Using Microsoft Excel
›
1. Open a new spreadsheet in Excel. Save it using a name such as 'Gradebook template.xls.' 2. Type in a column name in the top l...
Tuesday, November 12, 2013
How to Group Images in Excel
›
1. Start Microsoft Excel 2007 and open an existing workbook from your files that contains at least two images that you would like to group...
How to Copy Paste Hyperlinks to Another Worksheet in Excel
›
1. Launch Microsoft Excel. 2. Select the worksheet tab at the bottom of the screen which contains the hyperlink you wish to copy. 3. R...
Monday, November 11, 2013
How to Set Print Area in Excel 2007
›
1. Open the Excel 2007 worksheet in which you want to define a print area. 2. Click a cell and drag the cursor over the rest of the cell...
‹
›
Home
View web version