LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jim May
 
Posts: n/a
Default

Can't believe that I omitted saying to you to press the Alt + Enter TWICE
between the 1st and 2nd line and also twice between the 2nd and 3rd line.
daaaa..

"Jim May" wrote:

Q1- Each cell in the spreadsheet is independent;
With a given cell selected, go to Data, Validation..
If dialog box "shows no validation data, then none exists".
Q2 - To enter into a cell as you describe, in a blank cell
type:
Line1 << do not press enter, instead press Alt (key) + Enter simultaneously
(enter) Line2 << do not press enter, instead press Alt (key) + Enter
simultaneously
(enter) Line3 << Now press just enter


"Polina" wrote:

Validation: I am in the cell that has the validation selection, but when I
select validation I cannot see where the person who created the sheet put the
validation choices, how can I find where he typed in his validation table of
choices.

Spacing: I want to have a cell where I can type three lines of text and have
a space between each line without it having to go into a new cell. So I want
the three lines of text and three blank lines in between in one cell.


Thanks for the help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation lists [email protected] Excel Discussion (Misc queries) 5 June 25th 05 07:44 PM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Data Validation Mike R Excel Discussion (Misc queries) 11 May 6th 05 02:38 AM
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"