SEARCH

OFFICE ARTICLES / MICROSOFT OFFICE, GOOGLE DOCS, AND MORE

When you open an Office 2013 program, a start screen automatically displays showing you the various templates available and a list of recent documents opened in the left column. If you find this screen annoying and would rather pass it by, it’s easy to disable.

about 9 months ago - by  |  2 Replies

There may be times you want to remove a row or column from a spreadsheet, but you don’t want to permanently delete it from the worksheet file. Excel has a feature that allows you to temporarily hide a row or column from view.

about 9 months ago - by  |  2 Replies

If you’ve copied text from another document and it’s not formatted the way you want, or it has some strange or mixed up formatting, you can easily remove all the formatting from the text and return the text to the default style.

about 10 months ago - by  |  5 Replies

Have you entered some text in columns separated by tabs and you want to convert it to a table? Word provides a useful feature that allows you to quickly convert text to a table and a table to text.

about 10 months ago - by  |  Leave a reply

Have you created a long table in Word only to discover that the rows need to be rearranged? Luckily, it’s very easy to move rows up and down within a table using an easy keystroke combination.

about 10 months ago - by  |  Leave a reply

Jumping to a specific page in Word is a common task and easy to do using the Find and Replace dialog box. You can also use this same tab to jump from one table directly to the next table in your document.

about 10 months ago - by  |  Leave a reply

The Auto-Complete feature in Outlook 2013 automatically fills in names and email addresses for you when entering them in the To or Cc fields. Based on the characters you start to enter, Outlook displays a list of possible choices that match what you’ve entered.

about 10 months ago - by  |  1 Reply

If you are working on a large spreadsheet where all the rows and columns of data don’t fit on the screen, it would be helpful to be able to keep the heading rows and columns stationary so you can scroll through the data.

about 10 months ago - by  |  Leave a reply

If you’re writing a long Word document containing a lot of images, you may want to add captions to those images. You can then reference the images by their number in the text as well as generate a Table of Figures.

about 10 months ago - by  |  1 Reply

If you’re working in Word and you need to total values in a table, you can do so without having to enter the data into Excel and then copy and paste it into Word. Word can do simple calculations such as summing, multiplying, and averaging.

about 10 months ago - by  |  2 Replies

You may find you need to change multiple cells from one case to another in Excel. Maybe you imported data that came in all upper case, or maybe you convert headings on columns to upper case. Changing case is easy using some special functions.

about 11 months ago - by  |  Leave a reply

RSS stands for “Really Simple Syndication” or “Rich Site Summary.” It’s a document specification that allows you to easily collect and organize web-based news and information from websites in a standardized format commonly called a feed, which is like a bookmark that actively updates itself.

about 11 months ago - by  |  Leave a reply

The Common Feed List is a list of subscribed RSS Feeds that is saved with your Windows user profile. RSS clients, including Windows Internet Explorer and Outlook, use this list allowing you to configure your RSS subscriptions in one location for multiple readers.

about 11 months ago - by  |  Leave a reply

Have you switched to Microsoft Word from WordPerfect? Do you remember the Reveal Codes feature in WordPerfect that made it so easy to see exactly how your document was formatted? Well, you can get that feature now in Word using a free tool called CrossEyes.

about 11 months ago - by  |  7 Replies

When you open an Excel worksheet or change any entries or formulas in the worksheet, Excel automatically recalculates all the formulas in that worksheet by default. This can take a while if your worksheet is large and contains many formulas.

about 11 months ago - by  |  2 Replies

To find a specific date in the calendar in Outlook, you can scroll through all the weeks and months. Or, you can save some time using the Go To Date feature and enter a date to which you want to jump.

about 11 months ago - by  |  1 Reply

We’ve previously shown you how to add keyboard shortcuts to symbols in Word 2013 to make it easier to insert them into your documents. Keyboard shortcuts can be added to symbols in Excel as well, but there’s no direct method.

about 11 months ago - by  |  1 Reply

Hundreds of symbols that are not available on your keyboard are provided in Microsoft Word for use in your documents. For example, you can insert fractions (½), a degree symbol (°), pi (π), or currency symbols, such as the British pound symbol (£).

about 11 months ago - by  |  5 Replies

Many commands in Word have keyboard shortcuts assigned to them, making it quicker to apply formatting, save the file, and perform other tasks on your documents. These keyboard shortcuts can be customized, and you can assign shortcuts to commands that do not currently have them.

about 11 months ago - by  |  1 Reply

One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Macros provide an ideal way to save time on predictable, repetitive tasks as well as standardize document formats – many times without having to write a single line of code.

about 11 months ago - by  |  5 Replies

There may be times when you want to create a new Excel worksheet based on an existing worksheet. You can easily copy an entire worksheet in Excel to a new worksheet in the same file or even to a new, separate workbook file.

about 11 months ago - by  |  3 Replies

When entering formulas in Excel, you may want to remind yourself, or someone else, what it was for in the future. Or you may want to add instructions to let users of your spreadsheet know what to do in certain cells.

about 11 months ago - by  |  2 Replies

By default, Excel recalculates all the formulas in your worksheet automatically when you open your worksheet or change any entries, formulas, or names on which your formulas depend. If you worksheet is large, with many formulas, this can take several seconds or minutes.

about 12 months ago - by  |  1 Reply

Microsoft attempted to make typing appear smoother in Office 2013 by adding a typing animation feature. If you’re a slow typist, you probably won’t notice it. However, if you type upwards of 80+ words per minute, this feature can be distracting and annoying.

about 12 months ago - by  |  7 Replies

Previous versions of Excel have had an option for viewing two spreadsheets side-by-side. However, Excel 2013 now makes it easier by allowing you to snap each spreadsheet (opened in separate windows) to each side of the screen.

about 12 months ago - by  |  Leave a reply