If you’re working on a long document in Word, you’ll probably be opening it often until it’s completed. Rather than opening Word to the general start screen, and then opening the file, you can automatically open the last document you were working on.
In Word 2013, you can select one of several units of measurement for the ruler. You may be working on a document for someone who measures their margins, tabs, etc. in a different set of units than you usually use. It’s easy to change.
By default, Word automatically saves your document at certain intervals. If you’re concerned about losing data, you can decrease the interval. If you’re distracted by the hard drive crunching too often, you can increase the interval. Either way, changing this interval is easy.
Microsoft Word has been able to publish content to blog platforms since Office 2007. The feature is still available and has matured to a point where it gives Windows Live Writer a run for its money. Here is how to get set up.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 (£).
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.
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.
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.