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
Tracing 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
Multi 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:
- Select any cell with the dataset you wish to sort
- From the Home tab, in the Editing group, select Sort & Filter
- Select Custom Sort
- Select the drop down arrow in the Sort By box and select the desired column
- Select the drop down arrow in the Sort On box and select the desired option
- Select the drop down arrow in the Order box and select the desired option
- Select the Add Level icon to specify the next sort column
- Repeat steps 3 to 5
- Repeat steps 6 and 7 for subsequent sort columns
- To change the order of the sort, use the Arrow buttons to moive the sort items up and down
- Select OK
Back to top
|Figuring 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.
|Moving 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