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 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: 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.
Question: When I logged on to Email this morning I found that the home menu was missing. I click on Home and the menu bar reappears, but the minute I do anything else it disappears. Is there something that I did to change the interface behavior? I prefer to seen the menu/icon bars visible at all times.
Answer: More than likely you may have double clicked on a ribbon tab, which “hides” the icons to allow for more space. Just double click on the ribbon tab again, and the icons will re-appear permanently. If you are using Office 2013, you may have inadvertently clicked on the collapse button ^ on the upper right side of the screen (even with the ribbon) that collapses the ribbon. To make it reappear, you can use icon on the upper right of the window next to the minimize _ button to autohide the ribbon, show tabs or show tabs and commands.
Question: I am trying to share my calendar with someone but am getting an error message that says, “Policy does not allow granting permissions at this level to one or more of the recipients. Please select another permission level and send the sharing invite again.” I am using the Share option from the ribbon.
Answer: I normally use the permissions to set up a calendar for use by another, but I tested this out with my calendar and it worked fine. But then I tried it by selecting a name that popped up from my suggested (or recent) contacts. When I tried sharing this way, I got a different type of error message. So I suggested that she try using the Address book to select the name and by golly, that did the trick! So when getting unusual error messages after selecting a name from the popup/suggested names, try selecting from the address book instead. I have noticed similar problems occasionally when sending emails to several people and selecting the suggested names.
Question: I have a long document and on the last page I have a table which has some numbers appearing at the margin which I cannot remove. Can you help?
Answer: This one I have never seen before, but since they could not be deleted and were not bulleted numbers, the only thing I could think was of Line Numbering. Even though there was no line numbering on the rest of the document, I went into the Paragraph options for that line (slanted arrow in the Paragraph group on the Home tab). I clicked on the Line and Page Breaks tab and checked “suppress line numbers,” and the number on that line disappeared. I tried this for the other two places the line numbers appeared, and either checked (and in one case had to uncheck) the option and the line numbers finally disappeared. Very strange indeed!