Issue with Cell alignment - need only the last line in cell to sho

This might be a strange question, and what I'm doing might be totally silly, 
but I need to know how to make it so that only the last few lines in my cell 
show, as opposed to any of the content before it.

I have a regular, plain old, average Joe spreadsheet.  In one of the 
columns, I am keeping a line-by-line "log" of events that happen with certain 
items in my list.  For example, one cell will read:

"5/12/07:  Followed up with so-and-so, left message, waiting for a return 
call;
5/13/07:  Received call back from so-and-so, was informed of this and that;
5/13/07: Sent complete order request to so-and-so;
5/24/07: Project complete, waiting on paperwork from so-and-so."

Currently, Excel shows somewhere around the middle of the text, but that's 
not useful to  me. I just want the last two lines to show, so resizing isn't 
an option.  I want the rest to be visible only when I double click on the 
cell.

I have toyed around with cell alignment properties and nothing fixes it, 
even if I align everything to the bottom.  I suspect it has something to do 
with how Excel displays data in a cell, and I would like to change that.  Any 
help would be SO appreciated.
0
5/23/2007 12:21:01 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
417 Views

Similar Articles

[PageSpeed] 16

Hi

Maybe in another column, take the last "x" characters of the text e.g.
=RIGHT(B1,20)
Format this cell as wrap text


-- 
Regards

Roger Govier


"CamanoMouse" <CamanoMouse@discussions.microsoft.com> wrote in message 
news:F89C43FB-EE9F-4101-A6B0-F406D96A1378@microsoft.com...
> This might be a strange question, and what I'm doing might be totally 
> silly,
> but I need to know how to make it so that only the last few lines in 
> my cell
> show, as opposed to any of the content before it.
>
> I have a regular, plain old, average Joe spreadsheet.  In one of the
> columns, I am keeping a line-by-line "log" of events that happen with 
> certain
> items in my list.  For example, one cell will read:
>
> "5/12/07:  Followed up with so-and-so, left message, waiting for a 
> return
> call;
> 5/13/07:  Received call back from so-and-so, was informed of this and 
> that;
> 5/13/07: Sent complete order request to so-and-so;
> 5/24/07: Project complete, waiting on paperwork from so-and-so."
>
> Currently, Excel shows somewhere around the middle of the text, but 
> that's
> not useful to  me. I just want the last two lines to show, so resizing 
> isn't
> an option.  I want the rest to be visible only when I double click on 
> the
> cell.
>
> I have toyed around with cell alignment properties and nothing fixes 
> it,
> even if I align everything to the bottom.  I suspect it has something 
> to do
> with how Excel displays data in a cell, and I would like to change 
> that.  Any
> help would be SO appreciated. 


0
roger5293 (1125)
5/23/2007 10:13:27 AM
Reply:

Similar Artilces:

"If in last week" formula
I have a number of simple two column sheets, one column contains dates. Basically each sheet is an employee, and the items list the date and notes for any "one on one meetings" that I have with that employee. I want to have a summary sheet that lets me know when the most recent meeting was. I think it would be ideal to check sheet1-5, if date is older than 1 week, output false or true. I can't find any formula example on the net that uses dates as a condition of true or false. Can anyone point me in the right direction? Does =IF(A1<(TODAY()-7),true,false) work for what ...

See if cell is in Range
Thanks for taking the time to read my question. I'm passing a string that is a cell reference to a function. In that function I want to determine if that cell reference is within a predetermined range. Not sure how to do that. Right now I have: Function CheckRange(TheSheet As String, TheCell As Range) As Boolean If TheSheet = "Sheet1" Then if TheCell In Range("B4:B30") then 'This line is red as it is incorrect CheckRange = True End If What do I use instead of "In"? Thanks, Brad Brad Use something like: If In...

Editing in a cell
I am having a problem with a newly created workbook. When I go to a cell that has data in it and try to add more data to the existing string I lose all the previous information. The work sheet that I am working in is protected and I have "edit directly in cell" checked in the options section. It is almost like my double click (as well as F2) are being treated as a single click. Thank you I figured it out. For some reason "Hide" is selected for the unlocked cells. "John English" wrote: > I am having a problem with a newly created workbook. > > Wh...

Money signs appear in my Cell and I don't want them there
Im trying to enter the numbers 2.9 in cell like AD and it turns it into $2.90. That is not what I need, how do I stop that? Format as General instead of currency -- Regards, Peo Sjoblom http://nwexcelsolutions.com "kate" <kate@discussions.microsoft.com> wrote in message news:E9EEA936-437C-486F-A2D3-2385EF6BD2D0@microsoft.com... > Im trying to enter the numbers 2.9 in cell like AD and it turns it into > $2.90. That is not what I need, how do I stop that? ...

How do I get a cell to remember the last entry and add to it?
I am using Excel 2000. I want my cell to remember the number in it and add an additional number each time I need to retotal. Jab Sounds like you want that cell to be an accumlator cell. Simple question with complex results. You can have a cumulative total in a cell if you have a separate source cell for adding a new total to the original. Use at your own risk. I am Posting this just to show you how it can be done, not as a good solution. You would be much better off to have another column so you can keep track of past entries. Goes like this: =IF(CELL("address")="$C$4&...

Liaison Messenger vs. Forms Printer opinions needed
Hey everybody - Can somebody give me some review of which product they prefer? We need to send out invoices from GP with excel attachment and both of these products look like they can do the job. Any suggestions? Hi-- I don't have as strong opinion, but i have worked with Liaison Messenger mostly. It is easy to use and pretty functional and the support is fabulous. My only issue (or thing that you need to be aware of) is how it is structured. The machine the runs the server application has to be logged in (it can be logged in and locked) with the server app and outlook launched for ...

How do I enter the date last modified in the footer of an Excel d.
How do I enter the date last modified in the footer of an Excel document? I want to be able to distribute a monthly or weekly report in Excel to users and have it automatically update the date last modified in the footer each time I update the report. You need to do that with a Before_Print event macro. If you search the newsgroups from Google you will find lots of examples. On Fri, 4 Feb 2005 09:33:04 -0800, "Last modified date in footer" <Last modified date in footer@discussions.microsoft.com> wrote: >How do I enter the date last modified in the footer of an Excel doc...

Vlookup only the last 6 characters
I have a spreadsheet starting in cell A4. I want to lookup only the last 6 digits in column A and then lookup the value in column J and return the appropriate value from column K. The values in column A are 000322341; 000333456; etc. The values in column J are 322341; 333456; etc. Here is my current non working formula... =VLOOKUP(RIGHT(A4,6),$J$4:$K$7,2,0) Any help would be appreciated. Thanks. The RIGHT function is returning a text value, and I'm guessing that the values in column J are true numbers. So you'd need to covert the text back to numbers in order to...

looking for range of text in a single cell
I just started a new job and my company already had a file with abou 16,000 records in it (called Products). This file contains all of th parts numbers that they carry. In this file there is one column calle "description". This cell contains the dimensions, color name and som other information such as if the piece is flat or rounded. I hav another file that has about 400 records and this file tells me "colo name" as well as the "type" of stone that it is (called Stone_Type). What I am trying to do is add a field to the Products file that wil say stone type. ...

Check Alignment accounts payable
Hello, What/How do I customize my check alignment to fit my chech stock? How can I move around date, Invoice vendor name etc? Thanks D You will need to use Great Plains' built-in Report Writer to do this. If you don't know how to use it, your best bet is to talk to a local Great Plains partner organization that can teach you how to do it. Alternatively, you could take an ecourse on Report Writer. "David Chang" <DavidChang@discussions.microsoft.com> wrote in message news:F114F827-E848-4FFE-B323-9D8C0D346DE0@microsoft.com... > Hello, > > What/How do I c...

Do I need to run eseutil?
Was reviewing 1221 events in application log and spotted a jump in available space from 500MB to about 3000MB in one night. Recently ran eseutil against the database. Does this jump in free space mean I may need to run it again? No, it just means you wasted your time the last time you ran it. I see no reason to run an offline defrag unless you are out of disk space and have no other options, are running against the 16GB standard limit or have moved a "substantial" number of mailboxes and created a large amount of white space in the database. On Mon, 18 Oct 2004 15:55:08 -0700, ...

To have a 'fixed cell' be equal to the last data entered cell in a column
Good Evening All, I have a worksheet, example below. I have frozen the panes to always show rows 1-3. I wish the cell A3 to be the same as the last 'non-blank' cell in Column A.(See explanation below). A B 1 2 Header Header 3__________________ 4 M1004 5 M1005 6 M1002 7 M1003 8 M1006 9 M1001 10 So in this case, at present, A3 would be M1001,(A9), but when I enter a new value in A10, (eg M1008), I would like A3 to automatically update to A10 ie M1008. I think that maybe INDIRECT or OFFSET maybe involved but am fairly unfamiliar with ...

PWA 2007 Database Field for Tasks Updates That Need to be Submitte
Does anyone know what project server database table and field that could be used in a custom report to tell which task assignment updates that have been saved but still need to be submitted to the project manager? Gary ...

How do I have a cell update itself only if it's currently blank?
I need to track to retain the first value of a date field. Each time I load the worksheet the date field has the potential to change, I need to keep track of the initial date in addition to the current date that is in the field. I have date columns called ASSIGNED and 1st ASSIGNED. The initial value of both will be blank. At some point the ASSIGNED will be populated with a date. When it is populated for the first time I want to save this value in the 1st ASSIGNED column. I need something like: IF ( ISBLANK(ASSIGNED), "", ASSIGNED ) in my 1st Assigned cell, however, I do not ...

Help
Hi guys! I need a formula that does this: OK I'm going to draw a spreadsheet ......A..........B...... 1..100.....dog.... 2..150...<blank> 3..200......cat..... so all I want is a formula that looks in Column B and if there is ANY text at all, returns the value in Column A So I want it to look into B1 and it will see text there and return "100", but if it looks in B2 and sees that it is blank, it just won't return anything. Can I do this? Seems like it would be a combination of IF and LOOKUP or something. Thank you. -- Bran987 ----------------------------------...

Changing Font Colour if cell is certain word?
Can I make the font of a certain cell change it's font colour to Red if the word in the cell is, example, "Fail"? I want the change to apply from B2:F23. -- wuming79 ------------------------------------------------------------------------ wuming79's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36037 View this thread: http://www.excelforum.com/showthread.php?threadid=560169 Use "Conditional Formatting". It's on the Format menu -- MartinShor Software Tester &amp; Musicia -----------------------------------------------------...

Can I link *.jpg files to Excel cells?
I would like to connect pictures to cells on a spreadsheet. Ideally, I'd like to connect more than one to a cell. Or to its row. That would work OK also. Can I do it? TIA LAS You can hyperlink a cell to an image stored elsewhere or to an image stored within the workbook. How you do it depends upon the purpose of the linking and the ultimate results you are looking for. Gord Dibben MS Excel MVP On Fri, 25 Jun 2010 17:26:13 -0400, "LAS" <FakeMail@Hotmail.com> wrote: >I would like to connect pictures to cells on a spreadsheet. Ideally, I'd >lik...

Macro-unknown num of lines
Hi there, I am currently trying to write my first macro! I have written the macr and it does what its meant to. However, every day the file the macr works on is of different length and when i look into the VB part of th macro in the code its only performing the action to 250 lines. Is ther any way to set the macro to check how many lines are in the file fo that day and then to run on that many lines? If that makes any sens i'd be grateful for any help! Thanks, Juli -- Message posted from http://www.ExcelForum.com Hi Julie Something like this ? Sub test() Dim L As Long L = Sheets(1)...

I Need Script create account email
Hello partners and happy year, to have if you can throw a help. Am I looking for a script automatically to create mail bills in Outlook 2003, that is to say, to pass him/her a script to a commercial one that requests him/her user / password - POP Servant / SMTP and does the bill believe, is it possible to locate him in some place?. There is looking for for Google and I don't see na. ...

Adding random cells togethr
I want to be able to add y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2 together and return the result in bb2 I am using =sum(y2,aa2,ac2,ae2,ag2,a12,ak2,am2,ao2,aq2,as2,au2,av2,ax2,az2) however I only see the actual formula returned in the cell not the result. I have been able to do this in the past. Can anyone help with this problem? -- Kaylean Hi Kaylean, Perhaps BB2 was formatted as text before you entered the formula. Select it and hit F2 and Enter. HTH Regards, Howard "Kaylean" <Kaylean@discussions.microsoft.com> wrote in message news:0DF3C2DC-8918-...

Cross Tab Line Numbers
I have two fields, Emp_ID and Proj. Each employee could have as many as 10 projects at any given time. What I want to do is build a CrossTab Query that has the emp_id as column headers and under each name the list of projects assigned to them. So what I was trying to do is to create a linenumber of some sort between 1 and 10 to go with each record so that when I pull the Query into the Cross tab query I could use the number as row headers. Pleae help! Example of what I want limit to 5 to save space (not 10): no. Emp1 Emp2 Emp3 ..... 1 proj1 proj2 proj8 2 proj3 proj5...

cell ranges in formulas
When referencing a cell range in a formula, is there a way to represent the cell range by referencing another cell. What I want to do is this, for example: say cells a1 thru a100 contain a number of values. I want to sum a certain subset of these today, but tomorrow I want to change that subset, so I'd like to enter the starting and ending point for my sum range into another cell, say b1 & b2 So if I enter the text "a6" in cell b1, and "a25" in cell b2, my sum formula should look like =sum(a6:a25). This give me the flexibility to change my sumrange very e...

Rename a sheet tab when cell contents change
Hi all, I would like to rename a sheet tab when a specific cell's contents change...is this possible to code? I am using Excel 2003 (but need some backward compatibilty...) TIA, Miki activesheet.name=range("b1") -- Don Guillett SalesAid Software donaldb@281.com "Michelle" <miki@spam_me.net> wrote in message news:tHmzb.290244$275.1012789@attbi_s53... > Hi all, > > I would like to rename a sheet tab when a specific cell's contents > change...is this possible to code? I am using Excel 2003 (but need some > backward compatibilty...) > >...

Diagonal Cells format
How do I format the Label Row of a spreadsheet to be 45 diagonally instead of the standard horizontal format? Thanks Ross Hi Ross select the cells, choose format / cells - go to the alignment tab and play with the little dial on the right hand side of the dialog box (or type numbers in the box underneath). Cheers JulieD "Ross" <Ross@discussions.microsoft.com> wrote in message news:DD627596-2F68-4886-A058-AE7EBE2CB427@microsoft.com... > How do I format the Label Row of a spreadsheet to be 45 diagonally instead of > the standard horizontal format? > > Thanks &g...

CRM 1.2 to CRM 3.0 Upgrade Active Directory Issues
Hi, It was decided to reinstall CRM 3.0 after a successful upgrade from Version 1.2 (Except reporting services). As part of the install a mistake was made and therequired groups for CRM 3.0 upgrade from 1.2 were deleted (PrivUserGroup, SQLAccessGroup, UserGroup, ReportingGroup). We manually recreated them. Now in trying to reinstall CRM 3.0 on an already upgraded and exsitng MSCMR Database, we keep getting stopped at the Verification Tasks under the section of "Microsoft CRM User Input" with a error that "One or more of the Microsoft CRM Groups do not exist". Al...