Free articles about Microsoft Excel
You all know by now that I love saving time and keystrokes and this is a little beauty that you will love!
Follow the steps below to learn how to enter a series of dates in MS Excel in short order:
Sometimes you would just love to have a comment that would make things clearer for the person using the worksheet in MS Excel wouldn’t you?
Well you can use this handly little trick to add a comment to a formula in MS Excel:
You can view the comment in the formula bar whenever you select the cell.
A subscriber wrote to me last week asking why there isn’t an AutoComplete feature in MS Excel.
My reply:
Well it’s not exactly AutoComplete but it will do the trick for you. Follow the steps below to learn how:
Whenever you want to repeat data that already appears in a column, simply click:
Quick as a flash you have a list of all previous entries in that column!
Use the arrow keys to select an item and click on Enter.
Pretty cool huh?
If you ever have the need to add a cents symbol in your spreadsheet, follow the step below:
Told you it was easy!
The Transpose feature in MS Excel is used to change a vertical range of cells to a horizontal range or vice versa.
Follow the steps below to learn how to use this feature:
Voila! Transposed! I know you will make use of this feature often!
This is one of those little tips that most folks aren’t aware of but are ever so grateful for the knowledge once they have learned it. Why? Because it saves time and keystrokes of course!
To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.
In a nanosecond you will be at the bottom of the data in that column, regardless of whether its 12,000 rows long!
To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.
Ever enter your data into the wrong cell in your spreadsheet? I know I’ve done that a couple of hundred times or so. If you get distracted as easily as I do, I am happy to tell you that there is a quick and easy method to move that data to the proper cell.
Follow the steps below:
I think this is a quick and easy way to take care of this.
I know that a lot of you know many keyboard shortcuts that you use all the time in MS Excel, but I have a couple to share with you in this newsletter that I don’t think that most of you are aware of, and ones which I find to be absolutely helpful and real time savers. I think you will agree with me.
| Do this |
To Accomplish This
|
|---|---|
| ALT + = | Insert autosum |
| CTRL + SHIFT +U | Resize the Excel formula bar (2007 only) |
| ALT + ‘ | Allows for the selection of a named style by typing the first few letters of the style name |
| ALT + ‘ | In 2007 brings up the style details box |
| CTRL + Y | Repeat last action |
| F4 | Repeat last action |
