ICT Training

University of Saskatchewan

Archive for April, 2011

Excel: Create a chart with two Y-axes and one shared X-axis

Posted in Did you Know? on April 15, 2011 by

MS-Excel_-Create-a-chart-with-two-Y-axes-and-one-shared-X-axis-in-Excel-2007-1.jpg
Taken from techonthenet.com

Excel: Change Formatting With Find and Replace

Posted in Did you Know? on April 12, 2011 by

Have you ever needed to change the formatting of a whole bunch of cells in a spreadsheet?
Of course, if those cells are all in a single column, all you have to do is select the column by clicking the letter heading it, right-clicking and selecting Format Cells.
If there are a few different cells that you need to change and you know exactly where they are, you can hold down the Ctrl key, click on them one by one and then right-click and select Format Cells.
However, if you have cells all over the place that you need to change from one format to another and you have no clue where they all might be, you have another option….

Read more »