Jul
29

MS Excel Tricks: Fast AutoFill

By · Comments (0)

Have you ever needed to fill an entire Row or Column with a Formula or a series of numbers, letters, etc.?

Usually, you would need to grab the small box (the Autofill box), in the corner of the active cell, and drag it all the way down the column to fill in all of the required values.

Well, there is a really quick way to do this, when you have hundreds or even thousands of rows to fill in. Rather than dragging the Autofill box, just double-click on it and it will automagically fill in all of the cells down the column or across the rows for you. Done!!

Here is a video tutorial showing this in action, but a description of it is below for those that don’t have time for the video:

Categories : MS Excel Tricks
Comments (0)
Apr
05

Save Early and Save Often

By · Comments (0)

Save Early and Save Often, is a motto that I will frequently state, whenever someone tells me that they lost significant work, due to some unforeseen circumstance. In almost every program you might use, there is a SAVE option, in the FILE menu, but there is a quicker way to save your work, without leaving the keyboard.

To save your document, spreadsheet, email or what have you, just press:
Ctrl & S

This will save your work quickly, so that you can continue working without fear of loosing your hard earned progress. You can NEVER save enough, so use it all the time.

Categories : General PC News, MS Excel Tricks, MS Outlook Tricks, MS Word Tricks, PC Short Cuts
Comments (0)
Apr
05

MS Excel Tricks: Need to quickly enter the Date or Time into a cell?

By · Comments (0)

This is different from the previous tip, that updates the date and/or the time, every time you open Excel. This one will just enter the data in the cell without using a formula. This is a simple keyboard shortcut.

To enter today’s date: Press Ctrl & ; <—– (semicolon key)
To enter current time: Press Ctrl & Shift & : <—– (colon key)

Now you have today’s date or the current time. Unless you change it yourself, it will keep this data in the spreadsheet, without changing it.

Categories : MS Excel Tricks
Comments (0)
Apr
01

MS Word Tricks: Ever find yourself spelling the same word wrong, over and over again?

By · Comments (0)

Click on the Tools menu and choose the AutoCorrect option. This dialog allows you to automatically replace any series of characters, with another set of characters. For instance, how do you spell RELIEF? Well, if you always seem to flip the I and the E, you can simply put the Wrong spelling of the word, in the Replace field, and put the correct spelling of the word in the With field and Word will auto-magically fix the spelling immediately after you type it on the page!!

You can use this to type abbreviations for commonly entered text as well. Such as “mye@” could be replaced with the “myemail@myemail.com” address, or anything like that. There are already a bunch of corrections built in, but you are free to add as many as you need.

Using the Menu Shortcuts, mentioned in an earlier tip, you can also get to the AutoCorrect screen by pressing Alt, then T, then A. They don’t have to be pressed at the same time, but in succession.

EDIT: I just checked and this option is available in MS Excel and Outlook too.

MS Word Tricks - AutoCorrect

AutoCorrect

Categories : MS Excel Tricks, MS Outlook Tricks, MS Word Tricks
Comments (0)
Mar
23

MS Excel Tricks: Isolating Specific Rows

By · Comments (0)

Ever need to show only the rows that contain certain criteria?

Click on the Data menu and Select the AutoFilter option. Excel will add a small arrow to the first cell in each row. Clicking on that arrow shows a unique list of all entries in that column. Selecting one of those entries, Excel will only show rows with that criteria. From there you can manipulate the data however you like.

For instance, lets say you had a spreadsheet filled with different items and you want only to see entries for a particular item. By using the AutoFilter feature, you can pick the item that you want, from the drop down menu available through the arrow, and Excel will only display the rows with that item included. Even if you have hundreds of rows for any item, the AutoFilter drop down will only show one instance of it, for every unique item in the column.

Every column has one of those arrows, so you can really refine your data precisely.

Note: If you aren’t sure whether your data is filtered or not, just take note of the color of the arrows. If they are blue, then you are filtering on that column. If they are black, then you are not filtering them.

To turn it off, just go back in to the Data menu, an click off the AutoFilter option.

Categories : MS Excel Tricks
Comments (0)
Next Page »

Google Ads

By clicking on the Google Ads in the posts, a little bit of their advertising costs will go to Potentials Unleashed. So if you see something interesting, by all means, click away and thank you for the support!