Managing Excel 2013 Workbooks

View:  
Sorted by:  

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…]

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 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 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…]

How to Assign Colors to Worksheet Tabs in Excel 2013

In Excel 2013, you can assign colors to the different worksheet tabs. This feature enables you to color-code different worksheets. For example, you could assign red to the tabs of those worksheets that [more…]

How to Change the Order of Your Excel 2013 Worksheets

Sometimes, you may find that you need to change the order in which the sheets appear in the Excel 2013 workbook. Excel makes this possible by letting you drag the tab of the sheet you want to arrange in [more…]

How to Compare Worksheets Side by Side in Excel 2013

You can use the View Side by Side command button on the Ribbon’s View tab in Excel 2013 to easily do a side-by-side comparison of any two worksheet windows that you have open. This button is the one with [more…]

How to Create a Summary Worksheet in Excel 2013

Excel 2013 offers you various option, including the fascinating option of creating a summary worksheet that recaps or totals the values stored in a bunch of other worksheets in the workbook. [more…]

How to Create a One-Variable Data Table in Excel 2013

When creating a one-variable data table in Excel 2013, you designate one cell in the worksheet that serves either as the Row Input Cell (if you’ve entered the series of possible values across columns of [more…]

How to Create a Two-Variable Data Table in Excel 2013

To create a two-variable data table in Excel 2013, you enter two ranges of possible input values for the same formula in the Data Table dialog box: a range of values for the Row Input Cell across the first [more…]

How to Use the Find Feature in Excel 2013

When all else fails, you can use Excel 2013’s Find feature to locate specific information in the worksheet. Choose Home→Find & Select→Find or press Ctrl+F, Shift+F5, or even Alt+HFDF to open the Find and [more…]

How to Control Recalculation in Excel 2013

In really large Excel 2013 workbooks that contain many completed worksheets, you may want to switch to manual recalculation so that you can control when the formulas in the worksheet are calculated. You [more…]

How to Protect a Document in Excel 2013

After you more or less finalize an Excel 2013 worksheet by checking out its formulas and proofing its text, you often want to guard against any unplanned changes by protecting the document. [more…]

How to Add Sheets to Your Excel 2013 Workbook

Each blank workbook that you open contains a single worksheet given the prosaic name, Sheet1. To add more sheets to your workbook in Excel 2013, you simply click the New Sheet button on the Status bar [more…]

How to Edit Multiple Sheets in Excel 2013

Each time you click a sheet tab, you select that worksheet and make it active, enabling you to edit anything in Excel 2013. You may encounter times, however, when you want to select bunches of worksheets [more…]

How to Use Find and Replace in Excel 2013

If your purpose for finding a cell with a particular entry in Excel 2013 is so that you can change it, you can automate this process by using the Replace tab on the Find and Replace dialog box. If you [more…]

How to Compare Multiple Worksheets in Excel 2013

In Excel 2013, you can split a single workbook into worksheet windows and then arrange the windows so that you can view different parts of each worksheet on the screen. [more…]

How to Move a Worksheet to Another Excel 2013 Workbook

In some situations, you need to move a particular worksheet or copy it from one workbook to another in Excel 2013. To move or copy worksheets between workbooks, follow these steps: [more…]

How to Install Apps for Office in Excel 2013

Apps for Office are small programs that run inside various Microsoft Office 2013 programs, including Excel 2013, to extend their functionality. There are apps to help you learn about Excel’s features, [more…]

How to Load Excel 2013 Add-Ins

Excel 2013 add-in programs are small modules that extend the program’s power by giving you access to a wide array of features and calculating functions not otherwise offered in the program. There are three [more…]

How to Add Hyperlinks to an Excel 2013 Worksheet

Hyperlinks automate Excel 2013 worksheets by making the opening of other Office documents and Excel workbooks and worksheets just a mouse click away. It doesn’t matter whether these documents are located [more…]

Listings:1-2526-46
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com