Printer Friendly
The Free Library
14,581,695 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Enter several sets of numbers in one excel cell.


Q. Is there a way to put several sets of numbers--such as codes--into one Excel A full-featured spreadsheet for Windows and the Macintosh from Microsoft. It can link many spreadsheets for consolidation and provides a wide variety of business graphics and charts for creating presentation materials.  cell with each set on its own separate line?

A. You mean like this?

The trick is to press Alt+Enter each time you want the line in the cell to break.

STANLEY ZAROWIN, a former JofA senior editor, is now a contributing editor A contributing editor is a magazine job title that varies in responsibilities. Most often, a contributing editor is a freelancer who has proven ability and readership draw.  to the magazine. His e-mail address See Internet address.

e-mail address - electronic mail address
 is zarowin@mindspring.com.
COPYRIGHT 2005 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2005, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Nov 1, 2005
Words:69
Previous Article:Customize keyboard shortcuts for word.(Technology Q&A)
Next Article:Out, out, green triangles.(Technology Q&A)



Related Articles
Hey, what if ...?(financial software)
Vigilant spreadsheets: make data analysis fast and easy.(Cover Story)
Technology Q&A: sort Excel cells that contain text and numbers ... Give Excel cells a descriptive name ... Get Excel to produce the right number of...
Make Excel a little smarter: teach your spreadsheets some useful tricks.
Collaborate on spreadsheets: how to share Excel files with others on your network.
Ferret out spreadsheet errors: use Excel's tools to uncover and correct formula problems.
A do-it-yourself automated invoicing system: even a CPA with little computer training can build one.
Make Excel speak faster.(Technology Q&A)
The power of arrays: the Excel tool that performs multiple functions in a single step.

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles