Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - How to get two rows of data within one cell 1

Status
Not open for further replies.
pipk

pipk

Programmer
Feb 20, 2001
455
GB
This may be a really basic question, but I am by no means an advanced user of excel.

Not sure if it can be done, but I need to store two elements of data within one cell - one on top of the other.

Is there anyway to do this?

Many thanks
 
Sort by date Sort by votes
After you type the first element in, press Alt and Enter and it will let you stack data inside a cell.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
504
combo
combo
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
463
combo
combo
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
758
SkipVought
S
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
239
combo
combo

Part and Inventory Search

Sponsor

Back
Top