Printer Friendly
The Free Library
4,474,253 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 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 to the magazine. His e-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...
Grade books made easy. (Electronic Learning).
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 © 2008 Farlex, Inc. | Feedback | For webmasters | Submit articles