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, I would suggest that you go to the affected cells that needs to be split to another page and split the cell and/or add a new row. Otherwise, you can only export one worksheet at a time. If this is a document that you’ll be using frequently, you should probably take the time to paste it into Word or save each worksheet as an individual file and then insert the files as objects into Word. If anyone has any other suggestions, please advise.
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 open Excel from the Start button and find a file from Excel browse window. This allows two instances of Excel running which you can manually arrange Windows or use Windows shortcuts (Windows Button plus right arrow to lock on right side of screen and Windows Button plus left arrow to lock on left side of screen)
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).
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 the originator of this file wanted to have the spreadsheet print on one page only. If you change it to 100%, the font will stay at 14 point. However, your worksheet may print over more than one page.
You’ll also notice if you click the slanted arrow in the lower right of the Page Setup grouping, you’ll see more options. Clicking on the Sheet tab will indicate if a row is repeated at the top. If so, delete the item and this will remove the rows to be repeated at the top of each page, and you can add headings manually where you want them.
Question: Can I restore a message after it has been deleted from my deleted items folder?
Answer: In Outlook 2010, you can right click on the deleted items folder and from the Folder ribbon tab, select Recover Deleted Items. With OWA or Outlook 2011, you can right click on the Deleted Items folder and select Restore Deleted Items. You will see messages that are available to recover (deleted from last 4 days) and click the Recover icon at the top left. The messages will re-appear in your deleted items folder. For more information, click here:
Question: I added a field to my Access table but when I tried to modify a query and add that new field, it didn’t appear? What is happening?
Answer: If your query came from a table, then you should be able to add the field. If the query was actually created from another query, then that could be why the field doesn’t appear on the list. In looking at the query, it was coming from a query by the same name as the table. When we started a brand new query, the new field appeared on the field list.
Question: I am using Access 2010 and am adding criteria to a query. Every time I enter F or M for the Gender field up pops autocorrect function commands and if I press enter it replaces the F or M with a function, which I don’t want! I have found I can press the space bar after and it will keep the F. This happens all the time for other fields too, and I want to turn it off!
Answer: In checking online discussion groups, it appears this is a new “feature” of Access 2010, and there is no way to disable it. One person suggested placing quotes around the entry, but instead of typing 1 letter, you end up typing 3. Maybe if many people continue to complain about this “feature” Microsoft will make a way to disable it. If anyone learns of a way to disable it, please let me know!
Question: I have a table covering two pages which will be printed front and back. The outside border of the table needs to line up on both sides. I have the tables the same size and the same margins and have tried to move them around so they line up, but they are always off about 1/4 inch. Can you help?
Answer: If you select the table and go into the table properties from the Table Tools Layout tab in the ribbon, click Center align. The table should now be centered on both pages. If you have more than one table, you would need to Center align each one.