You can easily do this by first pressing the Ctrl & ‘ (apostrophe) key combination and then the letter you need the accent over.
For Example: resumé
Ctrl & ‘ then press the letter e
The word resumé has an accent over one of the “e” characters. So using the Ctrl & ‘ and then pressing the letter e, you will get the accented character.
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.
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.
AutoCorrect
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.
Ever need to select everything on the page that you are viewing, whether it be a Word document or an entire Excel worksheet?
By pressing the Ctrl & A key combination, you can do just that. Now you can use the Cut, Copy & Paste shortcuts to move that information to a new document.
Select All = Ctrl & A
This typically works in any program, including Microsoft’s entire suite of products.
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!