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.
Cut, Copy & Paste
Have you ever needed to copy information from one place to another? Although you can use the menu system to Cut, Copy & Paste. There are shortcut keys that will help you keep your hands on the keyboard.
Cut = Ctrl & X
Copy = Ctrl & C
Paste = Ctrl & V
In combination with the Alt-Tab shortcut below, you can copy information from one program into another very quickly. I use them all the time and find it MUCH faster than having to take my hand off the keyboard, to use the mouse.
These shortcuts are universal and will work in almost ANY program that you would ever use.
Here is a video tutorial on using them in Word and Excel:
MS Excel – Need to get rid of the extra spaces before or after the text in a cell? In another row or cell, type in the following code, replacing the cell A2 with the actual cell number that you need:
=trim(A2)
So this: ” This text has leading spaces. ”
Becomes this: “This text has leading spaces.”
(The quotes are just to show the spaces before and after the text)
Now you can copy the value of the new cell over the old value and there you have it!
Have you ever needed a particular cell, in Excel, to show Today’s date, every time you open it? Well, here is the formula to do that very thing:
Click in the cell that you want it to appear in and type the following code, including the parenthesis:
=today()
That’s it! Save your document and every day that you open it, it will show Today’s date.
Have you ever noticed that in just about every program that has menus, such as the MS Office programs, that each menu item has one letter that is underlined? That letter is the shortcut key for that menu. To use it, hold down the ALT key and press the letter of the menu you want.
Once you have the menu open, you’ll notice that some of those options have an underlined letter too. Just press that letter, on your keyboard, to choose that option. For instance, to get the PRINT option from the FILE menu, press the ALT key, then press “F”, then press “P”. This will open the print dialog screen.
Of course, some of the more popular menu choices, such as the Print function, have an additional shortcut combination as well. A quicker way to call up the Print option is to just press ALT & P.
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!