Excel can be a little tricky in getting exactly what you want to print. In Excel we usually need certain records and/or columns to print, and it isn’t always separated on different pages. Here is a way to have exactly what you need print. First, highlight the cells you would like to print, and then click on the “Page Layout” Tab. In the middle of the “Page Setup” group you will click Print Area. Lastly, in the small drop down list click “Set Print Area”. Now when you go to print your document the only thing that will print will be the cells that you highlighted. If you ever need to print your whole document or change the area you need printed, just follow these same steps but click “Clear Print Area” instead.
Many times we have these great power point presentations that can easily be used to promote your product and/or business, but are limited to showing these presentations in locations where PowerPoint is available. Here is a tip to show you how to save your presentation as a video, so you can show your presentation anywhere you can play a video. Simply open your presentation and click on the File tab, and then select Save and Send. Lastly, in the left hand column, select Create a Video and then select the specific options that you would like your video to have, click the Create Video button, and you can now save your newly created video.
Watch this video to see how you can easily add a signature to your Outlook emails.
Here is a quick short cut you can use to add a time and or date stamp into a cell in Excel. For a Date Stamp, first select your cell and then press CTRL+; (Control Key and the Semi Colon key). For the Time Stamp, once again select your cell and then press CTRL+ SHIFT+: (Control Key, Shift Key, and the Colon Key).
While we can use paste specials to remove formatting when copying and pasting information from the internet to a word document, sometimes we just forget. Rather than starting over or spending tedious time reformatting, you can highlight your pasted text and press CTRL+SPACEBAR and it will remove all formatting, hyperlinks and reset to your default font.
As many of our documents can be a work in progress, it is nice to be able to open your document and go back to right where you left off. With this tip you can do exactly that every time. Just press SHIFT+F5, and your cursor will move to where it was when your document was last saved. So even if it has been a few days, you can open your document and be able to start right where you left off.
Many of us have used the great auto fill features that Excel has to complete a list, but what about those few times when we need the exact same information in each cell? Here is how you can do that without all the copy/ pasting. First highlight all the cells you need to have the same text, and then just start typing the information you would like to have in all the cells (note: DO NOT try and click in a cell before typing this will just un-highlight all your cells.) When you have finished entering your information instead of hitting Enter, press CTRL+ ENTER and it will fill into all your highlighted cells. This also works if you need the exact same formula in several locations of your spreadsheet.
Many times, I will get a list typed up only to realize that the information in numbers 5 and 2 should be switched. Well this tip will save you all the copy/pasting or retyping when we make those kind of mistakes. Just click anywhere in the list item that you would like to move, and then hold down ALT+SHIFT and simultaneously use your arrow keys either up or down to move the item where you would like it to be in your list.
- Triple click anywhere inside your paragraph and the whole paragraph will be highlighted.
- If you just need a sentence highlighted, hold the CTRL key and single click anywhere in the sentence.
- If you need a single word selected, double click on that word.
For some reason, it is easier to select manually if you start at the end of the word, sentence or paragraph instead of at the beginning. Just saying… I make selections hundreds of times a day.
These short cuts will work in 95% of all software you use, not just Word.
Adding a trademark symbol is actually probably easier than you think. Just press Alt+Ctl+T.
Do you know when to use the Trademark symbol in your business? Here is a great article that can explain its use. Also it talks about other ways that you can insert the symbol as well.