Managing Excel 2013 Workbooks

View:  
Sorted by:  

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

How to Mark Up Excel 2013 Worksheets with Digital Ink

If you’re running Excel 2013 with a computer connected to a digital tablet or on a touchscreen, you can mark up your worksheets with digital ink. Excel 2013 running on a computer equipped with a digital [more…]

Share Excel 2013 Workbooks Saved on Your SkyDrive

Excel 2013 makes it easy to share your spreadsheets with trusted clients and co-workers. If you save your workbook files in the cloud on your SkyDrive, you can easily share their worksheets by inviting [more…]

How to Embed and Link Data from Excel 2013 into Word 2013

Of all the Office 2013 programs (besides Excel 2013), Microsoft Word 2013 is the one that you are most apt to use. From time to time, you may need to bring some worksheet data or charts that you’ve created [more…]

How to Turn on Change Tracking in Excel 2013 Workbooks

One way you can share a workbook is by turning on change tracking. When you do this, Excel tracks all changes you make to the contents of the cells in the shared workbook by highlighting their cells and [more…]

Listings:1-2526-46

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.