Excel
Pages - Menu
(Move to ...)
Home
▼
Monday, May 28, 2012
How Can I Put a Last Updated in My Excel Workbook?
›
Create a User-Defined Function 1. Open the workbook and go to the sheet where you will be inserting the last updated date. 2. Click on ...
How to Cross Reference Between Excel Spreadsheets
›
1. Launch Microsoft Excel and open the spreadsheet that is going to display information contained in other files. 2. Open each of the ot...
How to Import PDFs Into Excel 2007
›
1. Open Adobe Acrobat Reader. Click 'File' and select 'Open File.' Select the file that you want to import into Excel. 2. ...
How to Freeze the Top Rows in an Excel 2007 Document So They Appear at the Top of Every Page
›
1. Open the Excel 2007 spreadsheet. 2. Identify the row or rows at the top of the spreadsheet that you wish to freeze. Often just the fi...
Sunday, May 27, 2012
How to Calculate a Moving Average in Excel
›
1. Open a new worksheet in Microsoft Excel. Enter dates and their corresponding data points in two columns. For instance, to analyze month...
How to Convert Open Office Files to Microsoft Excel
›
1. Download and install the Open Office suite if it isn't already on the computer. 2. Open 'Open Office Calc.' 3. Click th...
How to Plot a Scatter Chart in Excel 2007
›
1. Enter labels into the first row of two columns and enter the data beneath it. 2. Click and drag the mouse over all of the data you en...
How to Close MS Excel
›
1. Navigate to the 'File' tab in the top left-hand corner of the Excel program. Click on 'File' and click on the 'Save...
How to Change a Cell to 26Pt in Microsoft Excel
›
1. Open Excel 2007. Click the 'Office' button and select 'Open.' Browse your computer for the spreadsheet you wish to re...
How Do I Set a Dropdown List Box in Excel to Allow Multiple Selects?
›
1. Open the spreadsheet you want to create the drop-down list for in Excel. 2. Locate an area on the spreadsheet to house the list of da...
How to Remove Blank Non
›
1. Open the Microsoft Excel spreadsheet that you want to filter. 2. Highlight the range of cells that you want to include in the filter....
How to Unshare a Workbook in Excel 2007
›
1. Open the workbook you would like to unshare in Microsoft Excel 2007. 2. Go to the 'Review' tab and go to the 'Changes...
How to Lock an Excel 2003 Spreadsheet
›
1. Launch Excel and open the spreadsheet which you want to protect. 2. Click the 'Tools' menu, expand the 'Protection' s...
Saturday, May 26, 2012
How to Remove Locked Cells in Excel 2003
›
1. Open Excel 2003 and click the 'File' drop down menu. Select 'Open.' Browse the files and locate the workbook. Click the...
How to Use Excel to Calculate Total Time
›
1. Enter the starting date and time in cell A1 using the format 'month/day/year hour:minutes AM/PM.' For example, if your starting...
‹
›
Home
View web version