#1
|
|||
|
|||
how to input data vertically in spreadsheet?
When I input data into a cell, it expands that cell horizontally, I wish to do the opposite by having the data expand vertically [downwards], please see attached doc, thanks. |
#2
|
||||
|
||||
Click "wrap text" on the alignment group from the Home ribbon
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
yes, works thanks! Next issue please, I have dollar and cents amounts in multiple cells all in the same row, is there a way to auto add up the total of those cells please?
|
#4
|
||||
|
||||
I suggest you start a new thread, this question being a totally different topic. Also add a sample sheet with your data. This being a basic question I suspect there is more to it than =sum(1:1) ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display history for spreadsheet data | cjaye | Excel Programming | 11 | 05-08-2012 04:22 PM |
Macro: Exporting Data to a LEGIBLE Excel Spreadsheet | jeffcoleky | Word VBA | 6 | 05-08-2012 08:24 AM |
Data input in Powerpoint? | DeeDubb | PowerPoint | 1 | 04-05-2012 01:53 AM |
Displaying cell data in another spreadsheet | Colonel Biggs | Excel | 0 | 07-01-2010 07:37 PM |
Displaying data from spreadsheet in Userform | darklide | Excel | 0 | 03-12-2010 05:42 AM |