Office Tips

Excel Tips

Overview

RSS
Apr 5, 2011

Using the TCN standard Excel template

When you open Excel in Citrix you will find that it opens with a standard TCN template, you will see the main and sub bar at the top of the document.
This template is setup to use for all your TCN and Project documents.

Jan 16, 2011

Display and use gridlines and guides

You can use gridlines to identify the center of your slide or document and position shapes and objects more precisely.

Dec 28, 2010

Freeze or lock rows and columns

To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.

Dec 22, 2010

Copy Excel data to PowerPoint

There may be times when you want to present your Excel worksheet data in a PowerPoint presentation. You can simply copy selected data in Excel and then use the Paste or Paste Special commands in PowerPoint to insert the data into a document.

Dec 21, 2010

Copy Excel data to Word

There may be times when you want to present your Excel worksheet data in a Word document. You can simply copy selected data in Excel and then use the Paste or Paste Special commands in Word to insert the data into a document.

Dec 9, 2010

Rearrange (transpose) data from columns to rows or vice versa

If data is entered in columns or rows, but you want to rearrange that data into rows or columns instead, you can quickly transpose the data from one to the other.

Dec 3, 2010

Wrap text in a cell

If you want text to appear on multiple lines in a cell, you can format the cell so that the text wraps automatically, or you can enter a manual line break