Table Toppers
Did you know that with just a couple of clicks you could have MS Word automatically repeat your table headings at the top of each page containing the table?
If you answered “No” then you’ll want to take a quick moment to read on because here’s the trick to beautiful table headings.
First thing you’ll need to do is to select the row or rows you want repeated… Continue reading
Quick & Spiffy Tables in MS Excel
Way back in January (January 28, 2003 to be exact) we discussed using the AutoFormat feature of MS Word to give your tables a quick and easy visual “edge”.
(To take a look at the January 28 issue, visit our archives at http://www.worldstart.com/archives)
For those readers who usually use MS Excel for table work… Continue reading
MS Excel Default Font Fun
Do you constantly find yourself changing the font size or type in Excel worksheets?
Is it getting annoying to repeat yourself time after time after time?
I bet a few of you even tried looking in the Format menu for something equivalent to the Font choice found in MS Word.
Didn’t find it, did you?
Nope—that’s because it’s not there.
You can find font choices… Continue reading
MS Excel AutoFilters Part 1—The Basics
Here’s the scenario: you’re working with a spreadsheet and you’re patiently trying to find certain values—maybe you’re looking for the top 3 sales amounts from the list, or all customers who live in a certain city, or all sales made by a certain sales rep.
Whatever it is you’re looking for, you need to know it now—not an hour from now after you’ve sorted… Continue reading
I Thought Filters Were For Things Like Fish Tanks and Coffee Makers?
Have you ever found yourself lost while working with a huge list or set of data in MS Excel?
Did you find that you were continually scrolling through data looking for a particular value?
I bet more than once you caught yourself wishing for a way to just see what you want and get rid of the rest.… Continue reading
MS Excel AutoFilter Part 2—Top 10 and Custom Filters
Let’s get right to it.
To begin I think we should discuss Top 10.
This is pretty much what the name implies—it’s a listing of the top values or percentage of the list.
Let’s investigate further.
After you’ve opened a file and turned on the AutoFilter (Data menu, Filters submenu, AutoFilter choice) pull down one of the AutoFilter lists for a… Continue reading
Q:
How can I shut down two or three open programs quickly, but leave the rest running?
A:
The fastest way to close multiple programs is to hold down the Ctrl key as you click their buttons on the taskbar. Then, right-click (still holding down the Ctrl key) one of those depressed buttons and select Close from the resulting menu. (screen shot compressed so it fits into the… Continue reading
Changing The View – Not The Selection
I’m sure just about everyone has used the arrow keys in MS Excel to move through their worksheet.
But… sometimes you want to quickly zip out to another part of the worksheet to see something without moving the cell selection and losing your current place. What do you do?
I’m betting that many of you take your hands off the keyboard, use the… Continue reading
(Picture note: I keep my taskbar at the top of my screen, so that’s why the screen shots look like they are coming from the wrong direction.)
Do you use your control panel in Windows XP a lot? Are you the kind of person who is constantly “adjusting” things? Well, if you are, then you and I have a lot in common. Here’s a tip that will save us… Continue reading
Must… Have… Even More… Control!
Well, wow! Thanks to all of the faithful readers who wrote in with their favorite way to access their Control Panel.
(While my screen shots are taken from Windows XP, I’ve tried this on Windows 98 and it works the same way!)
1. This first idea involves creating another taskbar in which the Control Panel can live its happy life… Continue reading
