Numerical (Value) Axis1. Open the Microsoft Excel 2010 file that contains the chart you want to alter.2. Click anywhere on the chart. Select the 'Format' tab at the far-right end of the ribbon. Click the drop-down box that appears on the far-left end of the ribbon. Select your desired axis from the list. Then, choose the 'Format Selection' button located right below the drop-down box.3. Click the radio button next to 'Fixed' under the 'Minimum' heading. Place your cursor into the text box next to this button and enter the lowest number you want displayed on your axis. Place a dash before...
Browse » Home » All posts
Wednesday, April 17, 2013
Tuesday, April 16, 2013
How to Import an Excel Spreadsheet into Another Sheet
Linking1. Launch Microsoft Excel and open the source file that contains the data to be linked.2. Open or create the destination file in which the data will be displayed.3. Navigate to the source spreadsheet and highlight (or 'Select') the cell or range of cells to be imported by clicking the cell, or clicking the top left corner of the range of cells and holding the mouse button down while dragging the cursor to the lower right corner of the range of cells and then releasing the mouse button. Alternately, click the gray button that contains the row number or column letter to select an entire...
How to Remove Duplicates From Access Query
1. Open an Access 2007 database on your computer. Make sure it has a table that contains duplicate data. Select the 'Office' button and select 'Open.' Search your computer and locate the database. Click on the database and select 'Open.'2. View the tables in your database in the Navigation Pane. Open one of the tables and visually note the duplicates and note the total number of records. Select the 'Create' tab on the ribbon. Click on the 'Query Design' button. Add the table you have just viewed by clicking on the table and selecting 'Add.' Select 'Close.' Add some fields to the...
How to Insert a Dynamic Date and Time in Excel
1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files that you want to insert a dynamic date and time into. Or, start a new, blank spreadsheet.2. Click to select the cell into which you want to insert the dynamic date and time. The cell will be outlined in a thick, black line indicating it is selected.3. Use your keyboard to type '=now()' (without the quotation marks) into the selected cell. This is the formula that is used to instruct Excel 2007 to insert the dynamic date and time.4. Press the 'Enter' key on your keyboard to enter the formula into the selected...
How to Convert a Word Document to a CSV File
1. Open the Microsoft Word document in Word and save it as a '.txt' file. To do this, select 'File' and then chose 'Save As.' Next, use the down arrow next to 'File as Type' and select '.txt.'2. Open the Microsoft Word document in MS Excel by selecting 'File' and then 'Open.' Find the file in the 'Look in' directory from within the 'Open' dialog box.3. Click option 'Delimited' and then click '1' beside 'Start Import at Row' to indicate the first row to import the data. Next, select the geographical location of the original file format beside 'File Origin.' When done, click 'Next.'4. Click...
Monday, April 15, 2013
How to Convert Word to Excel 2003
1. Open the Word document with the data you want to convert to Excel 2003.2. Highlight the data with your mouse. Choose 'Convert Text to Table' from the 'Insert' menu and convert the text into a table if it is not already.3. Hover your mouse over the table until you see a ' ' appear in the upper-left corner. Click on the ' ' sign to select the entire table.4. Click 'Edit' and then 'Copy.'5. Launch Excel 2003 and click into a blank cell.6. Click 'Edit' and then 'Paste.' Your data will appear within Excel.7. Click 'File' 'Save As' and choose 'Excel Workbook (.xls)' from the 'Save as...
How to Change the Axis on Excel 2007
Swap X and Y Axes1. Open the Excel file that contains the chart you want to manipulate.2. Right-click anywhere within the chart itself. Choose 'Select Data' from the pop-up menu. A small data window will appear on the screen.3. Click the 'Switch Row/Column' button in the middle of the window. Click 'OK' to confirm your changes. Your X and Y axes will now be swapped on the graph.Alter an Individual Axis4. Open the Excel 2007 file that holds the chart you want to change.5. Select one of the cells that contain the information used in the axis you want to alter. Press 'Delete' to remove...
How to Recover an Excel 2007 File
After an Excel Crash1. Restart Microsoft Excel 2007. You may also need to restart your computer if you had a system crash or power outage. The document recovery task pane should automatically open on the left side of the screen.2. Scroll through the documents in the 'Available Files' list. Excel will try to recover up to three versions of the document you were most recently working on.3. Select a file from the list. Click the down-arrow icon.4. Click 'Open' to view the recovered document. If you know you want to keep the file, click 'Save as' to rename it. Click 'Delete' if you want to...
Sunday, April 14, 2013
How to Merge Data From Two Spreadsheets
1. Open Excel 2010 and locate the workbook containing the worksheets that will be merged. Click the 'File' tab and select the 'Open' icon. Find the workbook and double-click it.2. Click in the next blank worksheet in the workbook. Select the 'Data' tab. Click 'Consolidate.' The Consolidate dialog box opens.3. Select the function you will use to merge the data. If you are adding the merged values, select 'Sum.' Click the red box in the reference section.4. Click the worksheet that contains the first set of data that will be merged. Highlight the range and click the 'Add' button....
How to Define Cell Ranges in Excel
1. Enter Microsoft Excel and open a worksheet.2. Select the range of cells (or even the nonadjacent cells) that you want to name.3. Locate the name box at the top-left of the formula bar, just above the row and column headings.4. Click in the box and type the name you want for the cell range.5. Press Enter to accept the name.6. Use the name in formulas you crea...
How to Disable a Date Autofill in Excel
Disable the AutoComplete Option1. Open the Excel file.2. Click the 'File' tab on the command ribbon. A list of basic commands appears.3. Click 'Options.' The 'Excel Options' window appears. The left pane includes the 'Advanced' command.4. Click 'Advanced.' A list of editing options appears.5. Clear the check box for 'Enable AutoComplete for cell values.'6. Click 'OK.' This button is located at the bottom of the dialog window. The 'AutoComplete' command no longer copies the cell data to new cells. The worksheet is open for editing.Disable the AutoFill Option7. Open the Excel file.8....
How do I Create Mailing Labels in MS Word From an MS Excel Spreadsheet?
Prepare the Mailing List1. Open a new spreadsheet and use the first row to create column headers across the top of the document. Name the top cell of each column to correspond with the address fields on your labels, for example: 'First Name,' 'Last Name,' and so on.2. Start in the first cell on the second row and enter the data that corresponds with the cell header. For example, enter the recipient's first name in the row under the 'First Name' label. Continue until you have entered all of your mail recipients and save your document.3. Highlight all of the data in the mailing list. Single-click...
How to Subtract Using Excel 2007
1. Double-click the Excel 2007 icon on your desktop or in your 'Programs' list to open the program to a blank worksheet.2. Enter the numbers you want to subtract in separate cells in the spreadsheet.You can select any cells you would like, but it's usually convenient to place the numbers next to one another either horizontally, in two separate columns, or vertically, in two separate rows.If you want to work with data from an existing spreadsheet, open that file to begin working on it.3. Enter a subtraction formula in a blank cell. The formula is an equal sign, followed by the first cell...
How to Fill Cells With Colors in Microsoft Excel 2003
1. Select the cell that you wish to fill. You will need to left-click on the cell that you wish to fill with color in order to activate that cell.2. Access the color-fill palette. The color-fill palette is located on the command bar and looks like an icon of a paint bucket spilling out paint. Simply left-click on this icon and a color palette will open.3. Select a fill color. Once the color palette is open, just click on the desired color.4. Fill the cell with the desired color. Once you click on the desired color, the cell will automatically fill with that color. You can easily change...
Saturday, April 13, 2013
How to Divide a Cell in Two
1. Launch Microsoft Excel. Double-click the name of the document you want to edit on your hard drive to open it in Microsoft Excel.2. Insert a blank column next to the cell or column of cells you want to split. Highlight your cell by clicking on it (or the whole column by clicking on the column heading) and hold down the 'Alt,' 'I' and 'C' keys at the same time to insert a new column.3. Open the 'Convert Text to Columns Wizard.' In Excel 2003 and earlier versions, drop-down the 'Data' menu and select 'Convert Text Into Columns.' In Excel 2007 and 2010, navigate to the 'Data' tab and click...
Subscribe to:
Posts (Atom)