File Never Saved1. Reopen Excel.2. Click on 'File' in the upper-left hand corner of the screen. Then click 'Recent.'3. Select 'Recover Unsaved Workbooks.' This will display a list of any workbooks you worked on that were not saved.4. Select your file you were working on. Excel will record the time that the file was last worked on, so you can tell which file is the one you want if the time is close to when you closed Excel without saving or Excel crashed.5. Click 'Open.'6. Click 'Save As' to save your file. You need to name the file and then click 'Save.'Files Previously Saved7. Open...
Browse » Home » All posts
Thursday, June 14, 2012
Wednesday, June 13, 2012
How to Sort Alphabetically in Excel 2003
1. Enter your data into a column or row in Excel.2. Click on the column letter on the top of the spreadsheet or the row number on the side of the spreadsheet that you want to alphabetize.3. Click the button with an A on top of a Z near the top of the window if you want to sort from A to Z or click the button with a Z on top of an A if you want to sort from Z to...
How to Save Print Settings in Excel 2007
1. Open Microsoft Excel from the Windows Start Menu by clicking 'Start' > 'Program Files' > 'Microsoft Excel'. The application will start in a new window.2. Open your spreadsheet from the top pull-down menu. Click 'File' and 'Open...', and then select your spreadsheet file using the file browser window.3. Select the cells you want to print by clicking and dragging your mouse on the spreadsheet to highlight the cells of your choice.4. Open your Page Setup settings from the top menu by clicking 'File' > 'Page Setup...'. Adjust the margins and page orientation to fit what you are...
How to Stop Excel Windows From Maximizing
1. Click 'Start' and open 'All Programs.'2. Right-click on 'Microsoft Excel.'3. Click 'Properties' and choose 'Shortcut.'4. Open the 'Run' pull-down menu and click 'Minimized.'5. Click 'Apply.' Click 'OK' to save your changes. Excel windows will now stay minimiz...
How to Add Borders to Cells in Microsoft Excel 2007
1. Select the cell or region of cells you would like to add borders to.2. Click on the 'Border' icon located on the Home tab of the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.3. Select the style of border you would like applied to your selected cells.4. Select the cell or range of cells you would like to edit the formatting on. For example, you can change the color of a selected bord...
How to Compress Pictures in Excel
1. Open Microsoft Excel 2007 and start a new workbook and insert at least one picture into it, or open an existing workbook from your files that contains at least one picture you would like to compress.2. Click to select the picture that you want to compress. After you have clicked the picture it will be surrounded by white sizing handles indicating that it is selected.3. Choose the 'Format' tab at the top of the screen to display the Format ribbon. The Format ribbon contains all the commands you can use to format a picture in Excel.4. Select the 'Compress Pictures' button in the 'Adjust'...
Tuesday, June 12, 2012
How to Change Text to Uppercase in Excel 2007
1. Insert a blank column to the left of the column with cells that need to be converted to uppercase text by right-clicking on the column-header of the source cells and choosing 'Insert' from the shortcut menu that appears.2. Use the UPPER function to convert the text by clicking in the first cell of the new column and typing the following formula: =UPPER(A1) where A1 is the cell reference of the first cell with lowercase text. Use your keyboard to hit the Shift Enter keys. You will see the result of the formula while staying in the active cell.3. Fill the formula down to all additional...
How to Edit Macros in Excel
1. Open an existing spreadsheet or workbook in Excel that has at least one macro already created. Go to the 'Tools' menu bar and select 'Macro' and then 'Macros.'2. Type the name of the macro you wish to edit into the 'Macro Name' box. Click on the desired macro if multiple appear.3. Click the 'Edit' button. The Visual Basic editor will be displayed in a separate window with the code for that macro displayed.4. Make the desired changes to the macro. Leave the first line starting with 'Sub' and the last line should remain 'End Sub.'5. Close the box with the edited information. The changes...
How to Remove Recent Documents From Excel 2007
1. Click 'Start,' 'All Programs,' 'Microsoft Office' and then select 'Microsoft Office Excel 2007.'2. Click the 'Office' button in the upper left corner of the screen and select 'Excel Options' at the bottom of the window.3. Select 'Advanced' from the column on the left side of the 'Excel Options' window.4. Scroll to the 'Display' section and then adjust the number to '0' next to 'Show This Number of Recent Documents.'5. Click 'OK' to close the window and apply your chang...
Monday, June 11, 2012
How to Create a Regression Equation Chart in Excel 2003
1. Input your data into your spreadsheet in two columns. For example, use fertilizer use and crop yield. Make sure the data 'lines up' -- that the fertilizer use and crop yield of plot A are in the same row; the same for plot B and so on.2. Select the height and weight data that you want to graph and use the Chart Wizard to plot the data. The dependant variable, the one that you expect is affected by the other variable (in this case crop yield), should be on the y-axis.3. Right-click on one of the data points on the graph and select 'Add trendline.'4. Select the 'Linear' trend/regression...
How to Add a Data Table to an Excel Chart
1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like add a data table.2. Select the chart you would like to add a data table to by clicking on it. You should see a light blue border surrounding the chart once it is selected.3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Find the 'Labels' group near the center of the groups in the 'Layout' ribbon.4. Click the 'Data Table' button in the 'Labels' group of the 'Layout' ribbon. A drop-down list of options will appear.5....
How to Convert Mailing Labels to Columns in Excel
1. Open the Word document containing the mailing labels. In Word 2003 or earlier, go to the 'File' menu, select 'Open,' click on the document name and click the 'Open' button. In Word 2007, click the 'Office Button,' select 'Open,' click on the document name and click the 'Open' button. In Word 2010, click the 'File Tab,' select 'Open,' click on the document name and click the 'Open' button.2. Select all of the information in the labels by clicking the 'Table Move Handle' at the top left side of the table. This handle looks like crossed, double-headed arrows. Because Word views the label document...
How to Use Excel for Optimization Calculations
1. Compute an equation for the optimization. For example, suppose the problem is to create a fence that encloses 100 square feet while using the least amount of fencing. Then, the two equations would be 'area = length * width' and 'total fence = 2*l 2*w.'2. Enter the formulas into Excel. Enter an example length of 25 feet in box 'A1.' Enter an example width of 4 ft in box 'A2.' Type '=A1*A2' into box 'A3.' Box 'A3' is the area parameter. Type '=(2*A1) (2*A2)' into box 'A4.' Box 'A4' is the perimeter which is to be optimized.3. Select 'Solver' from the 'Tools' menu.4. Enter the value...
How to Use Minutes Seconds in Excel
1. Select and highlight the group of cells in your spreadsheet (such as a column or a row) where data will be entered as time in minutes and seconds.2. Select 'Cells' under 'Format' in the top menu bar.3. Click the 'Number' tab and select the 'Custom' option from the list of categories on the left.4. Select 'h:mm:ss' from the list of custom format or type 'h:mm:ss' in the field under 'Type.'5. Click the 'OK' button.Calculating Time6. Select the cell that will be used to calculate the total number of minutes and seconds entered.7. Type the following part of the formula, '=sum(' then...
How to Create Invoice Templates in MS Excel
1. Open Excel. Click on the 'Office' button. Select 'New.' Choose 'Blank and recent' from the 'Templates' pane. Click 'Blank Workbook' in the middle pane. Click 'Create' Button.2. Select column A by clicking at the top of the column with the mouse. Hold the 'Shift' key while clicking the mouse on column F. Right-click on the selection. Set 'Column Width' to 15.3. Click in cell A1. Select 'Home' from the menu bar. Choose 'Cell' and 'Format' from the toolbar. Set the 'Row Height' to 58.4. Choose 'Insert' from menu bar. Select 'Picture' or 'Clip Art' from toolbar. Choose and insert picture...
Subscribe to:
Posts (Atom)