How can I create non-repeated numbers between 100 and 300 in Excel? What you’re talking about here is creating a “unique series” – and there’s actually a pretty easy way to do it. Continue reading
How can I create non-repeated numbers between 100 and 300 in Excel? What you’re talking about here is creating a “unique series” – and there’s actually a pretty easy way to do it. Continue reading
Start an Internet search on a word or phrase in your OpenOffice.org file from within your OpenOffice.org program. Two quick steps to the information that you need. Continue reading
The Autofit feature in Calc and other spreadsheet programs is an extremely helpful feature.
You can simply double-click on the right divider line in the column title, and the column will automatically expand to fit the longest piece of data.
But what if you don’t want to fit the longest
If you’ve used OpenOffice.org Calc at all, I know that you’ve found the Delete Contents dialog box.
How could you not?
Every time you select a cell or range of cells and try to clear their contents you automatically hit the Delete button and that annoying dialog
OpenOffice.org Calc: Why Are My Formulas Behaving So Badly?
If you’ve used Excel in the past with any regularity, you may find yourself experiencing some difficulty with formulas – whether creating them in Calc or trying to open an Excel file in Calc.
While I can’t guarantee that I’ve got the answer to your
OpenOffice.org Calc: Taking
A Break for a Little Fun
Ok, so I’ll admit it right
from the start – this tip is for fun, not for productivity…
But who’s not for a little
fun once in a while?
Buried within the code of
OpenOffice.org’s Calc program is a favorite game from days gone past.… Continue reading
OpenOffice.org Calc: Using the Function List without Opening the Function Wizard
Sometimes you know what you want to do with your data, but you just can’t seem to remember the name of the function that does what you need.
If you open the Function Wizard (which is basically a dialog box for inserting functions) via the Insert menu, you’ll find that while it… Continue reading
A really simple thing like altering your hard copy could save you a lot of editing time and prevent quite a few headaches during the time you do spend editing the worksheet. Continue reading