• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Archives for Office

Automatically Add the Chapter Heading into a Documents Header

If you are working on a long document you may want to display each chapter heading in the relevant header. For example, to display chapter 1 in the header for pages 2 – 15 and then chapter 2 for pages 16 – 21 and so on.

You may have previously thought that this technique would require inserting multiple section breaks and using the Link to Previous option you get with Headers and Footers. This is how most training sessions and online tutorials approach this.

However, Microsoft Word contains a fantastic feature that will enable you automatically insert each chapter heading into the relevant page header. This also means that the header can be updated when content is moved or changed. And all without a single section break.

To do this you need to insert the StyleRef field into the page header.

[Read more…] about Automatically Add the Chapter Heading into a Documents Header

Change the Default Paste Setting in Word

When pasting data from another program such as the Internet into a Word document, it is normally a good idea to paste as unformatted text. This removes any source formatting from the copied text.

This can be achieved by using Paste Special rather than a normal paste or Ctrl + V. However if you regularly copy data from the Internet into a Word document you might find the need to use Paste Special each time quite irritating.

Fortunately, Word provides a way for you to change the default paste setting for when pasting data between programs.

[Read more…] about Change the Default Paste Setting in Word

Awesome Microsoft Visio Shortcuts

Shortcuts will save you time when creating your Visio diagrams that you could spend elsewhere. Alot of the features and commands in Visio are easier to access for fans of keyboard shortcuts and other speedy tactics.

Listed below are my favourite Microsoft Visio shortcuts.

[Read more…] about Awesome Microsoft Visio Shortcuts

Change Presentation Slide Numbering to Start From 0

When inserting slide numbers at the bottom of each slide of a PowerPoint presentation, it is common to remove the slide number from the Title slide. However the numbering begins from number 2 on the second slide.

If you want the slide numbering to start from number 1 on the second slide. You first need to remove the slide number from the Title slide, and then set the presentation slide numbering from 0.

[Read more…] about Change Presentation Slide Numbering to Start From 0

Outline Tasks in Microsoft Project

Outline tasks in Microsoft Project to organise your list of project tasks and make it more readable. Creating an outline requires indenting tasks. The indented tasks are known as subtasks and the task above them a summary task.

These groups of tasks can then be collapsed and expanded making the list of tasks easier to work with.

There are many approaches to organising the tasks in your project. You may decide to group tasks by the phases of the project, the teams who will be doing the work, or in the case of manufacturing a product the different parts that make up the product.

As well as making the list more readable and easier to use, the summary tasks also provide project data at a glance. Information such as the start and finish date of that project phase, its duration, cost and variance is made easily available.

[Read more…] about Outline Tasks in Microsoft Project
  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • Interim pages omitted …
  • Page 12
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·