Learn about how to manipulate MS Office AutoShapes using one simple control. Continue reading
I see this all the time at school – students are forever giving me tables set up in spreadsheets where the table title is either left justified over the table columns or placed haphazardly “sort-of” in the center of the table. They just love to try to center titles by using a bunch of spaces or by putting the title in a cell that’s as close as they could get… Continue reading
If you’ve ever looked at a hard copy of a document and wondered “Now where did I save this?” then you want to know this one.
One of the most sure-fire ways to ensure that you know how you saved the file is to include the path (file location) and file name in the header or footer of the document.
Have you tried to put page numbers in your Writer documents yet?
Did you find it?
If not then I’d bet that you’d like to know where OpenOffice has placed them so let’s take a look at that today.
First, we usually want our page numbers in either a header or footer… so you can insert those through the Insert menu.
Now, with your cursor in the header or footer… Continue reading
Have you ever put together a PowerPoint presentation where it seems that the slides have way too much unused space on the left and right sides?
I know that when I put together presentations for teaching my students tax forms the slides begin to look like this:
In order to have the whole form from top to bottom… Continue reading
As I’m sure most of you know, when working in MS Excel, Ctrl + Home will take you to the upper left corner of your worksheet (cell A1).
Do you know where Ctrl + End will land you?
Let’s all hope it’s not in the bottom most corner of a worksheet! Have you ever scrolled out right or down to find out just how big Excel makes its worksheets?
Well… Continue reading
Those of you who have experience with Microsoft Office should recognize the term “WordArt”.
It was that handy little feature that allowed you to take any text and really turn it into a piece of art.
If you’re now switching to OpenOffice then you may have wondered a time or two if there is an equivalent feature available.
Of course there is… you just have to know what it’s called:… Continue reading
Yep, you read that correctly… after all the pain of Office 2007 “Ribbon shock” and our inability to customize even the smallest amount of the Ribbon we’ve finally caught a break!
Microsoft has included in the 2010 Office Suite the ability to do some (and I emphasize “some”) customization of the Ribbon.
Now, I don’t even have to ask this time – I know… Continue reading
OpenOffice: It’s All About The Keys
Many people much prefer using key combinations over the mouse when completing their work.
Some just find that it takes way too much time to keep removing their hand from the keyboard to accomplish something with the mouse. Mostly I agree, it seems that 9 times out of 10
The other day we took a quick look at the difference between Office 2007 and Office 2010 when it comes to easily saving a file in PDF format.
Today I’d like to look at a way you may even like better – and this one works on both versions!
What we’re going to do is to look at
In spite of what it sounds like we’re not discussing a murder mystery or some Nancy Drew book… today we’re discussing a quick switch between upper and lower case characters.
“Characters?” you may ask.
Yep – that’s the term that OpenOffice uses instead of font.
So when you’re looking through things trying to find something you won’t see commands to format… Continue reading
Looking for another way to say it?
Need a synonym? Need it quick?
Well, then I have a little treat for you…
Next time you need a quick word, try a right-click.
Yep, that’s all it will take. Just right-click over the word for which you need the synonym. (You don’t have to select the word – just… Continue reading
Previously we’ve talked before about the templates available at OpenOffice.org – which is really a great thing – but what if you’re looking for more than they have to offer?
Maybe you saw a presentation done in MS PowerPoint that had a really great design and learned that it was a free template download… but… you’ve got OpenOffice Impress so does that mean that you’re… Continue reading
I was doing a spell-check the other day and I accidentally added a word that wasn’t spelled right to the Dictionary. Can I get rid of it or do I just watch for the misspelled word?
Hi, Marvin, thanks for asking about this – I hadn’t ever even thought about it. I’ll bet my dictionary couldn’t win a lot of… Continue reading
Did you know that there’s a faster way to enter cell references in Excel formulae? I’m talking about a way that doesn’t involve typing cell addresses. Did you know?!
Interested? (Yeah, I thought you might be!)
Here’s the scoop.
Next time you’re entering a formula and you get to a cell reference (like A5, for example), instead of typing A5, use… Continue reading
As I was perusing my Office 2010 SmartArt gallery I noticed that there were quite a few new designs which got me to thinking…
When we create SmartArt and then save the file to use in Office 2003 or earlier it becomes a static picture in the file. No more editing – what you saved it as is what you’re stuck with until you can get back… Continue reading
Many people I know dislike spreadsheets because they are “math”… which to them is way worse than “lions and tigers and bears, oh my!”
So, in their never-ending endeavors to keep their minds free of math they tend to use a lot of tables to organize information.
Most people when creating tables automatically go to the Insert menu, Table choice and then use the… Continue reading
If you’re a fan of the SmartArt feature in Office 2007 then you may have experienced the frustration of trying to select a single shape in the diagram.
Or worse yet, when you’re looking to select several shapes and you have the Ctrl + click thing down, too bad you keep accidentally clicking on something already selected… which deselects it, of course.
At this… Continue reading
Previously we discussed the Gallery, the place where where OpenOffice keeps it’s pictures. Today we’re going to look at how to add your own collection to the Gallery.
After all, it’s much easier to grab a picture from the Gallery then it is to repeatedly use the Insert menu, Picture, From File over and over again. I have no desire to keep locating the pictures each time… Continue reading
I now have Office 2010 and it’s time for me to explore… I just love that part.
What’s the first change you noticed?
OK – if you came from a version prior to the 2007 Office Suite then you had the whole “Ribbon shock” that lots of people went through the first time they had to deal with it… Continue reading
Do you have a PowerPoint presentation containing slides that you just wish you could make into your screensaver?
Maybe you had a presentation sent to you containing a bunch of pictures of the grandkids.
Or maybe you’d just love to create a screensaver out of a variety of your favorite quotes.
Either way, if it’s in a PowerPoint presentation, we can… Continue reading
Have you tried to insert a picture or two into a document yet?
I bet you went to the Insert menu, Picture choice and then found this:
From file or from a scan?
Doesn’t OpenOffice have something to offer?
Yes – it does but it’s not there that you’ll… Continue reading
OpenOffice Impress: To Wizard or To Not Wizard
When you start your first presentation in OpenOffice Impress you’re going to be faced with a decision:
Use the presentation wizard or not?
Basically, do you want help setting a few things up before the presentation is created or do you want to start with a completely blank sheet?
If you choose to use the wizard then you’ll simply need to follow… Continue reading
Sometimes we’re looking to lock down a file in order to keep others out… not just a “don’t change it” thing but more of a “none of your business” situation.
In the vein of “better safe than sorry” I believe that it’s a good idea to know how to make that happen, just in case you find yourself needing to keep others out of sensitive information.… Continue reading
So, have you seen this pop up from the corner of your eye yet?
That’s your friendly neighborhood Help Agent, compliments of the people at OpenOffice.org.
He’s a crafty little guy whose only purpose in life is to help you out – specifically, he’ll appear when he thinks that you’re completing a task where you may need some assistance.… Continue reading
Recently a reader wrote in asking if formulas can be used in Word 2007 tables – good question!
The “good” answer is YES they can, and while some may question the reasons you might want to use Word for calculations I can see your point.
If the primary purpose of the table is to present non-numerical information and you simply need one or two… Continue reading