K2 Office Tips Header
 Volume 5, Number 12
 December 1, 2010
In This Issue 
Excel Tips

 

Quick Link
 Technology Tips Video
 
OutlooktopIn This Issue
 Outlook Tip

Quick Links

 

Previous versions of Office Tips

 

Follow me on Twitter

2010 is winding down and on behalf of the K2E team, I want to extend to all of our readers Seasons Greetings and best wishes for a prosperous 2011. We look forward to continuing to provide your with our monthly office tips.


This month we have added another new feature, and that is our new UTube Excel video tip. This will now be a regular monthly feature as we continue to enhance our tips.


A reminder again that if you are short of CPD credits you should check out our Excel Self Study courses. We now have 4 two hour Excel Tips courses that cover over 50 useful Excel tips in each course. To get information about these courses go to

http://k2ecanada.coursehost.com.

As usual I would welcome your comments at alan@k2e.ca.


Sincerely,

Alan Salmon

Excel Tips


Summary: There are times when you want to only copy the visible data in a worksheet.  Here's how to do this.

  

An example of this is when you need to copy SubTotals that have hidden rows and columns. A normal copy and paste will include the hidden data.


Here's the steps:

  • Select the range of cells
  • From the Home tab, in the Editing group, select Find & Select
  • Under Select, select Visible cells only
  • Select OK
  • On the Home tab, in the Clipboard group, select Copy
  • Activate the worksheet you want to copy the data to
  • On the Home tab, in the Clipboard group, select Paste
 
Excel2Tracing Cells that are Preceding or Dependent on the Current Cell
 
Summary:  When are you auditing the formulas in a workbook, it is often useful to understand how the data flows from cell to cell and worksheet to worksheet. Here's how to use the auditing tools in Excel to show you how the cells are connected:

Some workbooks can get very complicated, with many cells relying on other cell calculations to deliver information. A change in one cell can have dramatic effects on the results in your workbook.

 

Excel's formula auditing tools can help you investigate the flow of data. Here's how to trace cells that are preceding or dependent on the current cell

To trace all cells that are preceding:

  • Select the desired cell  
  • From the Formulas tab, in the Formula Auditing group, select Trace Precedents
  • If the Precedent cells are found on another worksheet, you will get a dotted line
  • Double click on the dotted line, select the reference, and click on OK

 To trace all cells that are dependent: 

  • Select the desired cell
  • From the Formulas tab, in the Formula Auditing group, select Trace Dependents

To remove the arrows

  • From the Formulas tab, in the Formula Auditing group, select Remove Arrows 
  • 

Excel3Multi Level Sorting
 
Summary:  There are times when you want to sort data in a worksheet based on multiple criteria. Here's how to use the Sort function to handle this task:

To sort on multiple criteria such as Last Name, First Name and e-mail address you need to do the following:

  1. Select any cell with the dataset you wish to sort
  2. From the Home tab, in the Editing group, select Sort & Filter
  3. Select Custom Sort
  4. Select the drop down arrow in the Sort By box and select the desired column
  5. Select the drop down arrow in the Sort On box and select the desired option
  6. Select the drop down arrow in the Order box and select the desired option
  7. Select the Add Level icon to specify the next sort column
  8. Repeat steps 3 to 5
  9. Repeat steps 6 and 7 for subsequent sort columns
  10. To change the order of the sort, use the Arrow buttons to moive the sort items up and down
  11. Select OK
  12. 

 Back to top



Word Tips

Word1Figuring Out Paragraph Formatting

  

Summary: There are a variety of ways to align paragraphs in Microsoft Word. In this tip we'll cover the four ways of aligning your text in a paragraph.

 

A basic step in laying out paragraphs in Word is defining the alignment of each paragraph. There are four types of paragraph alignment available to you.

  • Left Aligned - All of the lines in the paragraph start at the left margin. The text will not line up with the right margin. Another name for this type of formatting is "ragged right"
  • Centre Aligned - The lines in a paragraph are centred between the left and right margins. There is no alignment with either the left or right margins.
  • Right Aligned - All of the lines in the paragraph start at the right margin. The text will not line up with the left margin. Another name for this type of formatting is "ragged left"
  • Justified - All of the lines in a paragraph are expanded to fill out the lines so they butt up against the left and right margins
You can change the paragraph alignment by using the tools available on the Home tab of the ribbon or on the Formatting toolbar of by displaying the Paragraph dialogue box.


Summary: A There are times when you may need to delete a header or footer from a document. Here's how to do this: 

To delete the headers or footers in a document follow these steps:

  • Place the insertion point in the section that has the header or footer you want to delete.
  • Click on the Insert tab of the ribbon.
  • In the Header & Footer group, select either Header or Footer, depending on which one you want to delete.
  • Word will display a drop-down list of options.
  • Click Edit Header or Edit Footer. Word will display the header or footer and the Design tab of the ribbon.
  • Select the contents of the header or footer.
  • Press the delete key or Ctrl+X.
  • On the Design tab of the ribbon click on Close Header and Footer.

Outlook Tip

Outlook2Moving Recurring Appointments

  

Summary:  In older versions of Outlook, when you dragged a recurring item to a new calendar folder, the recurrence was lost and only the current appointment was moved to the new calendar.

 

That problem is fixed in Outlook 2010. When you drag recurring appointments to a new calendar folder, you get the option of moving the series or moving just the occurrence.

Back to top

 

K2 Enterprises Canada is a leading provider of professional development seminars for the Canadian accounting world.

Each month we publish this free Office Tips e-mail newsletter. These tips will save you time and enhance the appearance of your Office files.

To subscribe to our K2E Canada newsletter send an e-mail to

alan@k2e.ca  with "Subscribe to newsletter" in the Subject. 
Your information is always kept secure and never shared
 
Alan Salmon
President & CEO
K2 Enterprises Canada
647-722-4741