1. Click on the tab of the worksheet that you want to delete to select that sheet. The worksheet tabs are located at the bottom of the Excel workbook.2. Click the 'Home' tab in the upper-left corner of the Office ribbon.3. Click the drop-down menu next to the 'Delete' button in the 'Cells' section of the ribbon bar.4. Select 'Delete Sheet' in the drop-down me...
Browse » Home » All posts
Sunday, August 18, 2013
How to Set Up a Memo Format
1. Create a memo using Microsoft Word 2010 by selecting from several template designs. Click 'File,' 'New.' Select 'Memos' under Office.com Templates, and double-click on the memo style you want to use. You can edit the format, if necessary, and add information to it.2. Create a memo using Microsoft Excel 2010. Click 'File,' 'New.' Select 'Memos' under Office.com Templates. Double-click on the memo style you want to use. Edit the memo format by deleting rows and columns or renaming the headings for the table.3. An email may also serve as a memo and there is less formatting involved. Many...
How to Use Autofill in Excel 2007
1. Position the cursor in the first cell of the series and type in the data. For our example using days of the week, type 'Monday' into the first cell and press 'Enter' on your keyboard.2. Click on the cell and move your mouse so that the pointer is positioned over the small black box in the lower right corner of the cell. The pointer will change from a white cross to a black cross when you have it positioned correctly.3. Use your mouse to drag the black cross, known as the AutoFill handle, across the range of cells which you wish to fill with the rest of the series.4. Release your mouse...
Saturday, August 17, 2013
How to Change the Author of an Excel Spreadsheet
1. Open the Excel document that you want to change the author.2. Click on the 'File' tab in the top-left corner of the Excel window. Then select 'Info' from the list of options on the left side of the 'File' screen.3. Select 'Properties' on the right side of the 'Info' screen. Then select 'Show Document Panel' from the drop-down menu. You will automatically taken back to the 'Home' tab and your Excel worksheet will appear on the screen, with the document panel positioned just above it.4. Select the text box next to 'Author.' Delete the data in that box and enter your desired author name....
How to Make a Multiple Baseline Graph in Excel
1. Type in your data into an Excel worksheet in which each column represents a separate baseline condition.2. Label the first row of each column with the condition name.3. Highlight the data you wish to include in the graph. Click on the 'Chart Wizard' icon in the toolbar and select the standard line graph. Press 'Next'.4. Click on the vertical axis , then select the 'Scale' tab to change the scaling on the y axis so that vertical axis hangs over the horizontal axis.5. Input the same minimum value for the 'x' and 'y' axes. Click 'OK.'6. Draw phase changes using the line tool in the...
How to Combine Columns of Data in MS Excel
Combining Values Through Arithmetic1. Launch Excel on your computer and open the spreadsheet for which you want to combine columns of data through arithmetic.2. Click on the first row of an empty column and type the following formula into the cell:=$A1 $B1.Replace 'A' with the column holding the first value to be combined and 'B' with the column holding the second value to be combined. Replace the ' ' (sum) operator with whatever Excel operator you need to compute the combination.3. Press 'Ctrl-C' to copy the formula. Select all entries in the column that you want defined. Excel will display...
How to Enable Macros in Excel 2003
The XLStart Folder1. Open the folder that contains the workbook file with the macros you want to enable.2. Right-click on that file and click \'Cut\' from the drop-down menu that appears.3. Open the folder \'C:\\Documents and Settings\\[User Name]\\Application Data\\Microsoft\\Excel.\' Note: in this example, \'[User Name]\' is a generic placeholder for your actual user name on your computer. So, if you're logged on as \'JohnSmith\', the folder you would open is \'C:\\Documents and Settings\\JohnSmith\\Application Data\\Microsoft\\Excel.\'4. Look for a folder titled \'XLStart.\' If you...
How to Apply Shading to the Whole Page
Apply Shading to a Word Document1. Open the Word document.2. Click the 'Page Layout' tab on the command ribbon.3. Click the 'Page Color' button in the 'Page Background' group. A gallery of color samples appears.4. Hover over a color sample to preview the effect on the document.5. Click the color sample. The page color converts to the selected color.Apply Shading to an Excel Worksheet6. Open the Excel workbook.7. Click the 'Select All' button in the upper left corner of the worksheet. The rectangular 'Select All' button displays a triangle adjacent to the 'A' and '1' headers. This...
Friday, August 16, 2013
How to Use Autofit in Excel
Autofit a Single Column in Excel1. Start Microsoft Excel and open up an existing spreadsheet that contains one column that you would like to apply autofit to. You can also start a new spreadsheet so you can practice using Excel's autofit.2. Position your mouse over the right border of the column that you would like to autofit the contents. Your mouse pointer will change into a double-headed arrow when you are directly over the border.3. Double-click with your mouse on top of the border, only when you see the double-headed arrow.4. Notice that your longest entry will now fit within the...
How to Make Labels Through Microsoft Excel
1. Open a blank worksheet in Microsoft Excel.2. Begin by entering column headers for each field of data in your list of addresses. Click in cell A1 and type 'First Name.' Press 'Tab' to go to the next column. Enter 'Last Name.' Continue tabbing over and entering the column headers for street address 1, street address 2, city, state and ZIP code.3. Click cell A2. Enter the first name of the first person in your address list. Tab over to add the rest of their address information in the corresponding column. Each row will be one individual address record.4. Press 'Enter' to move to the next...
How to Make a Pipe Delimited File in Excel
1. Click the Windows 'Start' button in the computer's taskbar, and then click 'Control Panel' in the resulting menu. This opens a window.2. Click 'Region and Language' in the window that appears. The Region and Language window opens.3. Click the 'Additional Settings' button in the Region and Language window. The Customize Format window appears.4. Highlight the comma in the 'List separator' field. Press the 'Shift' key and the backslash key simultaneously on your keyboard. This will create a pipe (|).5. Press the 'Apply' button, then 'OK' to close the Customize Format window. Press 'OK'...
How to Add Borders to Cells in Microsoft Excel
1. Launch Excel by double clicking the icon on the Desktop or by finding the application under the 'Start' menu.2. Choose the file you wish to work with and open it.3. Highlight the cells in the spreadsheet that you want to have a border. Place the mouse in the cell you wish the border to start, press and hold down the left mouse button and drag the mouse over the cells you wish to change. Release the left button. The area you want to manipulate should be shaded.4. Right click in the shaded area. A window of options appears, select 'Format Cells.' Choose the 'Border' tab. There are several...
Thursday, August 15, 2013
How to Download Data From the Web to Excel
Download Data from the Web to Excel 20031. Open Microsoft Excel 2003.2. Select the 'Data' option from the toolbar at the top of the screen, select 'Import External Data,' and then select 'New Web Query.'3. Type the URL of your desired Web page into the text field next to 'Address' at the top of the window, then click the 'Go' button.4. Click the yellow arrow(s) located next to the information that you wish to download into Excel.5. Select the 'Import' button at the bottom of the window once all your required data has been downloaded.6. Select the location on your worksheet into which...
How to Insert an Attachment Into an Excel Spreadsheet
1. Open your Excel spreadsheet. Choose the cell where you want to insert your attachment. Click inside this cell. Select 'Insert' from the menu bar, then click 'Object.'2. Select 'Create New' if you will create a new file to attach to the spreadsheet. Select 'Create from File' if you will attach a file that you have already saved on your computer.3. If you will create a new file to insert, select the type of file you will make. Check the 'Display as icon' box if you want to display the attachment as a representative icon rather than a full file display. Click 'OK.' Create the new file. The...
How to Make a Line Chart in Excel 2007
1. Enter data that will be charted into the spreadsheet. Line charts allow you the flexibility to present the information in rows or columns. Include text headers to identify what data is in the row or column.2. Highlight the information that you want to chart. Click the first cell in the series that you want to highlight. While holding down the mouse button, drag the cursor highlighting all the data that will be inserted in chart.3. Choose the type of chart you want to create. Click the Line button. This button is located under the Insert tab on the top ribbon. Choose the first option...
Subscribe to:
Posts (Atom)