1. Top 10 Help Pages
  2. Recent Additions
  3. Instructions
  4. Show All Help Pages
  5. Contact Information

  1. Atomic Learning
  2. CedarInfo
  3. CedarNet
  4. Google Apps
  5. Google Calendar
  6. Google Drive
  7. Google Groups
  8. Google Mail
  9. Google Sites
  10. Microsoft Excel
  11. Microsoft Outlook
  12. Microsoft PowerPoint
  13. Microsoft Word
  14. Miscellaneous
  15. Moodle
  16. Other Software
  17. Personal Computers and Devices
  18. TechStop
  19. University Hardware
  20. Windows

Computer Help Category Archives

How to Import Excel Data into a Word Table

how to insert an excel table in a word document

This help page will show you how to import data from Excel into a Microsoft Word table.

  1. Open a new or existing document in Microsoft Word.
  2. Click the "Insert" tab > Locate the "Tables" group.
  3. Select the "Table" icon > Choose the "Insert Table..." option.
  4. Set the "Number of columns," "Number of rows," and "AutoFit behavior" to your desired specifications > Click [OK].
  5. Open the Excel file and use your mouse to select the data you wish to import.
  6. Right-click on the range of cells you have highlighted and select "Copy."
  7. Switch back to Word and highlight the table cells where you want to import the Excel data.
  8. Right-click on the Word table and click the option you want under "Paste Options."

Note:

If you select the table in Word, the "Table Tools" tab will appear at the top of the page. Use this tab to format the "Design" and "Layout" of the table to meet your preferences.

 

Keywords: transfer, convert, change, Excel to Word, export, move, copy, import, Excel 2007, Word 2007, Microsoft, micro soft

Posted in Computer Help

How to Repeat Excel Spreadsheet Column Headings at Top of Page

 how to repeat excel spreadsheet column headings at top of page

Use this feature if you would like a title row (or rows) to print at the top of every page of your data in Excel.

Note:
If you want column headings to remain at the top of your sheet when scrolling within a spreadsheet, you will need to freeze the top row.

  1. Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles].
  2. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon.
  3. Click and select the row you wish to appear at the top of every page.
  4. Press the [Enter] key, then click [OK].
  5. Select File > Print > "Show Print Preview" to see what the printed spreadsheet will look like.

Note:
If the [Print Titles] button is locked (greyed out), it may be because you are currently editing a cell or you have chart selected. If the "Rows to repeat at top" spreadsheet icon is locked, it may be because you have more than one worksheet selected within your workbook. To unclock either button, you can also try clicking [File] > "Print" > "Page Setup."

Keywords: header, formatting, excel

Posted in Computer Help

Excel: How to Parse Data (split column into multiple)

how to parse data in Excel spreadsheet

In Excel (2016, 2013, 2010) it's possible to parse data from one column into two or more columns. And you can do it in a few simple steps. Suppose column A contains "Last Name, First Name". Follow these steps to split the data from column A into a "Last Name" column and a "First Name" column. No cutting and pasting necessary!

Open the Excel spreadsheet containing the data you want to split, then:

  1. Highlight the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column.
  2. Click the “Data” tab in the ribbon, then look in the "Data Tools" group and click "Text to Columns." The "Convert Text to Columns Wizard" will appear.
  3. In step 1 of the wizard, choose “Delimited” > Click [Next].
  4. A delimiter is the symbol or space which separates the data you wish to split. For example, if your column reads “Smith, John” you would select “Comma” as your delimiter. Select the delimiter within your data.
  5. Check the box next to "Treat consecutive delimiters as one."
  6. Click [Next].
  7. Under "Column data format," choose "General."
  8. Click the red arrow/spreadsheet icon at the far right of the "Destination" text box.
  9. Highlight the columns you wish to contain the split data by clicking the letters directly above the columns (you can choose columns from anywhere within the spreadsheet). Or, manually click and drag to select the sells you wish to contain the split data.
  10. Click the red arrow/spreadsheet icon once more to return to the wizard.
  11. Click [Finish].

Note:
If the data you wish to split does NOT contain a delimiter (dash, comma, tab etc.) to separate the data, select "Fixed width" within the first step of the "Convert Text to Column" Wizard. This option allows you to manually created divisions within your data by dragging a break line.

Keywords:  split columns, parse data, split cell, separate information

Posted in Computer Help

Dual Screen Setup for Desktop Computer Monitors

 dual screen setup for desktop computer monitors

The following instructions will show you how to configure two monitors to display a single work space.

Set the Primary and Secondary Monitor

  1. Right-click on your desktop and select "Display". At the top of the resulting dialogue box, your available monitors appear as blue, numbered boxes. Each box represents a monitor (e.g. box "1" corresponds with the left monitor and box "2" corresponds with the right monitor).
  2. From the display, select the monitor you wish to be your main display.
  3. Check the box that says "Make this my main display." The other monitor will automatically become the secondary display.
  4. When finished, click [Apply].

Set the Monitor Resolution

  1. Right-click on your desktop and select "Display". At the top of the resulting dialogue box, your available monitors appear as blue, numbered boxes. Each box represents a monitor (e.g. box "1" corresponds with the left monitor and box "2" corresponds with the right monitor).
  2. From the display, select the monitor you wish to adjust.
  3. Click the "Advanced display settings" link (located at the bottom of the dialogue box).
  4. Click the "Resolution" drop-down menu and select your desired resolution.
  5. When finished, click [Apply].

Set the Monitor Display Style

  1. Right-click on your desktop and select "Display". At the top of the resulting dialogue box, your available monitors appear as blue, numbered boxes. Each box represents a monitor (e.g. box "1" corresponds with the left monitor and box "2" corresponds with the right monitor).
  2. Click the "Multiple displays" drop-down menu and choose from the following options
    • Select "Duplicate these displays" to enable the secondary monitor display to mirror the primary monitor display.
    • Select "Extend these displays" to expand your desktop across each monitor.
    • Select "Show only 1" to disable monitor "2" and only use monitor "1".
    • Select "Show only 2" to disable monitor "1" and only use monitor "2".
  3. When finished, click [Apply].

Set the Monitor Position

  1.  Right-click on your desktop and select "Display". At the top of the resulting dialogue box, your available monitors appear as blue, numbered boxes. Each box represents a monitor.
  2. If you want the mouse to scroll left to right across your monitors, make sure monitor "1" is on the left and monitor "2" is on the right.
  3. To change the monitors' position, click, drag, and place the blue, numbered boxes to your preferred position. If you are unsure which monitor is "1" or "2," click the "Identify" link. The assigned monitor number will then appear on each monitor's screen.
  4. When finished, click [Apply].

Keywords: monitor, screen, dualscreen, dualmonitor, dual screen, dual monitor, setup, set up.

Posted in Computer Help