--SEARCH--

Category: MS Excel

Just the Comment and Nothing But the Comment
Have a lot of comments in your MS Excel files? Ever find yourself entering duplicate comments as you work your way through a file? If so, are you a little tired of the repetitive typing? Then stop doing it! Read here and learn how you can get just the comment and nothing but the comment, just the way you want it. This one's a must read!

Tell Excel to Leave You Alone!
Do you ever feel like MS Excel is trying to control things for you while you're using the program? You know, maybe it automatically does something for you that you didn't want done. Well, luckily, there's a way you can tell Excel to just leave you alone. Read here and find out how!

When a Name Box Isn't a Name Box
Did you know that MS Excel's Name box isn't always the Name box (the box to the left of the Formula bar?) I know it sounds crazy, but it's true! Read here for all the information you need to know about this and how you can change it up. This one's a must read!

Sum It Up With Two Keys
I'm sure many of you are familiar with the AutoSum button in MS Excel, right? It's a handy litle feature, but what if you like keyboard shortcuts instead? Is there a way you can use the sum feature with just your keyboard? Well, there sure is! Read here to learn all about it. It's a must see!

Insert Many Where There Are None
Do you do a lot of copy/paste or cut/paste moves in MS Excel? If so, are you tired of shifting cells around to make space for the stuff you need inserted into the middle of your current data set? Want Excel to do that data shift for you? Yeah, that sounds good to me! Read here and find out just how you can make that happen!

Check Them All
Did you know that when you run the Spell Check in MS Excel, it only checks the current worksheet and not the entire workbook? Want to check the whole thing at once? Then read here and find out how you can!

Excel 2007: Even Quicker Formulas
Are you an avid MS Excel 2007 user? If so, have you been looking for a way to get even faster formulas for all of your projects? Then you've got to check out this simple trick. It's a definite must see!

Text to Excel: The Easy Way
Do you frequently copy text from MS Word to Excel? Do you dislike the way it pastes into the cells, causing a nightmare when it comes to formatting your pages? Want a quick solution? Then read here and find one!

I Need a Worksheet Pronto!
Here's one for all you MS Excel users who find yourself constantly going to the Insert menu, Worksheet choice every time you need another worksheet. Instead, try this two-key solution. Check it out for yourself today!

Bring It On Over
Have you ever had the need to bring some of your MS Excel work over to MS Word? Find it a little difficult to do? If so, this tip is sure to help. Read here for all the details!

No Accidental Replacement Saves
Do you have an MS Word, Excel or PowerPoint file you frequently open, make changes to and then save under a new name? If so, how many times have you accidentally overwritten the original information with the new file? If that sounds like something you do quite often, you need a new way of doing things. And I've got just what you need right here. Read here to learn all about it!

Why Am I Back There Again?
Have you ever scrolled a long way through an MS Excel worksheet and, while you were looking around, hit an arrow key to move? If so, you found yourself right back where you started, didn't you? How frustrating! Well, if you don't want that to happen ever again, you better read here and find out how you can stop it. This one's a must read!

Moving Cell Contents Without Borders in Excel
So, you need to move some data around in your Excel worksheet and you're a bit frustrated. Sound familiar? If so, give yourself a break and try this tip. It's an easy fix for a somewhat difficult job. Check it out!

Drag Data Between Excel Worksheets
Have you ever tried to drag and drop data from one worksheet to another in MS Excel? Have a little trouble with it? If so, I've got just the fix you've been looking for. Read here to learn all about it!

For Your Eyes Only
Have you ever been in a situation where you're working on sensitive material in MS Excel and someone walks up behind you? When that happens, what do you do? I mean, you're working on something for yourself and no one else needs to see it! Well, one very simple thing you can do is hide it. Want to learn how? I thought you might. Read here for the full scoop!

Double Click to Exit?
Are you currently using MS Excel 2007? If so, do you ever have trouble exiting out of it? Need a quick and easy fix? Then I've got what you've been looking for. Check it all out right here, right now!

More or Less
Ever have trouble with decimal points in MS Excel? Want an easy way to get more or less while you work with them? If so, you've got to check this tip out. It's a must read!

A Good Form Isn't So Hard To Find
Do you have rows and rows of data to enter in MS Excel? If so, do you find it tiresome to navigate through cell after cell to the right and then at the end, go back to the beginning of the next row? Then don't do it anymore! Read here to find out a much easier way to go about your business. It's a must read!

Formatting Be Gone!
Have you ever found yourself in a situation in MS Excel where your worksheet has so much formatting, it's beginning to be a bit ridiculous? I mean, how much time can you possibly spend keeping all that formatting consistent? Well, you don't have to anymore. Read here and find out what your other options are!

Customize Your Stripes
Do you use MS Excel 2007? If so, I've got another great tip for you today. This one will help you do your own customizing. Check it out today!

Do You See Stripes?
Do you use the new MS Excel 2007? If so, I've got the perfect tip for you today. It's all about letting Excel do a little more of your work for you. Interested? Then check this tip out right here, right now!

Long Distance Scrolling in Excel
Want to take an easy scroll in MS Excel? Then read here and find out how you can do just that. You don't want to miss this one!

Calling On Other Worksheets
Have you ever needed to refer back to some of your other MS Excel worksheets for cell references, etc.? If so, this is the tip for you. Check it out right here, right now!

Click in Your References
Did you know you don't have to type cell locations into formulas in MS Excel? Boy, that sure would save you some time, huh? Well, if you'd like to learn how you can make that possible, read here for all the details!

Hide/Unhide Excel Key Combinations
Do you ever need to hide or unhide some of your data in MS Excel? Do you have a hard time finding an easy way to do that? If so, I've got the answer you've been looking for. Read here to learn how you can hide and unhide your data with a few simple key combinations from now on!

Navigation Keys for Excel's Print Preview
Do you frequently use the print preview feature in MS Excel? If so, do you know about the keys you can use to navigate through it with ease? Well, if you haven't heard the news, read here to find out. It's a definite must see!

Seeing the Unseen in Excel
Ever find yourself frustrated with MS Excel as you create a worksheet that you're specifically trying to keep to one page wide? I know how that can be and that's why I always use a different method. Read here to learn all about it!

From Here to Home
Have you ever been working in one of your MS Excel cells and needed to go from there straight to home? Need a quick and easy way to do that? If so, I've got just the thing for you. Read here to learn all about it!

I Didn't Mean to Make a Change!
Do you sometimes have trouble when you're working with your cells in MS Excel? Do you sometimes change certain things you didn't mean to change? If so, read here for an easy fix for that and you'll be good to go!

One Handed Cell Selections
We all know that you can select non-adjacent cells in MS Excel by holding down the Control key and clicking in various locations on your worksheet. But, do you ever find yourself frustrated, because you're trying to highlight non-adjacent cells and the phone is ringing or you need to flip through papers? Well, let's end all of that today. Read here to find out what you can do to make things so much easier on yourself. Check it out!

Data Range Reduction or Increase
Have you ever found yourself looking at a range of data in MS Excel, wishing for an easy way to increase or decrease all their values by the same factor or amount? If so, I've got something for you today that I know you're just going to love. Read here and learn all about it!

Corner to Corner
Do you ever need to get to another corner of your MS Excel document in a jiffy? Maybe you know how to do it for one end, but what about the other? Well, read here and you can learn all about it!

Moving with Choices
Do you need a quick way to move some of your cell contents in MS Excel? How would you like to be in control of those movements? If that sounds like a winner to you, read here and find out how you can make just that happen!

Picture it in a Header
Have you ever wanted to add a header or footer to your MS Excel document? Have you ever had trouble actually getting that done? If so, read here to learn about the easiest way possible. Check it out!

A Paste That Inserts Instead of Replacing
What do you do when you need to copy or cut cells in MS Excel and then insert them between existing data? You may have your own way of doing things, but read here and find out what you should be doing. It will make your life a whole lot easier, I promise!

But I Wanted to Use ClipArt!
Have you been trying to jazz up your MS Excel projects recently? Are you having trouble using the ClipArt feature? If so, read here and find out how you can easily switch things around to be just like you want them!

Graphs That Grab Attention
Need to spice up your graphs a bit in MS Excel? If so, read here and find out how you can create graphs that grab attention!

Navigating the Selected Range
Have you ever had the need to navigate through a specific range you have selected in your MS Excel document? If so, read here for a super simple way to get the job done. Check it out!

Moving Backwards
Ever find yourself about to hit the Enter key in MS Excel and realize you need to move up a cell to fix something? Well, read here and find out what you should do from now on. It's so much better than what you've been doing, I'm sure. Check it out!

Listing the Choices
Now that we've discussed the idea of data validations in MS Excel, let's see what else we can do. I'm not going to give too much away here, because this one's just too cool. You don't want to miss it. Click here and get started right away!

Data Validation
Did you know you have the ability to set limits on the data that's entered into an MS Excel worksheet? Well, if you didn't know before, you know now! Click here and read all about how you can make that happen. This is a must read!

Selecting Cells with Just "The Right Stuff"
Have you ever looked at an MS Excel worksheet and wondered how long it was going to take you to select only those cells that contain text or formulas or numbers or those cells that have errors? Want to know how you can get "the right stuff" the first time? Then read here and find out!

Find and Replace Multiple Worksheets at the Same Time
Okay, so you've used the Find/Replace function in MS Excel with a lot of success before, right? Want an even easier way though? If that's what you've been waiting for, read here and make your wish come true!

Can You Please Repeat That?
Here's a great keyboard shortcut for repetitive tasks! This one works with both MS Word and MS Excel. Check it out today!

Oops, That's Not What I Meant To Do!
Have you ever been working in MS Excel and found that you've changed the contents of the wrong cell? If so, how would you like an easy to fix all of that before you get too behind? If that's what you've been waiting for, you've got to read this tip. It's an easy fix and anyone can do it!

Making Square Grids
Have you ever had the need to make square grids for one of your MS Excel projects? If so, have you had trouble making them? Well, that all ends here. Read this tip for an easy way to make your grids come to life!

Open Sesame!
Do you have a workbook you work with every single time you use MS Excel? If so, wouldn't it be nice if that workbook could already be open for you each time you open Excel? If that sounds good to you, read here and find out how you can make that happen!

Using the Keyboard for Some Highlighting Fun
Want to learn about some more quick keyboard shortcuts that you can use with MS Excel? Then this tip is perfect for you. Check it out!

How Many More Workdays?
Ever need to calculate the number of workdays left until a deadline? Or how about how many days left until your vacation? Either way, let MS Excel do the counting for you. Read here and learn how you can make that happen today!

Current Date and Time
Want some keyboard shortcuts you can use for the current date and time in MS Word, MS PowerPoint and MS Excel. Then read here. That's all you have to do!

Exponents in Excel
Have you ever needed to use exponents in an MS Excel formula, but you didn't know how? If so, read here to learn about an easy way to work with them. You won't be disappointed!

Hyperlinks With Style
Ever wish you could change the look of the hyperlinks (and just the hyperlinks) in one of your MS Excel workbooks? Well, now you can! Read here to find out how and see how easy it is too!

Excel Works With More Than You Think
Have you ever found yourself working in MS Excel and needed to enter fractions? If so, what did you do? No matter what you did, how would you like to have an easier way to deal with them? If so, read here and find out how you can make that happen!

Mouseless Cell Formatting
Need to do a little cell formatting in MS Excel? Want to do it mouseless? If you're interested, read here and find out how you can make that happen!

Step By Step
Ever wonder how MS Excel calculates something in one of your formulas? If so, read this tip and find out how you can go right along with Excel, step by step. It's all explained here!

Highlight From Here On Up
Yep, that's what you can do with a few quick keystrokes in MS Excel. That is, if you know the "magic" combination. Read here to learn all about it!

Forgetful Frustration
Do you frequently get frustrated when you're working in MS Excel and you can't remember what you named a file or where you put it? If so, read here for an easy fix to all your frustration!

Delete vs. Clear
Do you use a lot of formatting (font, bold, etc.) in MS Excel? If so, you've got to read here and find out what the deal is between the delete and clear features. Check it out today!

Hey, Watch It!
Do you often work with a lot of large documents in MS Excel? If so, do you have a hard time scrolling through them? Then you've got to check out Excel's Watch Window feature. Read here for all the details!

Printing Only What's Needed
Do you ever need to print just a selection of your work in MS Excel? If so, read here for an easy tip on how to make that happen.

To Sum It Up
Need to do a little summing up in MS Excel? Then read here and find out all about it!

Chart Adjustment = Data Adjustment
Did you know that with some MS Excel 2D charts, you can actually adjust the chart to look as you want it and Excel will then adjust the corresponding data to match? If not, you must check it out then. Just click here to get started!

Control the Scroll
Need an easier way to use the scroll bars in MS Excel? If so, this tip is a must see. Check it out and control your scroll!

Excel's Cut vs. Copy
Want to know the deal with the cut and copy options in MS Excel. If that's been on your mind, you have to click here and read this tip today!

Break It Up
Have you ever had trouble getting the page breaks in MS Excel to work the way you want them to? Well, read here for an easier way to get that done!

What's Going On Here?
Ever enter data in MS Excel, only to find that it's changing all the time from whole numbers to decimals? Does that annoy you to no end? Then change it. Read here to learn how!

More or Less: Quick, Quick, Quick
Do you frequently work in MS Excel? If so, do you find yourself annoyed when trying to add columns or rows that just take so much time? Well, read here and find an easier and quicker way to deal with things. Check it out!

The Old Switcharoo
Have you ever noticed how MS Excel handles dates, months and days of the week differently than other data? Read here to find out how you can do a little switcharoo on them and get it the way you want it!

Shrink to Fit
Ever have data in MS Excel that's just a bit too long for the cell? Are you tired of it? Well, read here to learn how you can get your data to shrink to fit where you need it. It's so easy!

Selecting Text Only
Ever wished for a way to select only the text in your MS Excel worksheets? Well, your prayers have been answered. Check it out here!

Tweak Those Excel Templates Too
Now that you have tweaked your MS Word templates, how about the ones in MS Excel? Learn how to do those next with this tip!

Analyze Filtered Data
Have you been looking for an easier way to analyze your filtered data in MS Excel? Then stop here, because this tip has your answer!

Double the Work? No thanks!
Ever find yourself either retyping or copying and pasting information from an Excel worksheet into a text box or an AutoShape? Maybe you need that data stated in a bold way, so it's been put into a text box or an AutoShape to grab everyone's attention. That's a good idea, but I bet there's an easier way to do it than what you've been using. Find out here and save yourself some work!

Name It Without Typing
Trying to name existing ranges of data in MS Excel? Learn how you can do it without any retyping required!

Removing a Chart's "Oops"
Ever make some "oopsies" in your MS Excel charts? Well, learn how to easily fix them right here with this tip!

Just the Value
Do you ever need to copy over a value in MS Excel? But, you only need the value and nothing else. Find out how you can easily do that right here.

They're All Open
Want MS Excel to open all the files you use on a daily basis for you instead of you having to do it yourself? Find out how you can make that happen here!

Copying Worksheet Formats
Have you ever tried to copy the contents of one MS Excel worksheet to another only to find that when you're done pasting, you've lost all your column and row formatting (such as column width and row heights?) How much time do you lose reformatting all those worksheets? Well, save time now with this tip!

More or Less?
Want to learn an easy way to add or subtract worksheets to your workbooks in MS Excel? Learn it right here, right now!

When to Use What
Not sure when to use such things as colons, commas and spaces in MS Excel? Learn how to tell right here.

Editing an Excel Hyperlink
Do you use a lot of hyperlinks in your MS Excel work? Have trouble editing them? Learn an easier way with this tip!

More Than Names
Do you use MS Excel's name box to name your ranges? If so, find out how to get "more than that" from now on!

Excel Worksheets on Demand
Need a certain amount of worksheets right away in MS Excel? Find out how you can easily specify how many you want and get them now!

Work What?
What does a workbook and worksheet mean to you when you're working in MS Excel? Find out right here!

Spell Check in Excel
Ever wonder how accurate your spelling is on your MS Excel work? Then spell check it! Learn how to do that here.

Them's the Breaks
Want an easier way to place your own breaks in your MS Excel work? Then read here!

Going to the Edge
Do you work with wide ranges of data in MS Excel? Have you ever gone to the edge with them? If not, learn how you can do so now!

Separate Ranges
Need to separate your ranges onto only one page for your MS Excel data? Learn how to do just that here.

Let Excel Proofread
Have some proofreading that needs done in MS Excel? Then let Excel do it for you! It's easy! Learn how here.

Extending Your Chart Data
Do you have some data you would like to add to in MS Excel? Learn about an easy to extend that with this tip.

A Grid of a Different Color
Want to change the colors of your gridlines in MS Excel? It's super easy to do. Learn how here!

Cruising Around Your Charts
Do you use MS Excel charts? Do you know your way around them? If not, learn about an easy way to deal with them here!

To Update or Not to Update
That is the question. Did you know you had so many choices on updating when you're working in MS Excel? Well, you do. Check them out here!

Drag and Drop Between Worksheets
Do you want to combine your work from different worksheets into one? Find out an easy to do that when working in MS Excel. Get started now!

Copy Excel Formulas Exactly
Ever have to create a column of formulas that are very similar? When you completed a copy / paste, were you upset to find that the cell references were changed during the paste? Would you maybe like to change that? Find out how you can here!

Center Stage
Want to put your work on center stage? Find out how you can in MS Excel with this tip!

Make it Stand Out in Excel
Every once in awhile, we all have data in MS Excel that just needs to be presented with some "oomph." Am I right? Find out how you can do that here.

Excel Cells Into MS Word
Do you use both MS Word and MS Excel regularly? Want an easier way to get your Excel work into Word? Find out how here!

Copy Just Chart Formats
Have your perfect formatting figured out for your MS Excel charts? Want to use it for all your charts? Learn how you can here!

Border It Now
Ever find yourself working in MS Excel and need a quick border to a cell or a group of cells? Find out how to get it done fast with this tip!

Super Quick Excel Charts
Use a lot of MS Excel charts? Find out how you can get there super fast with this tip!

Keep It Blank
Have something you'd like to clear out and make blank again in MS Excel? Find out how you can here.

Special Data Formatting - The Easy Way
Do you enter a lot of special data into MS Excel, such as zip codes, phone numbers or social security numbers? Want an easier way to handle them? Find that easier way right here!

One Change = Many Changes
One change changes a lot in MS Excel. See what I mean here!

Set It Up Only Once
Tired of repeating steps in MS Excel? Then only do it once! Learn how here.

Starting Over
Find out how you can start completely over with a clean slate in MS Excel.

Quick Sheet Selection in MS Excel
Tired of wasting your time with sheet selection in MS Excel? Learn about a much faster way right now with this tip!

DATEDIF
Want to know the time difference between two dates in MS Excel? Use DATEDIF and get it done fast!

What's the #### in My Worksheet?
Find out what the #### symbol means in MS Excel and learn what you can do with it.

Drop Cap
What is a drop cap? Well, it is that ever so small, yet beautiful addition to a document. You may be amazed at how easy it is to put such a great touch on your documents.

Left, Right, Up or Down
Make it so MS Excel lets you go whatever way you want to!

Relocate in Seconds
Don't wait any longer. Find out how you can relocate your information in MS Excel in mere seconds.

Bits and Pieces
Format only the bits and pieces that you want in MS Excel.

Zig or Zag?
Find out how to zig or zag (your choice) in MS Excel!

Vanishing Gridlines
Get back in the grid with this MS Excel tip!

Printing Formula Errors
Would you like change the way MS Excel prints the formula errors? Learn how you can here.

Print the Headings Too
Find out how you can print the headings in MS Excel along with everything else.

MS Excel Charts Done Your Way
Want to change something in your MS Excel chart? No problem. Find an easy way to do so here.

Fix It With a Click, Click
Make a mistake on one of your MS Excel charts? Well, all you have to do is click, click and it will be fixed!

Lost in Worksheets
Learn how to organize your worksheets in MS Excel the easy way!

Moving Right Next Door
Check out this easy way to work with worksheets in MS Excel.

Excel Dates Done Your Way
Get the dates you use in MS Excel to be just way you want them.

Dating in Excel
How do you want the dates to look in MS Excel? Change them up and get them the way you want them by following this tip.

Clearly, We've Got Some Options
Pursue all your options while using MS Excel

MS Excel Custom Views
Try this easy trick to get to the custom view feature in MS Excel.

Super Repeating Data Shortcut
Don't repeat everything by hand anymore. Try this trick for repeating data in MS Excel. It will save you a lot of time and probably some headaches too!

Snap to It
Start using the "Snap To" feature in different MS Office programs today!

The Leading Zero
Make it so you can keep that zero like you want it in MS Excel

And the Subtotal Is...
A simple way to figure out subtotals in MS Excel

Excel Sorting Fun
Sort your own way in MS Excel

Mouse Free Borders
Create borders in MS Excel without even touching your mouse

Randomness in MS Excel
Get random numbers with one simple formula

MS Excel AutoFilter Part 2 - Top 10 and Custom Filters
Learn even more about the AutoFilter feature in MS Excel, along with the Top 10 and Custom Filters features

I Thought Filters Were For Things Like Fish Tanks and Coffee Makers...
I introduce you to the AutoFilter feature of MS Excel. Give it a try, you might like it!

Changing the View, Not the Selection
Change your view in MS Excel without messing with the selection

Format Painter Made More Useful
Get more use out of the Format Painter in MS Excel

Quick and Spiffy Tables in MS Excel
Create some spunky tables in Excel and then use the AutoFormat option to keep them!

MS Excel Default Font Fun
Set that font the way you want it - for good!

Worksheet or Workbook?
Find and replace your files in MS Excel

Single Worksheet Templates
Have you ever wanted just a single worksheet to open instead of an entire workbook in Excel? If so, read on.

File Open With Startup
Open up that worksheet you use every day at your initial startup

Printing the Grid
Now, let's talk about printing those gridlines

The Clean Sheet
Get rid of the gridlines in Excel and start with a clean sheet!

One Screen at a Time
Go from one screen to the next, up or down, in MS Excel

Wrong Way
Get it back the right way...now!

Make It Fit to the Page
Have an Excel worksheet that is sized just barely over the width of a page? What did you do?

File Name Location: A Mystery No More
An easy way to find your files in MS Excel

Same Info - Many Cells
Put the same information into several cells in MS Excel

Tracing the Path
Understand complicated Excel formulas just a little bit better with this tip

Mouseless Smart Tags
A mouseless trick for Excel's smart tags

Black and White Charts
Ever feel the disappointment of finding that your beautiful and carefully selected colors are not cooperating when it comes to all this black and white stuff?

Custom Chart Colors - Permanently
Change your chart colors in Excel for good

All By Itself
Print that chart all by itself

Create It My Way
Make changes to your workbook

Need a Little Backup?
Backup your Excel files

Now Who Told Excel To Paste That Data?
Bye-bye hidden data

Convert It To A Value
Converting a single cell to its value in Excel

More Than A Simple Paste Button
More about the Past Button

Set It In Pixels?
A way to set column widths and row heights using pixels.

Headings Using The Keyboard
A tip for everyone who likes the headings but hates using the mouse, here are a few keyboard shortcuts to help you apply the most common styles.

Case Sensitive Sorts
Excel can do sorts that are case sensitive

From Another Workbook
Use formulas that reference cells from a completely different workbook.

Leave My Addresses Alone!
Tired of the way your program (Excel, Word or PowerPoint) keeps changing all your web or email addresses into hyperlinks automatically?

From One Sheet To The Next
Have you ever found yourself trying to reference a value from a MS Excel worksheet other than the one you're currently working with?

Excel's Name box
Did you know that Excel's Name box isn't always the Name box?

Help With Excel Formula Syntax
So, you're trying to use a formula in MS Excel but it's been a while and you can't quite remember the formatting to use when entering the cell references of the data. Hmm… what to do, what to do?

The Never-Disappearing Borders
Ever run across a cell border in MS Excel that just wouldn't disappear? Here's how to fix it.

The AutoSum With More
Excel's handy little AutoSum button can be used for more than sums.

AutoSum in Excel with just 2 keys
Insert a sum formula without leaving the keyboard

Updating formula values in MS Excel- two methods
Excel values can update with your formula

Data insertion and cell shifting in MS Excel
Copy-paste and cut-paste and auto-shift the cells

Copy Column Widths in MS Excel
speed up column format adjustments in your spreadsheets

Using the Keyboard to Highlight Rows and Columns
Highlight an entire row or column in Excel

How Many More Work Days?
Let Excel figure out the days left until a deadline

Now Where Did That Zero Go?
If you've ever entered a number with a zero in the first place(s) you probably became very frustrated when you realized that Excel takes those zeros off the number. So, how do we overcome Excel's natural tendency to "help" us out in these situations?

Playing The Name Game
Get a better understanding of what it means to name ranges of cells in Excel.

Use A Title In Formulas in MS Excel
Did you know that when you have a title at the top of a column of data that you can use that title in formulas—instead of the cell reference?

Be The Master Of Your Excel Lists
Let's take a look at how to create a list that's all your own—in other words, a custom list.

Lists In MS Excel
Excel has lists? Yes, it does. (And fortunately they're not "to do" lists!)

Turn Many Into One
Here's the scenario: you're working on a table of data in MS Excel and you're trying to put a title over the entire table. What do you do?

What Was That Function Again?
Ever find yourself working in MS Excel and realize that the function you're looking for is right on the tip of your tongue - or fingers in this case?

Date & Time On Demand
Do you find yourself constantly entering the date and / or time in MS Excel? Wish you had a quick key combination to get the job done for you?

Quick Slide Margins - Part 2 - MS Excel
I thought it might be relevant to discuss quick margin adjustments in MS Excel.

Playing The "Shifty Cell" Game
Have you ever found yourself happily working in a large MS Excel worksheet only to discover that you need some cells in the middle of the thing?

The Wonders Of F2 In MS Excel
When you're working in Excel and you need to edit something that is already in a cell what do you do?

For My Eyes Only
Have you ever been in a situation where you're working on sensitive material in MS Excel and someone walks up behind you? Why not just hide the file?

Where Is This Located On The Worksheet? I Can't Tell From The Printout!
Ever wish you had your gridlines, column letters and row numbers on the printout of an MS Excel worksheet?

Now Why Are These Columns Numbered?
Having difficulty with the Excel labeling of the columns? Instead of letters for column headers, are you getting numbers?

Cell Hide And Seek In MS Excel
Have you ever found yourself trying to hide the contents of a single cell in MS Excel? Would you like to know how to hide the contents of an individual cell?

MS Excel Keyboard Shortcuts
Here's a few quick MS Excel keyboard shortcuts.

MS Excel Text Into Columns
Have you ever found yourself wondering what in the world possessed the person who created your MS Excel file to put both first and last name in the same cell? Learn how to separate them.

Counting Rows In MS Excel
MS Excel will count your highlighted columns or rows for you.

Show Me The… Formulas?
If we can print the formulas, and not the values, then how do you do it?

Double-Click = Best Fit
As many MS Excel users are aware you can highlight a column and through the Format menu, Column sub-menu you can choose the AutoFit Selection choice. However, we all like a faster way and for this little trick there is a two-click shortcut.

Psst… What's The Password?
Have you ever had a MS Word or Excel file that you just didn't want anyone to read?

Give Me The Value And Just The Value
Have you ever found yourself working in MS Excel and wishing you could paste the value of a formula instead of the formula? Good - then you're in the right place.

Preventing The "Saved Over" Blues
Do you have an Excel file that you constantly change data in and then have to remember to save it under a new name? There is a solution.

What's up with all those tabs?
Did you ever notice that there are several tabs in the New window when you go to open a template you've created? What's up with all those tabs?

Single Worksheet Templates
Have you ever wanted just a single sheet for a template? Learn how to make them here!

Quick & Spiffy Tables in MS Excel
Ready to take a look at Excel AutoFormats?

MS Excel Default Font Fun
Do you constantly find yourself changing the font size or type in Excel worksheets? Learn how to select the Standard Font.

MS Excel AutoFilters Part 1—The Basics
Learn how to filter out the stuff that doesn't matter in your MS Excel document and only display the items that you are looking for.

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? Learn of a way to see what you want and get rid of the rest.

MS Excel AutoFilter Part 2—Top 10 and Custom Filters
Learn about the two items in the AutoFilter pull down list.

Changing The View - Not The Selection
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? Learn what to do here!

Repeating Data Super Shortcut
When working in MS Excel do you ever find yourself repeatedly entering the same formula or data? What do you do? Learn what to do here!

The Leading Zero
Constantly frustrated with MS Excel because it keeps removing that leading zero from your inventory number? Get Excel to leave your zeros alone.

MS Excel Custom Views
Do you work in huge MS Excel files and constantly find yourself scrolling this way and that trying to get to the right place?

Clearly We've Got Some Options
Learn how to not delete the data and just delete the formatting.

Dates Done Your Way
You're frustrated with the standard Excel date formats and you're looking for a way to meet your needs. Learn about that way here!

Dates In Excel
Have you ever wished the date was in a different format?

A Picture Is Worth A Thousand Words
Learn how to graph in Excel.

Lost In Worksheets
Have you ever found yourself feeling lost while trying to move a worksheet inside a huge workbook? Here is a solution to alleviate your sheet-moving frustrations.

Moving Right Next Door
Learn how to move worksheets from one workbook to another.

MS Excel Charts Done Your Way
OK, so you've made an absolutely beautiful Excel chart but you're seeing a few things that you'd like to change. Learn what to do about them here.

Fix It With A Click, Click
Learn what to do when you have gone completely through the charting process, had a beautiful graph and realized that you spelled a word wrong.

Zig or Zag—Which Way?
So, you've got this huge worksheet in MS Excel you're trying to print and it seems that the pages are coming out completely scrambled. Learn how to tell it how to print the data.

Vanishing Gridlines
Learn about vanishing gridlines.

Relocate In Seconds
You put the data on it's own sheet but now you've got second thoughts. Now you'd find it more useful if it was embedded in the sheet, displayed next to the data.

What's Up With The ##### In My Worksheet?
Have you ever found yourself happily working in MS Excel only to be befuddled by the sudden appearance of #### in a cell where there should be a number? Learn what to do about it here!

Using Excel's Report Manager
You've decided that the Report Manager might be just the thing you need, so learn about it here!

Manage Your Reports
Do you have a single MS Excel file from which you print many different reports? Want a better way to organize the different reports?

Quick Worksheet Relocation
What do you do when you need to move an Excel worksheet into its own workbook? Click here to find out!

MS Excel Cell Alignment
Learn how to align cells in MS Excel.

Align It Your Way
Ever find yourself sitting back thinking "That spacing looks all funny"? Learn how to solve the problem here!

Show Me More Tabs Please
Here's a scoop on showing more worksheet tabs in MS Excel.

Super Quick Excel Charts
A super quick way to making an Excel chart.

Outline It Now!
Ever find yourself working in MS Excel and need a quick outline to a cell or group of cells?

Cell References in MS Excel
Ever notice that when you're copying a formula in MS Excel the cell references in the formula will change?

Excel Cells Into MS Word
Have you ever tried to copy and paste cells from Excel to Word? Well... one idea is to copy in Excel and then use the Edit menu, Paste Special choice in Word.

Center Stage
Ever have something to print from MS Excel that was just too small? Centering Excel data is just a few clicks away.

Excel Worksheet Protection
Enable protection on an MS Excel worksheet.

No Touch My Cells!
Learn how to prevent changes to a worksheet.

Excel Drag & Drop Between Worksheets
Learn how to move data from one location to another location, within the same sheet!

To Update Or Not To Update
Insert the date or time into an Excel worksheet!

Extending Your Chart Data
Got more data to add to the chart that you didn't plan on? Learn how to get around it here!

Have Excel Help With The Proofreading
Learn how to let Excel help with proofreading!

Going To The Edge
Want a quicker way to get to the edge of the data range of course?

MS Excel Worksheets on Demand
Learn how to change the default number of worksheets.

What is a workbook, or a worksheet in MS Excel?
What exactly is a workbook? A worksheet? Is there a difference? Learn about them here.

Navigate Cells Without Deselecting
Learn how to edit the data without deselecting the entire data range.

Selection Direction
Have you ever been working in MS Excel and found yourself wishing that the cell selection would go in some other direction after you hit the Enter key? Learn how to change the direction the Enter key moves the cell selection.

Seeing The Roots
Get Excel to show you all cells involved with one quick move!

MS Excel: Headers & Footers Demystified—Part 2
Let's continue on our journey through the world of headers and footers.

Why Can't They All Look That Way?
Learn how to save all the formatting from one set of data and apply it to future sets of data to be charted.

See More Tabs
Locate the Tab Split box and increase the number of sheet tabs that are visible at one time!

Quick and Complete Worksheet Copying
Copy a Excel worksheet formatting, data, header, footer and all.

Copying Excel Worksheets—Including The Formatting!
Copy the c