Helpful Tips Blog
All Tips
Can I add a Timestamp to my Excel file name?
Yes, you can create a macro that does this. You can copy and paste the code below to add the current date and time to the file name of a file. On the Developer tab, click on Visual Basic. When the Visual Basic window opens, click on Insert > Module. When...
How do I create a survey in Word?
You need to use the Developer tab. If that's not visible, modify the Ribbon so that it is enabled. Now, on the Developer tab, click on Design Mode At this point you can start adding controls to your page. For example, if you click on the Checkmark option, Word will...
How do I change the color of visited hyperlinks in Word?
The name of the style is FollowedHyperlink. To change the color (or any other attribute) of the style, click on the Style Panes launcher on the Home tab. Alternately, you can press Shift+Ctrl+Alt+S. The styles pane will open. If all of the styles are not showing,...
How do you add images in Microsoft Word?
You can add images in Word by using the Insert tab and selecting Picture. When you select the image, Word places it at the insertion point as an in-line image, treating it just as it would a character of text. You probably don't want that so you will need to set the...
How can I replace all the fonts at one time in PowerPoint?
You can go to the View tab and click on Slide Master to set the size and font face for all bullet levels depending on your theme. Once you change the fonts on the Slide Master, your presentation will be adjusted with the fonts you choose. Now you can go through each...
How to set tab size in Microsoft Word?
When you start a new document, the default tab stops are set every one-half inch across the page and are left aligned. Every time you press TAB, the insertion point moves over .5. Some people typically press Tab to indent the first line of paragraphs in double-spaced...
How can you add music in PowerPoint?
If you want to play audio throughout the entire presentation, there are a few steps you need to take (depending on your version of PowerPoint). Look on your Home tab, and if you have an Insert Media button click on that. Otherwise, go to your Insert tab and choose...
Can I use both portrait and landscape slides in the same presentation?
PowerPoint won't allow you to mix orientation within one file. But you can work around this by placing the slides with landscape orientation in one file and the slides with portrait orientation in another file. Keep them in the same folder and link the presentations...
Why is the default font on Microsoft Word for a table of contents those large blue letters? Who uses that?
Your Table of Contents is based on pre-existing styles. The best way to modify the look is to make changes globally using those TOC styles. If you haven't created the TOC yet, follow these steps: Navigate to the References tab. Select Table of Contents, then...
How to represent [RETURN] key in MS Word?
As a technical writer I've used the following downwards arrow. You could use this one or something similar. It generally represents the Enter key.
How to prevent floated images in MS-Word from jumping around?
By default, a graphic is placed into the document as an inline image at the insertion point. An inline image is a graphic that is treated as a character of text would be treated. As far as Word is concerned, the inline image is just a really big, funny-looking letter....
How can I assign colors and Background Image in Excel?
Background Color To add background color there are a few ways. If you want to add color to a range, you can select the range (or select the entire worksheet by clicking on the box above the cell rows) and then click on the Fill icon on the Home tab. If you...