Excel 2013

Sorted by:  

Excel Order of Operations to Keep in Mind

Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in [more…]

Excel Cell References Worth Remembering

In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change [more…]

Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference [more…]

Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description [more…]

How to Add a Comment to a Cell in Excel 2013

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify [more…]

How to Open Files in the Open Screen in Excel 2013

When the Open screen is first displayed in the Excel 2013 Backstage, the Recent Workbooks option in the Places pane on the left is selected. If the file you want to open isn’t shown in this list in the [more…]

How to Navigate the Open Dialog Box in Excel 2013

After you select a folder and drive in the Excel 2013 Open screen or press the Ctrl+F12 shortcut, Excel displays an Open dialog box. The Open dialog box is divided: the Navigation pane on the left, where [more…]

How to Change the Recent Files Settings in Excel 2013

Excel 2013 automatically keeps a running list of the last 25 files you opened in the Recent Workbooks list on the Open screen when the Recent Workbooks option is selected under Places. If you want, you [more…]

Open File Options in Excel 2013

To access File Open options in Excel 2013, use the drop-down button attached to the Open command button located at the bottom of the Open dialog box. These options enable you to open the selected workbook [more…]

How to Drag and Drop in Excel 2013

The first editing technique you need to learn in Excel 2013 is drag and drop. Drag and drop is primarily a technique for moving cell entries around a worksheet, you can adapt it to copy a cell selection [more…]

How to Copy With Drag and Drop in Excel 2013

What if you want to copy a cell range in Excel 2013? Suppose that you need to start a new table in rows farther down the worksheet, and you want to copy the cell range with the formatted title and column [more…]

How to Change Relative Formulas to Absolute Formulas in Excel 2013

All new formulas you create in Excel 2013 naturally contain relative cell references unless you make them absolute. Because most copies you make of formulas require adjustments of their cell references [more…]

How to Cut and Paste in Excel 2013

Instead of using drag and drop or AutoFill in Excel 2013, you can use the old standby Cut, Copy, and Paste commands to move or copy information in a worksheet. These commands use the Office Clipboard as [more…]

Paste Options in Excel 2013

Excel 2013 displays a Paste Options button with the label, (Ctrl), to its immediate right at the end of the pasted range, after you click the Paste button on the Home tab of the Ribbon or press Ctrl+V [more…]

How to Spell Check in Excel 2013

You’ll be relieved to know that Excel 2013 has a built-in spell checker that can catch and remove all those embarrassing little spelling errors. With this in mind, you no longer have any excuse for putting [more…]

How to Add Text to Speech to the Excel 2013 Quick Access Toolbar

The good news is that Excel 2013 still supports the Text to Speech feature introduced in Excel 2003. This feature enables your computer to read aloud any series of cell entries in the worksheet. By using [more…]

How to Print in Excel 2013

To save paper and your sanity, print your worksheet directly from the Print screen in Excel 2013’s Backstage view by clicking File→Print (or simply pressing Ctrl+P or Ctrl+F2). The Print screen shows you [more…]

How to Adjust Margins in Excel 2013

Excel 2013 offers you several options for adjusting the margins when necessary. The Normal margin settings that Excel applies to a new report uses standard top, bottom, left, and right margins of 3/4 inch [more…]

How to Use the Print Titles Feature in Excel 2013

Excel 2013’s Print Titles feature enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related [more…]

Make Your Own Customized Excel 2013 Header or Footer

Occasionally, you may want to insert information in Excel 2013 that is not available in the stock list boxes or in an arrangement that Excel doesn’t offer in the readymade headers and footers. [more…]

How to Use the Page Break Preview in Excel 2013

The Page Break preview feature in Excel 2013 enables you to spot and fix page break problems in an instant, such as when the program wants to split information across different pages that you know should [more…]

How to Split the Worksheet into Windows in Excel 2013

Although zooming on the worksheet can help you get your bearings in Excel 2013, it can’t split the worksheet into two separate windows so that you can compare their data on the screen. To manage this kind [more…]

How to Freeze Panes in Excel 2013

Panes are great for viewing different parts of the same worksheet that normally can’t be seen together in Excel 2013. You can also use panes to freeze headings in the top rows and first columns so that [more…]

How to Delete a Worksheet from a Workbook in Excel 2013

There may come a time when you will need to delete a worksheet from a workbook in Excel 2013. For some of you, the single worksheet automatically put into each new workbook that you start is as much as [more…]

How to Rename a Worksheet Tab in Excel 2013

You can easily rename a worksheet tab in Excel 2013 to whatever helps you remember what you put on the worksheet. The sheet names that Excel comes up with for the tabs in a workbook [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com