Learn IT

Word Forms

Question: I need help with my Word Form. I was trying to use the tools on the developer tab but am having difficulty getting them to work. Answer: Using Forms in Word can be tricky but very useful. I suggest using the Legacy Form tools, which are found on the Developer tab of the ribbon. Then to see the form work, you need to protect the document for “fill-in forms” I will be giving a hands-on Word Forms class on Thursday, Febr. 20 from 10-11:30… Continue Reading

Exporting multiple Excel sheets to Word

Question: I have an Excel workbook with multiple worksheets and would like to send it to Word for printing. The main reason is I want it to print as an entire document and spread cells across pages. Answer: Unfortunately, I have not been able to find a way to accomplish that other than copying and pasting the tables into Word. You can, however, print the entire workbook out, but the cells do not break across pages. If you wish to keep the information in Excel,… Continue Reading

View two Excel files side by side

Question: How can I have two Excel files open side by side? When I open another file it places that file in view and my other file disappears behind. I want to have two different instances of Excel open. Answer: One way is to open both files after having Excel open and select View > Arrange All and select side-by-side. You can also open one or both files from Windows explorer or My Computer, or open one file by double clicking on it and then… Continue Reading

Technical training for off campus UNMC employees

Question:  I recently started working at the College of Dentistry in Lincoln.  I would love to take advantage of the training opportunities you offer. Answer: I no longer travel to the other campuses because there are many good online resources, and off-campus UNMC employees who work at other campuses may be eligible for technology training at those campuses:, UNL, UNO. UNK You will also find several of our courses already available on some recordings (from http://www.unmc.edu/its/class_handouts.htm).

Changing Excel page layout options

Question: I have a spreadsheet which has 14 point font, but when it prints out the text is much smaller? Also, I am trying to change page headings. I need to change the heading on subsequent pages, but not the first. Someone else set up this worksheet. How can I do this? Answer: If you click on the Page Layout tab, you will probably find that the worksheet is scaled less than 100%. The width or height may say automatic or 1 page, meaning that… Continue Reading