IT Services

IT Services > Office 2007 > Frequently Asked Questions

• IT Home
• Wireless
• Mobile Computing
• Off-campus Access
• Lboro Visiting Other HEIs
• Academics Visiting Lboro
• Office 2010
• Office 2007
  • Office 2007 Introduction Movie
  • Office 2007 Introduction Handout
  • Office 2007 File Compatibility
  • What's New in Office 2007?
  • Where are the commands?
  • Frequently Asked Questions
  • Word 2007 Courses / Factsheets
  • Outlook 2007 Courses
  • PowerPoint 2007 Courses / Factsheets
  • Excel 2007 Courses / Factsheets
  • Access 2007 Courses
  • Project 2007 Courses
  • Publisher 2007 Courses
  • Expression Web Courses
  • Office 2007 Keyboard Shortcuts
• E-mail Addresses and Lists

Office 2007 Frequently Asked Questions

Frequently Asked Questions

1. Some of my meeting request replies go straight into the Deleted Items folder. How can I stop this?

2. How do I make equations which I can edit in Word 2003?

3. How do I set up automatic numbering of headings in Word 2007?

4. Lines or Boxes appear in my Word document. How do I delete them?

5. When I copy an Excel graph into PowerPoint, PowerPoint over-rides the colours I have chosen. What can I do to stop this?

6. I'm teaching, and I want the students to see more of my document - how can I reduce the space taken up by the ribbon?

7. How should I create PDF documents?

8. In Word or PowerPoint images fail to print. What should I do?

9. How do I add Alternate Text to a picture?

10. How do I find the Developer tab?

11. in Word, How do I add the Filename to the Footer (or Header)?

12. I want to place an Access database on a department shared (Network) drive. How do I do this?

13. Advanced features such as Macros no longer work. What do I do?

14. How do I edit PowerPoint Master Slides?

15. How do I export MindGenius 2005 documents?

16. How do I produce logarithmic scales in Excel 2007 graphs?

1. Some of my meeting request replies go straight into the Deleted Items folder. How can I stop this?

   From the menu bar select:

   1. Tools

   2. Options

   3. Email Options

   4. Tracking Options

   5. There is an option Delete blank voting and meeting responses after processing. Remove the tick from this option.

   All replies will now appear in the Inbox.

2. How do I make equations which I can edit in Word 2003?

   On Word's Insert tab, in the Text group click Object.

   

   In the Object dialogue ensure that the Create New tab is selected, and under Object Type select the Microsoft Equation 3.0 option.

   

   Click OK.

   You will be able to use the Equation editor as in Word 2003. The resulting equation will be editable in Word 2003.

3. How do I set up automatic numbering of headings in Word 2007?

   See our automatic numbering of headings web page.

4. Lines or Boxes appear in my Word document. How do I delete them?

   See our Word Lines and Boxes web page.

5. When I copy an Excel graph into PowerPoint, PowerPoint over-rides the colours I have chosen. What can I do to stop this?

   There are actually two things you need to do.

   Firstly you need to stop PowerPoint from applying its Theme to your graph. After Pasting the graph in, click on the Paste Options button which appears at the bottom right of the graph, and select Keep Source Formatting.

   

   Secondly you may need to change the background of the graph from being Transparent - otherwise if you use a Theme with a dark background, the graph may become unreadable. Right-click the chart outside of the chart area or any other objects, and select Format Chart Area. Ensure that Fill is selected in the left-hand menu, and select Solid Fill. Click on the drop-down arrow next to Color and select More Colors (do not select one of the theme colours).

   

   Select white. Click OK and then Close.

6. I'm teaching, and I want the students to see more of my document - how can I reduce the space taken up by the ribbon?

   Click on the drop-down widget to the right of the Quick Access Toolbar (at the top left of the screen with Save, Undo, and Redo buttons), and select Minimize the Ribbon.

   

   Only the tabs of the ribbon will appear - if you click on any of them, the ribbon will ra-appear until you do something (either click in the ribbon or click outside it).

   

   Repeat the process to return to the normal Ribbon display.

7. How should I create PDF documents?

   If Office 2007 documents need to be converted to PDF format, then Adobe Acrobat Professional 9.1.3 needs to be installed.

   Please Note: Microsoft also offer a PDF conversion plug-in (Microsoft Save as PDF or XPS) for Word 2007. This has been found to have problems with formatting and tagging, meaning that it does not meet University requirements. It is therefore recommended that staff users do not use this plug-in for University documents - they should instead purchase a license for Adobe Acrobat from IT.Services@lboro.ac.uk.

8. In Word or PowerPoint images fail to print. What should I do?

   Firstly, especially in PowerPoint, you are advised to include images by use of Insert tab Picture option rather than Copy and Paste.

   Secondly, if this problem occurs, try saving as PDF (Office buton then Save As, then select PDF. Then print the PDF document rather than the Word or PowerPoint file.

9. How do I add Alternate Text to a picture?

   Right-click the picture, in the pop-up menu select Size or Size and Position (depending on the application). In the following dialogue box select the Alt Text tab and enter your Alternate Text.

   You should add Alternate Text for users with a visual impairment. Please note that the Alternate text will be used if you convert the document to PDF or to a web page.

10. How do I find the Developer tab?

    You'll need the Developer tab if you use Templates or Macros / VBA. Other user's won't need it, so Microsoft have "hidden" it; once you switch it on, it will stay on for all office programs.

    Click the Office button, and select Word Options (or PowerPoint or Excel or Access as appropriate) at the bottom of the menu to the right near Exit Word (or Exit whichever application you're using).

    Ensure that Popular is selected in the left-hand menu.

    Ensure that Show Developer tab in the Ribbon is selected.

    Click OK.

    Once you've set this in one of the four Office 2007 programs, you have set it for the other three.

11. In Word, How do I add the Filename to the Footer (or Header)?

    First create the Footer [or edit it if it has already been created]: In the Insert tab click Footer (or Header) and then click Edit Footer (or Edit Header).

    Now the Header & Footer Tools Design tab is displayed. In the Insert group click Quick Parts and then Field. Under Field names select FileName, and then select the required Format (upper or lower case etc.) and decide whether to select Add path to filename. Click OK.

    When you've finished editing the Footer (or Header), click Close Header and Footer in the tab.

12. I want to place an Access database on a department shared (network) drive. How do I do this?

    You must set the Network drive as a "trusted location" for each Access user who will use this database.

    1. From the Office button select Access Options.

    2. Select Trust Center in the left-hand menu, and then click the Trust Center Settings button.

    3. Ensure that Trusted Locations is selected in the left-hand menu.

       

       Ensure that Allow Trusted Locations on my network (not recommended) (near the foot of the dialogue box) is checked.

    4. Click the Add new location button.

       

    5. Use the Browse button to select the Network location. Complete the other entries as necessary. Click OK.

    6. Click OK.

    7. Click OK.

    8. Just to be sure, close and re-open Access before continuing.

    This should now allow the system to work correctly.

13. Advanced features such as Macros no longer work. What do I do?

    Microsoft are (rightly) concerned about computer security, and the problems which could be caused by malicious programmers with macros etc. (especially as macros can be created to run automatically when you open the document / spreadsheet / presentation / database. Rather than allowing macros to work all the time, they use a "Trust Centre". You can determine which files are "Trusted" and the macros etc. will work - elsewhere they will not. Do not make My Documents "Trusted" - make a sub-folder "Trusted" and put "advanced" files which you do trust and you know who created the macro in that "Trusted" folder. Then if you receive an e-mail attachment or download a document from an unknown or un-trusted source you will not put it in the "Trusted" location and any macros will not run and you will be safe from this type of attack.

    1. To set your "Trusted" location, first create a suitable folder.

    2. Then from your Office programme click the Office button and select Word Options (or Excel, PowerPoint, or Access Options as appropriate). In the left-hand menu select Trust Center and then click the Trust Center Settings button.

    3. In the left-hand menu select Trusted Locations, and then click the Add New Location button.

       

    4. Click the Browse button, browse to the required folder, and click OK. You can choose to select Subfolders of this location are also trusted, and enter a Description. Click OK.

    5. Click OK.

    6. Click OK.

    7. Just to be sure, closed and re-open your Office program before attempting to open a file from the "Trusted" location and run any associated macros etc.

14. How do I edit PowerPoint Master slides?

    In the View tab select Slide Master.

    In the left-hand pane you may not be on the first slide thumbnail. Scroll up to the first slide thumbnail (it's larger than the others) and select it.

    Now you can edit the slide master.

15. How do I export MindGenius 2005 documents?

    Exporting Mindgenius 2005 documents to Office 2007 causes an error and does not create the associated Office document. Sadly we know of no work-around.

16. How do I produce logarithmic scales in Excel 2007 graphs?

    Select the chart. In the Chart Tools - Layout tab In the Axes group click the Axes button. Select Primary Horizontal Axis or Primary Vertical Axis as appropriate. Select Show Axis with Log Scale.