Excel 2013

Sorted by:  

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

How to Record New Macros in Excel 2013

Excel 2013 enables you to add an optional Developer tab to the Ribbon that contains its own Record Macro command button (among other command buttons that are very useful when doing more advanced work with [more…]

How to Run Macros Macro in Excel 2013

After you record a macro in Excel 2013, you can run it by clicking the View Macros option on the Macros button’s drop-down menu on the View tab, the Macros button on the Developer tab of the Ribbon, or [more…]

How to Assign Macros to the Ribbon and the Quick Access Toolbar in Excel 2013

You can assign a macro to a custom tab on the Ribbon or a custom button on the Quick Access toolbar in Excel 2013 and then run it by clicking that custom button. [more…]

How to Share Worksheets in Excel 2013

Excel 2013 makes it easy to share your spreadsheets with trusted clients and co-workers. You can use the options on the Share screen in Backstage view to e-mail worksheets or send them by Instant Message [more…]

How to E-mail Excel 2013 Workbooks

To e-mail a copy of a workbook you have open in Excel 2013 to a client or co-worker, choose File→Share→ Email (Alt+FDE). When you do this, a Send Using E-Mail panel appears with the following five options [more…]

How to Share Excel 2013 Workbooks with IM

If you have access to Skype IM (Instant Message) or have Microsoft’s Lync software installed on the device running Excel 2013, you can share a workbook saved on your SkyDrive by sending a link to a co-worker [more…]

How to Present Excel 2013 Worksheets Online

If the device running Excel 2013 also has Microsoft’s Lync 2013 online communication software installed, you can present your worksheets to the other attendees as part of any online meeting that you organize [more…]

How to Edit Excel 2013 Worksheets Online

Microsoft offers several Office Web Apps for Word, Excel, PowerPoint, and OneNote as part of its Windows Live services that it provides along with your SkyDrive storage in the cloud. You can use the Excel [more…]

How to Review Excel 2013 Workbooks Online without Excel Web App

Sometimes you may find yourself on a device that doesn’t run a web browser that supports the Excel Web App. You can still review workbooks for later use. For example, when you use the Safari web browser [more…]

How to Add Preset Graphic Shapes in Excel 2013

In addition to online and local imported from graphics files, with Excel 2013 you can insert preset graphic shapes in your chart or worksheet by selecting their thumbnails on the Shapes drop-down gallery [more…]

How to Use SmartArt in Excel 2013

Excel 2013 SmartArt is a special type of graphic object that gives you the ability to construct fancy graphical lists and diagrams in your worksheet quickly and easily. SmartArt lists and diagrams come [more…]

How to Use Screenshots in Excel 2013

Excel 2013 supports the creation of screenshot graphics of objects on your Windows desktop that you can automatically insert into your worksheet. To take a picture of a window open on the desktop or any [more…]

How to Use Themes in Excel 2013

Through the use of its themes, Excel 2013 supports a way to format uniformly all the text and graphics you add to a worksheet. You can do this by simply clicking the thumbnail of the new theme you want [more…]

How to Control the Overlap of Graphic Objects in Excel 2013

In case you haven’t noticed, graphic objects in Excel 2013 float on top of the cells of the worksheet and may need some controlling. Most of the objects are opaque, meaning that they hide information in [more…]

How to Print Only the Charts in Excel 2013

Sometimes, you may want to print only a particular chart embedded in the worksheet of Excel 2013 (independent of the worksheet data it represents or any of the other stuff you’ve added). To do this, open [more…]

How to Add Records to Data Lists via the Data Form in Excel 2013

Excel 2013 allows you to add records to data lists by using the data form. The first time you click the custom Form button you added to the Quick Access toolbar, Excel analyzes the row of field names and [more…]

How to Edit Records in the Data Form in Excel 2013

After the database is under way and you’re caught up with entering records in Excel 2013, you can start using the data form to edit and perform routine maintenance on the database. For example, you can [more…]

How to Move Through Records in the Data Form in Excel 2013

Excel 2013 allows you to move through the records you have created in the data form. You can use the scroll bar to the right of the list of field names or various keystrokes to move through the records [more…]

How to Create Charts via the Quick Analysis Tool in Excel 2013

For those times when you need to select a subset of a data table as the range to be charted in Excel 2013 (as opposed to selecting a single cell within a data table), you can use the new Quick Analysis [more…]

How to Move Embedded Charts to Chart Sheets in Excel 2013

Although Excel 2013 automatically embeds all new charts on the same worksheet as the data they graph, you may find it easier to customize and work with it if you move the chart to its own chart sheet in [more…]

How to Place WordArt in an Excel 2013 Worksheet

If selecting gazillions of preset shapes available from the Shapes gallery in Excel 2013 doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the [more…]

Excel 2013: Creating a Data List

Using Excel 2013 to create a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings. To set up a new data list, follow these steps [more…]

How to Add Data to Data Lists Using the Excel 2013 Form Button

Instead of entering the records of a data list directly in the table, you can use Excel 2013’s data form to make the entries. The only problem is that the command to display the form in a worksheet with [more…]

How to Sort Data Lists on Multiple Fields in Excel 2013

You need to use multiple fields in sorting in Excel 2013 when the first field you use contains duplicate values and you want a say in how the records with duplicates are arranged. [more…]


Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.

Inside Dummies.com