An Excel Tutorial for Using the TEXT and the TODAY Functions.

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

It’s the second day of the Excel Tutorial week. Yesterday was Monday and Monday is of course the day that we need to take it a bit slow and we did so with an Excel Tutorial with the formula for checking future dates.

Today we are taking it a bit further. It is still kind of a easy Excel formula but it’s too warm you up a bit for later this week, when we are really starting to use Excel for calculating with dates and time spans.

Click this line to read the rest of this article.

An Excel Tutorial with a Formula for Checking Future Dates.

Hi folks, I hope you all had a great weekend!! It’s Monday again and it’s the last week of the month and we are having another Microsoft Excel Tutorial week. And I got some great Excel Tutorials lined up for you this week. We covered in the last Excel Tutorial week several Excel Tutorials that had to do with currencies. The last Tutorial we’ve covered that week was a tutorial with a Formula for Calculating the End Date of a Project and we are continuing on this road. This week is going to be about date and time functions in Excel.

We are starting the week with an Excel Formula for checking future dates.

Click this line to read the rest of this article.

Print Your Excel Comments.

The last Tip and Trick for this week is an Excel Tip and Trick. Today I want to show you something cool/useful that has to do with the comments in excel. We already know that using comments in MS Excel can be really helpful.

Normally you only make the comments in your spreadsheet and you don’t print them. Well you can but the default setting in Excel is that you don’t print them. This is also the case when you right click on the cell and select Show Comment. This way your comment stays open and can you continue to work in your spreadsheet. If you want to print your comments you’ll need to change some settings.

Click this line to read the rest of this article.

Create Multiple Lines of Text in One Cell.

And today I have another Excel Tip and Trick for you, well Tips and Tricks since we have several. There are actually 2 easy ways to create multiple lines of text in one cell.

The easiest way is to press Alt+Enter when you’re done typing.

Excel-Tips-Tricks-Pic1

The second option for creating multiple lines of text in one cell is.

Type your data.
Select the Cell.
Right Click
Select Format Cells
Click on the Alignment tab
And enable Wrap text.

Excel-Tips-Tricks-Pic2

And click on OK and you’re done.

Excel-Tips-Tricks-Pic3

Click this line to read the rest of this article.

Change the Direction of the Cursor.

Today’s Tip and Trick is another useful Tip and Trick and it has to do with Microsoft Excel.

When you are working in a spreadsheet and you hit the Enter key, Excel by default moves the cursor below the one where you’re standing in.

If you want to change the direction of the cursor you’ll need to take the following steps.

In Microsoft Excel 2003 and earlier versions you’ll need to do this.

Go to Tools.
Select options
And go to the Edit tab.
Now change the direction of the selection movement from the drop-down list titled Move Selection after Entry.

Click this line to read the rest of this article.

How To Use Alt Keyboard Shortcut Combinations.

Today’s Word and Excel Tip and Trick doesn’t need an intro. It’s a nice printable list with all the Alt keyboard shortcut combinations. I hope you’ll enjoy it.