Microsoft Excel How-to: Define and Name Ranges

excel logoOnce you start getting into some of the more advanced functions in Excel you're going to want to start defining and naming ranges. Doing so makes your functions much easier to write, and much easier for someone else to understand. All that you're doing when you define or name a range in Excel is to select a cell, or a series of cells, and assign a meaningful name to those cells.


Microsoft Word How-to: Print Filename on Every Page Using Autotext

word logoIn a recent article we looked at how to create your own custom template to use in Microsoft Word. One of the things I find very handy is to print the name of the file in the footer of my Word documents. How many times have you looked at a letter, fax, or any kind of printed document and found yourself thinking "I wish I could remember what I called this file, it sure would make it easier to find". You can set up Word to automatically print that information in the footer of every document you save, and it's easy!


Microsoft Excel How-to: Print Header Row on the Top of Every Page

excel logoDo you have a spreadsheet that spans multiple pages, with a descriptive header at the top of the sheet? If you do, you probably want to have the header print at the top of each page. The easiest and fastest way to do this is by setting the Print Titles in the page setup options.


Microsoft Excel How-to: Wrapping Text Within a Cell

content logoThis one comes up all the time. You have data in a cell in Excel, and you want to get it to wrap to another line within that same cell. You're tempted to hit [Enter], just the same as you would if you were using Word or some other text editor. The only problem is that doing that will just take you to the next cell. Instead, you can place a hard return within a cell by holding down [Alt] key, and then pressing the [Enter] key. This will force a new line within that cell.


Microsoft Word How-to: Using Templates

content logoWord templates, often mentioned yet seldom utilized, a true time saving weapon that every computer warrior needs to have in their arsenal. You have to think about 'time saving' exercises within the context of the task itself. If you have a task on which you spend, say, 1 hour per year, it hardly seems worthwhile to invest in a time saving exercise for that task that will itself take several hours to undertake.

On the other hand, there are some tasks which we do repetitively and consistently, on which a time saving exercise can be incredibly worthwhile, even if you need to invest some time initially to set them up. If you can save even a few seconds on these types of tasks every time they are undertaken you may finally be able to have enough time to kick back and enjoy that Starbucks Marble Mocha Macchiato you've been thirsting for. Word templates are just such a time saving weapon, and the good news is that they take hardly any investment in time to get set up in the first place.


Microsoft Outlook How-to: Use Rules to Gain Control of Your Email

content logoDo you remember way back when, in the early days of getting your first computer, it was actually fun to get e-mail? I do, but I have to tell you it seems like it was a long time ago. If you're like the average computer user these days you have multiple e-mail accounts, receiving dozens or even hundreds of e-mails every day. This on top of instant messaging, cell phones, PDA's, and the myriad of other communication marvels that numb our senses on a minute-to-minute basis. It's no wonder we're having trouble keeping up. The good news is, if you're a Microsoft Outlook user, you can set up 'rules' that will help you regain control of your e-mail.


Microsoft Excel How-to: Using Autofilter to Filter Long Data Sets

excel logoYou've got a spreadsheet with a ton of data in it, organized by years. You want to be able to selectively filter by various years to be able to get a better picture of the data. How do you do it, without creating a slew of ranges or lookups? Simple, Autofilter to the rescue.


Microsoft Excel How-to: Keyboard Shortcut To Select Range of Cells in Excel

content logoHow many times have you needed to select a whole page of cells in Microsoft Excel, selected all of the data in the first row, then dragged, and dragged, and dragged to get to the last row of the data. Then, just as you get close to the last row with data it goes 'whoosh', and you find yourself 20,000 rows down. So you try to go back up the page, then go past the end of the data, then back down, then back up.... Well, you get the picture. There's a fast easy way, using a couple of shortcut keys.


Microsoft Internet Explorer 7 Beta 2 Preview Review

ie logoI know that Internet Explorer 7 beta 2 preview has been out for awhile, but I just got around to installing it and I thought I would take her for a little test drive. I'll include the relevant links at the bottom of the post, but before you rush out and install it remember that this is a beta preview, so at this stage it can still be tough to tell the difference between the bugs and the features. According to Microsoft this preview will only load on computers running Windows XP with service pack 2 installed, although they say that the production version will run on Vista (the next OS due out later this year), Windows XP Pro x64, and Windows Server 2003 in addition to XP. It's not going to run on anything prior to XP with service pack 2, so you may be looking at an OS upgrade if you've got an older OS.

I think that it's easy to tell from looking at it that Microsoft has heard the footsteps of other browsers coming up from behind, and has tried to take the best features from some of those other browsers and incorporate them into this version. Some of what they've done will be old hat for users of the more advanced browsers, but it looks like they're trying out some new things, too. They get an advantage with the hooks they can build into the OS, and they've already got the installed base. They flip the switch on it and they instantly get market dominance, it's a good place to be. Still, it's good to see that some good old-fashioned healthy competition can make the giant jump.


Formating your hard drive and installing XP - from Lifehacker

windows logoThere is a great article posted today over at Lifehacker on how to reformat your hard drive and install Windows XP.



Subscribe to Symplebyte RSS