Excel 2013 Workbooks

Sorted by:  

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

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 Copy Custom Styles in Excel 2013

Excel 2013 makes it easy to copy custom cell styles that you’ve saved as part of one workbook into the workbook you’re currently working on. To copy custom styles from one workbook to another, follow these [more…]

How to Split an Excel 2013 Worksheet into Panes

Excel 2013 enables you to split the active worksheet window into two or four panes. After splitting up the window into panes, you can use the Excel workbook’s horizontal and vertical scroll bars to bring [more…]

How to Download a Spreadsheet Template in Excel 2013

Anytime you launch Excel (without also opening an existing workbook file), the Excel screen in the Backstage view presents you with a choice between opening a new workbook or opening a new workbook based [more…]

How to Save Changes to Customized Templates in Excel 2013

Save customization to any Excel 2013 templates you download to make the workbooks you create from them easier to use and quicker to fill out. For example, you can make your own custom Quarterly Sales Report [more…]

How to Assign Graphic Images as Excel Worksheet Backgrounds

You can also assign a graphic image to be used as the background for all the cells in an entire worksheet in Excel 2013. Just be aware that the background image must either be very light in color or use [more…]

Transfer Sheets from One Excel 2013 Workbook to Another

Instead of copying cell ranges from one workbook to another, you can move (or copy) entire worksheets between workbooks in Excel 2013. You can do this with drag-and-drop or by choosing the Move or Copy [more…]

Excel 2013 and PowerPoint 2013

The process of embedding and linking Excel 2013 worksheet data and charts in the slides of your Microsoft PowerPoint 2013 presentations is very similar to the techniques outlined for Word. To embed a cell [more…]

How to Save Excel 2013 Worksheets as HTML Files

If converting your Excel 2013 worksheets to PDF or XPS files is way too complex for your needs, you can save your worksheets as good old HTML files for viewing and printing in anybody’s web browser [more…]

How to Protect Your Excel Workbook when Saving the File

If you’re dealing with an Excel 2013 spreadsheet whose data is of a sensitive nature and should not be modified by anyone who’s authorized to open it, you need to set both a password for opening and a [more…]

Assign a Password to Open from the Excel Info Screen

Instead of assigning the password to open your Excel 2013 workbook at the time you save changes to it, you can do this as well from the Info screen in the Backstage view by following these simple steps [more…]

How to Enable Excel Cell Range Editing by Certain Users

You can use the Allow Users to Edit Ranges command button in the Changes group on the Review tab of the Excel 2013 Ribbon to enable the editing of particular ranges in the protected worksheet by certain [more…]

How to Protect a Shared Workbook

Many times you will want to protect an Excel 2013 workbook that you intend to share on a network. That way, you can allow simultaneous editing of the contents of its worksheets [more…]

How to Prepare Excel 2013 Workbooks for Distribution

The Info screen in the Excel 2013 Backstage view (Alt+FI) enables you to prepare your workbook for distribution by inspecting the properties of your workbook. To do this, click the Check for Issues button [more…]

How to Add a Digital Signature to Excel 2013 Workbooks

Excel 2013 enables you to add digital signatures to the workbook files that you send out for review. After checking the spreadsheet and verifying its accuracy and readiness for distribution, you can [more…]

How to Merge Changes from Different Excel 2013 Users

At some point after sharing an Excel 2013 workbook, you’ll want to update the workbook to incorporate the changes made by different users. When merging changes, you may also have to deal with conflicting [more…]

How to Accept or Reject Changes in Excel 2013 Workbooks

When you turn on change tracking for an Excel 2013 workbook, you can decide which changes to accept or reject by choosing the Accept/Reject Changes option from the Track Changes command button’s drop-down [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com