New Horizons Get Schooled Blog

For your eyes only: Customize your document’s page color to reduce eye strain (Word 2016)

Posted on 12/3/18 8:57 AM by Get Schooled in Word, in word tips and tricks

Staring at a computer screen all day takes a significant toll on your eyes. When shutting down your computer just isn’t an option, changing your document’s color from bright white to something more soothing may soothe your eyes. Open your document and choose the Design tab on the main ribbon. In the Page Background group, click on Page Color. Choose a less glaring color such as light grey or blue from the resulting dropdown menu.

This new background color affects your onscreen display only. Your printed document retains a white background.

0 CommentsContinue Reading →

Fix form mistakes quickly with these handy keyboard shortcuts (Access 2016/2013/2010)

Posted on 10/30/18 8:00 AM by Get Schooled in Word

If you make a mistake while working in a form, you can easily undo the last changes you made. To undo your last change to a form field, press [Esc]. To clear every change you made to the entire form, press [Esc] twice. If you made a typo in a text box and wish to remain in that text box control, simply press [Backspace] until you’ve removed the entire typo, then continue typing.

0 CommentsContinue Reading →

Call on your Editor to improve your writing and word choice (Word 2016)

Posted on 10/30/18 8:00 AM by Get Schooled in Word

Word’s Editor will proofread your document, marking errors in spelling and grammar, and even making suggestions regarding your writing style. To use the Editor tool, press [F7]. The Editor task pane appears, giving an explanation for each error or suggestion, and then listing options for fixing or ignoring the situation. To make your review even easier, the Editor color codes everything: a red wavy line for spelling errors, a blue double underline for grammar issues, and gold dotted lines for writing style suggestions. Once you’ve addressed the issues in the Editor task pane, click on the X in the upper-right corner of the task pane to dismiss it.

0 CommentsContinue Reading →

Translate document text into another language (Word 2016)

Posted on 9/14/18 10:40 AM by Get Schooled in Word

In today’s global workplace, creating documents for use in multiple languages is increasingly important. Whether it’s for a single word or an entire document, Word provides the instant translation tools you need. To translate a word or phrase, select the word and right-click on it. Select Translate from the shortcut menu.

If you haven’t used this tool before, you may encounter the Use Intelligent Services dialog box. In this dialog box, click on Turn On. The Translator task pane appears, displaying your selected word in the From box. Ensure that Word has detected the correct language you are translating from, and then select your desired language from the dozens of options on the To dropdown list. You can use this translation to add a note to your document, or you can click Insert to replace the selected word with its translation.

To translate an entire document, open that document and select the Review tab on the main ribbon. In the Language group, click on Translate | Translate Document. In the resulting Translator task pane, designate the appropriate languages in the From and To dropdown lists, and then click OK. After a few moments, your translated document opens. Click Save on the Quick Access Toolbar, and save your new document.

Important: Consider this translation tool as a starting point. It’s important to check the accuracy of your document’s translation before disseminating it to others.

0 CommentsContinue Reading →

Replace all instances of a special character automatically (Word 2016/2013/2010)

Posted on 7/12/18 9:12 AM by Get Schooled in microsoft word, in Word, in word tips and tricks

Word’s Find And Replace feature can recognize special characters, as long as you know the character’s ASCII code. For example, let’s say you wrote an entire marketing document for your company’s new product, DermaCréme, before realizing that the product’s name is actually DermaCrème. Rather than hunt through the document for each instance of the product name, you can automate your search using Word’s Find And Replace feature. But first, we’ll make a stop at the Symbol dialog box to gather information.

Select an instance of the letter é in your document. Select the Insert tab on the ribbon, and then in the Symbols group click on Symbol | More Symbols. In the resulting Symbol dialog box, you’ll note that é is already selected. Choose ASCII (decimal) from the From dropdown list, and make a note of the character code, 233. Next, click on the è symbol, and note that its ASCII (decimal) code is 232. Also note that these are four-digit character codes, so Word has removed the initial zero.

Press [Ctrl] H to open the Find And Replace dialog box. In the Find What text box, type DermaCr^0233. Note that we included the initial zero before the number we found in the Symbol dialog box. In the Replace With text box, type DermaCr^0232, and then click Replace All to fix the entire document at once.

0 CommentsContinue Reading →

How to Create a Chart in Word from Table Data

Posted on 2/10/17 12:02 PM by Get Schooled in Word

1. Select data within the table to chart. Copy the data – not the totals. Click outside the table where the chart will be placed.
2. Insert > Illustrations command group > Chart.
3. A chart gallery appears. Select a chart type. Click OK.
4. A sample series spreadsheet "Chart in MS Office Word" appears.
5. Clear the data in the sample chart. Click in A1 to paste the original data into the spreadsheet, replacing the existing sample data. If you don't clear the sample data, it may be necessary to delete sample data rows or columns.
6. A chart redraws in Word to reflect the original data. Close the spreadsheet window.
7. Resize the chart as needed, stretching or shrinking with the corner handles.
8. To edit the spreadsheet data, click once on the chart to activate it. Click on the Edit Data button (Chart Tools contextual tab > Data command group > Edit Data).

0 CommentsContinue Reading →

Set Variable Headers and Footers for Multi-Page Templates

Posted on 10/7/14 12:19 PM by Get Schooled in footers, in headers, in headers and footers, in Microsoft, in microsoft word, in Word, in template, in Tips & Tricks

When you're creating a template, you'll often want the header and footer on the document's first page to be different than the header and footer used on subsequent pages. A letterhead template is a classic example--typically, the first page of the letter should include your company letterhead, whereas subsequent pages should not. However, not all of your letters will be two or more pages in length. How then can you set up the headers and footers for subsequent pages without adding an unwanted extra page to your template? The trick is to create a ghost page in your template, apply the desired header and footer to the ghost page, and then remove the ghost page before you save the template.

0 CommentsContinue Reading →

Keyboard shortcuts for easy paragraph alignment

Posted on 7/9/13 8:30 AM by Get Schooled in Excel, in Justification, in keyboard shortcut, in Lists, in Microsoft, in microsoft office, in Office, in Word, in powerpoint, in Tips & Tricks

There are many ways to change the alignment of a paragraph in Microsoft Office: you can click the Align Left, Center, Align Right, or Justify buttons on the Formatting toolbar (the Home tab's Paragraph group in Word 2007 and 2010); you can also select Format | Paragraph, click on the Indents And Spacing tab, and choose the desired setting from the Alignment dropdown list.

0 CommentsContinue Reading →

Possible security flaw in password-protected Excel documents

Posted on 10/9/12 9:00 AM by Get Schooled in encryption, in Excel, in IT News, in Microsoft, in security, in Word, in password

A report has recently surfaced concerning a potential security flaw in Microsoft Office applications, particularly Microsoft Word and Excel. The flaw concerns documents that are password-protected for security reasons. According to the report, encrypted documents may be easy to break into if the attacker has two copies of the document--even two copies that have been edited and saved.

0 CommentsContinue Reading →

Speed up your scrolling in large Word documents

Posted on 6/6/12 4:35 PM by Get Schooled in Microsoft, in Word, in Tips & Tricks

If you're editing a large document that also includes a number of images, you may find that scrolling is quite slow. This happens because Word has to load each image as you scroll, which can make your productivity drag.

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.


    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.