Finders Keepers
You’ve searched high and low for that specific information on that particular web site, but you don’t want to add it to your Favorites because the list is so long it can hardly be considered a “favorites” anymore (whew!). So, what do you do?
I say, you found it, so keep it!
You can save it as a Web Archive. This little trick lets you save the must-have… Continue reading
Single Worksheet Templates
We’ve discussed templates in MS Excel that were entire workbooks, but… have you ever wanted just a single sheet for a template?
You know, instead of opening a workbook template, just insert a sheet into another workbook?
Sounds like a good idea to me! After all, I’m willing to bet that someone out there uses a template to copy and paste a single sheet into workbooks already… Continue reading
Q:
I have lots of stuff in my Favorites menu. It seems like I have to do a lot of scrolling just to find what I’m looking for. Do you of a quicker way?
A:
I have WAY too many favorites too, so I know where you’re coming from. You click your Favorites folder and hundreds of web sites drop down. Well, here’s… Continue reading
No More Splitting
Here’s the scenario: you’re working on a table in MS Word and suddenly a row splits in two—that is—part on one page and part on the next page.
You’re looking this new development over, all the while thinking to yourself: “this just won’t do—the topic in each row really can’t be split apart”.
At this point you’re trying to come up with a solution. You need an… Continue reading
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
