Excel
Pages - Menu
(Move to ...)
Home
▼
Wednesday, September 28, 2011
How to Insert a Button in Excel 2007
›
1. Open Excel and check that the 'Developer' tab is available on the ribbon. If it is not, click the Windows button, and then clic...
How to Convert Excel to a Visio Organization Chart
›
1. Create a table in Excel listing all of the names and titles you want to use in the organization chart. Enter the headings 'Title,...
How to Add 12 Weeks to a Date in Excel
›
1. Open Microsoft Excel. 2. Write the start date in cell A1 using the familiar format month/day/year and press 'Enter.' As an ex...
How to Name a Chart Object in Excel
›
1. Right-click your Excel spreadsheet file and select 'Open With.' Click 'Microsoft Excel' in the list of programs. 2. C...
How to Protect Individual Cells in Excel 2003
›
1. Launch 'Excel 2003' and open the file that contains the individual cell that you want to protect. Click once on the cell that y...
Tuesday, September 27, 2011
How to Convert a Number to a Date in Excel 2003 When the Format Is yyyymmdd
›
1. Create a grid with your numbers in Excel, if you haven't already done so. Open a new spreadsheet and type your numbers into column ...
How to Unprotect a Word Doc
›
1. Click the 'Review' tab at the top of the screen. 2. Click 'Restrict Editing' in the Protect group. 3. Click the ...
How to Make an Invoice Spreadsheet in Excel
›
1. Open Microsoft Excel. A blank spreadsheet will open, and you will notice that predetermined rows and columns are already set up. 2. E...
Monday, September 26, 2011
How to Alphabetize a List in Works/Word Documents
›
1. Type your list, in no particular order, with each item on a separate line. 2. Highlight the complete list. 3. In the 'Home'...
How to Close the Header Footer Screens in Excel 2007
›
Reset Normal View 1. Press the 'Esc' key if you are in 'Full Screen' mode and cannot see the Office Ribbon. 2. Click the...
How to Scatter Plot Data on Excel
›
Scatter Plot Data in Excel 2003 1. Open Microsoft Excel 2003. 2. Place one set of data in one column and another set of data in an adjac...
How to Lock Column Width in Excel 2007
›
1. Open Excel 2007 and click the 'Office' button. Select 'Open.' Browse the files and locate the workbook. Click the workb...
How to Remove Filters in Excel 2003
›
1. Open Excel 2003 and select a workbook with data. Click 'File' on the menu bar. Click 'Open.' Search your files and loc...
How to Change an Excel Chart to Ascending Order
›
1. Click on the column heading. This is Column A, B, C, etc, in a basic worksheet or the Table in a PivotTable report. Again, you must cha...
Sunday, September 25, 2011
How to Use Negative Numbers to Calculate in Excel
›
Calculating Negative Numbers 1. Enter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number.'...
‹
›
Home
View web version