99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
More Tips From Excel's Rarely Used File
Tue 23rd February 2010
You may want to convert numbers into Roman numerals and, if this is your bag, Excel can do this very easily. To convert numbers to numerals for the current year, for example, simply type =ROMAN(2010) in the formula bar, and you will see that the numbers convert to MMX. It should be noted, however, that when you create these Roman numerals Excel converts them to text values and they cannot be used in calculations.
How about changing the orientation of your worksheet? (This tip only works with Excel 2002 & 2003). If you want to your A1 cell at the top right of your screen, go to Tools, Options and in the dialog box click on International. On Default Direction click Right to Left. The changes won't happen immediately, but the next workbook you open will have the A1 cell in the top right corner.
Have you ever noticed that when Excel thinks you have made an error (and it may be the case that what looks like an error to Excel is actually intended by you) it flags the errant cell with a small green triangle in the top left corner. You can remove these very easily by doing the following:
In Excel 2002 & 2003 choose Tools, Options, and select the Error Checking tab. Uncheck the Enable Background Error Checking box and hit OK. Done.
For Excel 2007 click Office then Excel Options, then click Formulas. Uncheck the Enable Background Error Checking box and click OK. And there you go; all your errors from now on will go unnoticed.
Those scroll bars at the bottom and right side of the worksheet can be removed if you so wish. For all pre-2007 versions of Excel, go to Tools, Options and select the View tab from the dialog box. In the area marked Options, uncheck the Vertical Scroll Bar box and the Horizontal Scroll Bar box and click OK. Now you must move through the worksheet using the cursor control keys. This action does actually serve a useful purpose in that it does make maximum use of the screen space.
As I said in the first of these articles, although you may never have cause to use any of these tips, trying them out is a useful way to gain a better understanding of how Excel works. These totally different tips also serve to demonstrate the vast range of Excel's capabilities, something that would perhaps be best got to grips with on a training course.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
PSI CRO AG
Influencing & Persuasion
Graham was great once more. He really makes the room comfortable and as a fairly new hire, I enjoy having someone who helps me open up.
PSI CRO AG
Group Leader Biostatistics
This course was very inspirational and motivating course for me! Thanks a lot to Graham
Business Development Director
PowerPoint Intermediate Advanced
Great trainer. Patient and knowledgeable.
Will definitely help with my role now and in the future