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 (£).
Whether you’re using a Chromebook or you’re just interested in switching from installed desktop apps to browser-based ones, web-based software can replace many of the programs people use on their computers — and can often improve on them.
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.
So you want to buy a tablet — you have a choice between the iPad, Android tablets, and now Windows 8 or Windows RT tablets. Windows tablets are often the most expensive. Software availability is crucial when using a tablet.
Our latest edition of WIG is filled with news link coverage on topics such as Google Earth for Android gets Street View, Canonical plans to have dogfood-capable phones by the end of May, UEFI will make its way into mobile and non-PC markets, and more.
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.
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.
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.