Breaking Links in Excel

I was recently presented with an Excel file which displayed a message every time it was opened indicating that it contained links to other files. I was assured by the owner of this spreadsheet that all links had been removed. Thanks to officearticles.com for helping me to solve the problem: Open the file with the [...]

Filed under: TipsNTricks, Tutorials | Posted on April 15th, 2008 by MikeT | No Comments »

Changing cAsE in eXcel

In Word, selecting some text and pressing Shift+F3 will change the case of the selected text. It works on a cycle through the following – lower case , CAPITALS or Sentence Case. Excel does not have this feature but you can select a cell and use =UPPER, =LOWER or =PROPER. The format is =FUNCTION (CELL) [...]

Filed under: TipsNTricks, Tutorials | Posted on April 15th, 2008 by MikeT | No Comments »

Subscribe To My Blog

Links

More Mike…

Categories

Archives

Copyright © 2010 mthomas.co.uk. All rights reserved.

Tech Blue designed by Hive Designs • Ported by Free WordPress Themes and Linux Web Hosting