How to Copy Paste Row Height in Excel 2007

1. Open an Excel spreadsheet with data.
2. Hover your mouse on the line between two row numbers until you see two black arrows facing in opposite directions appear. Click and drag up or down to adjust the row height.
3. Hover your mouse over the row number you just adjusted until the black arrow pointing to the right appears. Click that row to highlight it.
4. Click the 'Home' tab, and then click the little paintbrush icon in the Clipboard group. Your highlighted row should now have a moving, dashed line around it.
5. Click on a row number to paste the row height.

Read more ►

How to Make Line Graphs in Excel

1. Enter the values you wish to graph in a single column with no spaces.
2. If you wish to attach a descriptor to each value, enter the descriptor to the left of each number in the column. For example, if you want to see how much weight you've lost over time, list the date on the left and the value on the right for each time you've stepped on a scale.
3. Click and drag to highlight all the information you've just entered, including your descriptors. That should cause a blinking box to surround the data you wish to graph.
4. From the top menu, select 'Insert' and then 'Chart.' Choose 'Line graph' from the list of chart types, then select your preferred style from the thumbnails.
5. Follow the prompts to enter a title for your graph and label the X (horizontal) and Y (vertical) axes. Your descriptors should already appear along the X axis. You will then be allowed to choose whether to create your graph within your spreadsheet or on a new sheet.

Read more ►

How to Import a Macro to Excel 2007

1. Open the Microsoft Excel 2007 file that you want to import the macro code into and then click on the 'Developer' tab.
2. Click on the 'Macro Security' option from the 'Code' group. Click on the 'Macro Settings' option from the 'Macro Settings' category.
3. Click on the 'Enable all macros' option and then click on the 'OK' button. Minimize your workbook.
4. Open the Excel file that contains the macro that you want to copy. Click on the 'Developer' tab and then click on the 'Visual Basic' option from the 'Code' group.
5. Click on the 'View' menu option and then click on the 'Project Explorer' option. Click on the macros module you want to import and drag into the other workbook that you want it copied to. The macro will then be fully added to your workbook.

Read more ►

How to Consolidate Worksheets in Excel

1. Turn on your computer and open the Excel spreadsheets that need to be consolidated.
2. Consolidate spreadsheets by position, category, formula or by using a PivotTable. For this how-to we are going to be consolidating by category. Begin by making sure the format is identical in each worksheet. For example, 'Annual Avg.' and 'Annual Average' are seen as different and won't consolidate together.
3. Next go to the worksheet that you want to consolidate and click 'Data,' then choose 'Consolidate.' This will open the Consolidate box.
4. Specify the range by using the Reference box in the window. Click 'Add' to move the range to the 'All References' box. Continue adding ranges until all are defined.
5. Check the 'Create links to source data' box to add links back to the original data. Then click 'Ok' to save and perform the consolidation.

Read more ►

How to Add New Data to Excel 2007 Charts

1. Open the Microsoft Excel 2007 application and the worksheet containing the chart that you want to work with.
2. Click on the chart that you want to add new data for to display the Chart Tools. Make sure you also have the new data stored in the same worksheet where the chart is stored.
3. Click on the 'Design' tab and then click on the 'Select Data' option from the 'Data' group.
4. Click on the 'Add' option from the Select Data Source dialog box. The Edit Series dialog box will then appear.
5. Enter the name for the new series of data into the 'Series name' box. Click in the 'Series values' box and then select the group of cells in your worksheet that contain the new data you want to add. The new data will be added to your chart.

Read more ►

How to Set Excel 2003 Print DPI

1. Launch Microsoft Excel 2003 and open the spreadsheet you want to print.
2. Open the 'File' menu at the top of the window and select 'Page Setup' from the drop-down list.
3. Go to the 'Page' tab at the top of the Page Setup window.
4. Click on the drop-down box next to 'Print Quality' and select the new DPI setting you want to use. The available DPI options will differ based on the type of printer you are using.
5. Click 'OK' to save the settings or press 'Print' to go directly to the main printing dialog box.

Read more ►

How to Select All With Excel VBA Macros

1. Press 'Alt' and 'F11' together on your keyboard from within Microsoft Excel.
2. Open a new module by clicking on 'Open' and then 'Module.'
3. Copy and paste the following code into the blank window:Sub Macro1()'' Macro1 MacroCells.SelectRange('J1').ActivateEnd Sub
4. Press 'F5' to run the macro on your worksheet.

Read more ►

How to Import a Selected Range of Cells Into Access From Excel 2003

1. Open the Excel 2003 spreadsheet that you want to import. Drag your cursor along the record selection buttons to the left of your cells until you encompass the intended records. Press 'Ctrl' and 'C' to copy the records, select another tab in your spreadsheet and press 'Ctrl' and 'V' to paste.
2. Label the second tab with a description so that you can recognize it from Access. Save your Excel spreadsheet after making all of your changes. Close your Excel spreadsheet and open the Access database.
3. Click the 'External Data' tab of the ribbon at the top of the page and select 'Excel.' If you are using Access 2003, click 'File,' then 'Get External Data' and then 'Import.' Locate the Excel spreadsheet saved on your computer and choose whether to add it to a new table or an existing table.
4. Choose the tab with the selected records out of the worksheet options in the import wizard. This option allows you to import single sheets from the same Excel file. Instead of needing to create a new spreadsheet for certain information, you can simply choose a certain sheet.
5. Specify the fields you want to import and the primary key if you're creating a new table. If your records don't have an appropriate field, Access can create a primary key field for you. Name the table and complete the import wizard.

Read more ►

How to Remove Columns in Microsoft Excel 2003

1. Activate the column that you want to remove by left-clicking on the column letter, located at the top of the spreadsheet. When you left-click on the column letter, it will highlight and activate the entire column.
2. Access the remove column properties box. To access this menu, simply right-click on the highlighted column that you wish to remove. A sub-menu will open.
3. Select the remove column attributes. Scroll to “Delete” in the column properties sub-menu. Left-click on it to remove the column.
4. Save the edited spreadsheet. Make sure to save your file after making any changes by accessing the “File” tab on the command bar and left-clicking on “Save.”

Read more ►

How to Organize in Excel 2007

1. Open your Excel 2007 program. Right click the bottom of the program where is says 'Sheet 1.'
2. Click 'Rename' to give the worksheet a specific name. You can also rename the other available sheets or add more sheets by clicking the icon next to 'Sheet 3.' Multiple sheets allows you to organize different sets of data within the same spreadsheet, such as expenses and payments.
3. Type in the headers for your columns or rows to start adding data. For example, you might have separate columns for various types of expenses. You can add each expense to different rows along with the cost to organize the information more effectively.
4. Move your data into a table for even more organization power. Highlight the data you want in the table. Click 'Format as Table' from Styles. Choose a table layout. Your data will then be moved into a table, which makes sorting much easier.
5. Sum up totals for expenses, payments and other information with numbers or money easily. Highlight all the columns or rows you want to add up. Highlight one extra cell. From 'Formulas,' click 'AutoSum' and the numbers you highlighted will add up on the last cell.

Read more ►

How to Remove All Hyperlinks in an Excel Spreadsheet

1. Open the spreadsheet you want to remove all the hyperlinks from.
2. Hit the “Alt' and “F11” keys to get to the Visual Basic Editor.
3. Click “Insert” on the task bar. Click “Module” from the drop-down menu. A box opens.
4. Paste the following command into the module box.Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
5. Click “File” and “Close.” The macro is now ready for use in Excel.
6. Return to the Excel spreadsheet. Click “Tools” on the spreadsheet toolbar. Click “Macros' from the drop-down menu.
7. Click “RemoveAllHyperlinks” and then the “Run” button. The hyperlinks in the document disappear.

Read more ►

How to Extend the Trend Line in Excel

1. Open Microsoft Excel 2010.
2. Click the 'File' tab and select 'Open.' Select your file and click the 'Open' button.
3. Right-click the trend line in your spreadsheet file and select 'Format Trendline' from the menu.
4. Locate the 'Forecast' section under the 'Trendline Options.' Type a value in the 'Forward' field to extend the trend line forward, and type a value in the 'Backward' field to extend it backward.
5. Click the 'Close' button.
6. Click the 'Save' icon at the top of the window to save the changes to the file.

Read more ►

How to Repair an Excel 2003 File

1. Open Excel by clicking on the 'Start' button and then 'All Programs,' 'Microsoft Office' and 'Microsoft Excel 2003.' The program will launch on your screen.
2. Click on 'File,' 'Open' to display the 'Open' dialog box.
3. Browse to the location of the corrupted Excel file and then click on it once to select it.
4. Click on the down arrow next to the 'Open' button at the bottom of the window to view a list of additional options.
5. Click on 'Open and Repair.' A dialog box will display on your screen, prompting you to decide whether you want to attempt to repair the document or extract the data only.
6. Select 'Repair' to attempt to open and repair the document. The system will alert you if the repair fails. In this case, repeat the steps, choosing 'Extract Data' instead of 'Repair' when prompted. This process will extract the data and formulas from your Excel workbook without retaining any of the formatting.

Read more ►

How to Change Cursor Highlight Cell Colors in Windows Excel 2007

1. Open the MS Excel workbook that you want to edit.
2. Click on the 'downward-pointing arrow' next to 'Fill Color' under the 'Font' group. The 'Font' group is a group of font-editing buttons on the Office Ribbon (the main toolbar). When clicking on the 'downward-pointing arrow' button, a drop-down color menu is displayed.
3. Click any of the colors listed under 'Theme Colors' or click 'More Colors.' Click a color in the hexagonal color diagram and click 'OK.' The color that you select will be set as the new highlighting color when you click the 'Fill Color' button under the 'Font' group. Click any cell and then click the 'Fill Color' button to highlight the cell with the color you selected.
4. Click on a cell with a highlighting color you want to apply to other cells, double-click on 'Format Painter' under the 'Clipboard' group and then click any other cell to apply the same highlighting color to the cell. Continue clicking cells to paint them with the selected highlight color and press the 'Escape' key when you are finished highlighting.

Read more ►

How to Use Auto Complete in a Combo Box in Excel 2003

1. Launch the Microsoft Excel program on your PC computer and open the spreadsheet file in which you want to add a combo box.
2. Enter the values you want to use in the combo box anywhere on your spreadsheet. Use a separate cell for each value, but keep them together in a single column so that you can reference them later.
3. Go to the 'View' menu at the top of the window, expand the 'Toolbars' submenu and select 'Forms.' This will add several new elements to the main Excel toolbar, including the combo box.
4. Select the 'Combo Box' icon in the toolbar and then click on the area of your spreadsheet where you want to place the combo box item.
5. Hold down on the left mouse button and drag your pointer to the right to extend the size of the new combo box.
6. Right-click on the combo box you just created and choose the 'Format Control' option.
7. Fill in the 'Input Range' field with the location of the cells where you entered the desired autocomplete values in Step 2. Use a colon symbol to separate the first cell in the column from the last cell.
8. Press the 'OK' button to save the settings. As you begin to type in the combo box, Excel will autocomplete the text based on the values you have previously configured.

Read more ►