Email A Range Of Spreadsheets Cells

BY STANLEY ZAROWIN

Q. How do I send an e-mail that includes a range of spreadsheet data—but not the entire spreadsheet?

A. You can do that without leaving Excel. Begin by highlighting the range you want to transmit. Then click on File and Send To , which generates this screen.

Click on Mail Recipient , which brings up your e-mail function. Fill out the address of the recipient and then click on Send this Selection (see screenshot below), sending the file on its way.

 

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.