Excel 2013

Sorted by:  

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 Edit Comments in a Worksheet in Excel 2013

To edit the contents of a comment in Excel 2013, select it by clicking the Next or Previous command button in the Comments group of the Review tab and then click the Edit Comment button or right-click [more…]

How to Name a Cell or Cell Range in Excel 2013

By assigning descriptive names to cells and cell ranges in Excel 2013, you can go a long way toward keeping on top of the location of important information in a worksheet. Rather than try to associate [more…]

How to Enter a Formula Using Cell Names in Excel 2013

Cell names are a great way to make out the purpose of your formulas in Excel 2013. For example, suppose that you have a simple formula in cell K3 that calculates the total due to you by multiplying the [more…]

How to Create a Constant Formula in Excel 2013

Certain formulas in Excel 2013 use constant values, such as an 8.25% tax rate or a 10% discount rate. If you don’t want to have to enter these constants into a cell of the worksheet in order to use the [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 Cancel Print in Excel 2013

When you click the Quick Print button, Excel 2013 routes the print job to the Windows print queue, which acts like a middleman and sends the job to the printer. If you want to cancel the print job after [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 Edit and Format Inserted Pictures in Excel 2013

Excel 2013 gives the option of editing and formatting inserted pictures. When you first insert an image into the worksheet, it’s selected automatically, indicated by the sizing handles around its perimeter [more…]

How to Use the Goal Seek Feature in Excel 2013

When you need to do analysis, you use Excel 2013’s Goal Seek feature to find the input values needed to achieve the desired goal. Sometimes when doing what-if analysis, you have a particular outcome in [more…]

How to Use the Scenario Manager in Excel 2013

Excel 2013’s Scenario Manager option on the What-If Analysis button’s drop-down menu on the Data tab of the Ribbon enables you to create and save sets of different input values that produce different calculated [more…]

How to Use the Recommended Pivot Tables Button in Excel 2013

You can generate a new pivot table in Excel 2013 in a snap with the new Recommended Pivot Tables command button if creating a new pivot table with the Quick Analysis tool in Excel 2013 is too much work [more…]

How to Manually Create a Pivot Table in Excel 2013

Sometimes, you’ll need to manually create a pivot table because none of the pivot tables that Excel 2013 suggests when creating a new table with the Quick Analysis tool or the Recommended PivotTables command [more…]

How to Filter a Pivot Table Report in Excel 2013

In Excel 2013, perhaps the most important filter buttons in a pivot table are the ones added to the field(s) designated as the pivot table FILTERS. By selecting a particular option on the drop-down lists [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com