1. Click the 'Worksheet' tab at the bottom of the Excel window that you want to delete. For example, click on 'Sheet 2.'2. Click on the 'Home' tab in the 'Office' ribbon.3. Click on the down arrow next to the 'Delete' icon in the 'Cells' group.4. Scroll down in the drop-down menu and click on 'Delete Shee...
Browse » Home » All posts
Thursday, October 25, 2012
How to Create Graphs Embed in Spreadsheets
1. Open the saved Excel worksheet.2. Click and drag to select the range of data for the chart. For example, select the categories and the values to appear on the chart.3. Click the 'Insert' tab on the command ribbon.4. Click the preferred 'Chart' button on the 'Charts' group. Click the window launcher arrow in the group's bottom right corner to open a more extensive chart list. A chart appears over the worksheet. The 'Chart Tools' ribbon appears with additional format options.5. Click the preferred formats on the various ribbon tabs, such as 'Design,' 'Layout' or 'Format.' Create a custom...
Wednesday, October 24, 2012
How to Prevent Julian Dates in Excel 2003
1. Click on the cell with the Julian date.2. Type '=RIGHT(YEAR(A1' into the 'Find what?' text box.3. Search for the Excel formula that converts standard dates to Julian dates. The full formula is '=RIGHT(YEAR(A1),2)TEXT(A1-DATE(YEAR(A1),1,0),'000')' where 'A1' is the cell location of the Julian date.4. Click on the cell with the formula, then press the 'Delete' key to remove the formu...
Tuesday, October 23, 2012
How to Change the Orientation of a Worksheet to Landscape in Microsoft Excel
1. Connect your computer to a printer if you have not set up a printer yet for your computer. You do not need an active printer connection to change the page orientation, but you do need a printer setting entered into the computer. Otherwise, Excel will gray out the page orientation option because it only applies to printing. Connecting a printer via USB will automatically launch the setup wizard. Follow the onscreen instructions to install the printer driver until the setup is complete.2. Launch Excel and open your workbook to the worksheet you want in landscape mode.3. Close out of any...
How to Calculate Percentages in Excel 2007
1. Open Excel, and in cell A1 type the numerator. In cell B1 type the denominator. For example, for 75 percent, in A1 type '3' and in B1 type '4.'2. Type '=a1/b1' in cell C1. In the example, C1 will result in 0.75.3. Right-click cell C1, then click 'Format Cells.' Under the 'Number' tab, click on 'Percentage.' Choose how many decimal places you want to take the percentage to. Hit OK. The number is now formatted as a percenta...
Monday, October 22, 2012
How to Format the Toolbar Font Drop Down Menu in Excel 2007
1. Open Microsoft Excel 2007 on your computer screen.2. Click on the circular button at the top of the screen that contains the 'Office' logo.3. Click the 'Excel Options' button followed by the 'Customize' menu option.4. Use the 'Customize' menu on-screen to make the necessary changes to both your main toolbar as well as to the font drop down-menu in Excel 2007. If you want to remove something from either menu, click on its name and click 'Remove.' To add a command to either menu, click on its name and click 'Add.'5. Click 'OK' to save the changes you've just made to your Microsoft Excel...
How to Find Hidden Macros in an Excel Spreadsheet
Finding Macros with the Macro Tools in Excel1. Open Excel normally.2. Click on the 'Developer Tab.'3. Click on the button labeled 'Macros.' A dialog box will pop up. The dialog box will have all the Macros available on all open workbooks. You can select 'Macros' there and delete them.Finding Macros with the Visual Basic Editor4. Open Excel normally.5. Click on the 'Developer Tab.'6. Click on the button labeled 'Visual Basic.' The Visual Basic editor will pop up. On the left hand pane, there will be a list of every single Macro that Excel has loaded; this will include Macros that...
How to Update Microsoft Excel
1. Use the update feature in Excel. Click the 'Office' logo in the top left corner. Click 'Options.' Click the 'Resources' tab. Click 'Check For Updates' under the 'Get Updates' title. The program will automatically search for updates and download them.2. Use Microsoft Windows Updater. Click the 'Start Menu,' and type 'Check For Updates' in the 'Start Search' bar. Hit 'Enter' on the keyboard. Windows updater will open. Click 'Download Updated.' Windows Updater will download updates for Excel, Windows and all other Microsoft programs.3. Upgrade Excel. Excel will only update the version of...
How to Open a Protected Excel 2003 in Excel 2007
1. Click “Start,” select “All Programs,” open the “Microsoft Office” folder and then click “Microsoft Excel” to open Excel 2007.2. Click “File” and then click “Open” to access the files on your computer.3. Browse through the files on your computer for the password protected Excel 2003 worksheet you want to open in Excel 2007.4. Select the file in question and click “Open” to open the worksheet.5. Type in the password for the protected worksheet and then click “OK' to access the file. If you don’t know the password, you’ll have to ask the creator of the file for it or download a password...
How to Create a Legend for a Spreadsheet
Chart Legend1. Create a chart from existing data within a Microsoft Excel spreadsheet. Note that legends aren’t recommended for use with pie charts. Labels should be used instead.2. Go to “Insert” and select “Chart.”3. Select your chart type. Press “Next.”4. Select your data range. Either enter the range of cells manually or press the small button to the right of the range box. Highlight the cells you wish to include in your chart. Choose the “Series” tab to further customize your data range. Press “Next.”5. Enter a title for your chart, X axis and Y axis.6. Select the “Legend” tab....
Sunday, October 21, 2012
How to Change the Vertical Axis on an Excel Bar Chart
1. Click on the vertical axis of the bar graph.2. Click on the 'Layout' tab under 'Chart Tools.'3. Click on 'Format Selection.' The first tab in the pop-up window, 'Axis Options,' allows you to change general options like the interval between tick marks and placement of axis labels. For example, if you want the vertical axis labels to appear in front of the bars (as opposed to sitting in the middle), click on the 'Between tick marks' radio button under 'Position Axis.'4. Select the placement for the vertical axis from the 'Axis Options' tab. For a vertical axis below the bar graph, choose...
Saturday, October 20, 2012
How to Recover Unsaved Word Documents if a Computer Turns Off
Turn on the AutoSave Option1. Open the Word file.2. Click the 'File' tab on the command Ribbon. A list of basic commands opens.3. Click the 'Options' button. A dialog window opens.4. Click 'Save.' This link appears in the left pane. A dialog window opens.5. Click to select the check box for 'Save AutoRecover information every 'X' minutes.' This option appears in the 'Save documents' section.6. Type the number of minutes, such as 10, to specify the timed intervals.7. Click to select the check box for 'Keep the last autosaved version if I close without saving.'8. Click 'OK.'Access...
How to Convert Rows Into Columns
1. Open Excel and input the following data going across in cells 'A3 through L3' the months January through December. In cells 'A4 through L4' enter random figures as shown in the illustration. (NOTE: You can use an existing chart of your own, instead.)2. Highlight the range starting from cells 'A3 through L4'. Do this by placing the mouse pointer in cell A3 and left-clicking the mouse once. While still holding down the mouse pointer, drag it to cover the last cell position in the range of data which is column L and row 4 (L4) and then let go of the mouse.3. Select 'Edit' and then choose...
Friday, October 19, 2012
How to Make My Excel Spreadsheet Interactive
Use the 'Share Workbook' Command1. Open the Excel file.2. Click the 'Review' tab on the command Ribbon.3. Click 'Share Workbook' in the 'Changes' group. A 'Share Workbook' dialog box appears.4. Click the 'Editing' tab on the 'Share Workbook' dialog box.5. Click to select the check box for 'Allow changes by more than one user at the same time. This also allows workbook merging.'6. Click the 'Advanced' tab in the 'Share Workbook' dialog box.7. Select the radio buttons for options, such as 'Track changes' and 'Conflicting changes between users.'8. Click 'OK.'9. Click 'Save' on the...
How to Delete All Unprotected Cells in Excel Spreadsheet
1. Open the spreadsheet containing the unprotected cells that you want to delete. Go to the 'Edit' menu in Excel 2003 and select 'Find.' Go to the 'Editing' group on the 'Home' tab in Excel 2007 or 2010 and click 'Find and Select.' Choose 'Find' from the drop-down menu. You can also use the keyboard shortcut 'Ctrl F' to open the 'Find' dialog box.2. Click the 'Options' button to expand the 'Find' dialog box. Click the 'Format' button to open the 'Find Format' dialog box.3. Go to the 'Protection' tab of the 'Find Format' dialog box.4. Clear the 'Locked' check box by clicking inside it to...
Subscribe to:
Posts (Atom)