How to format cell to display bottom text

**aldmph** · 04-30-2013, 12:09 PM

Hi. I'm working with Excel 2007, and I'm creating a spreadsheet that will function as an ongoing project status update. I want to have fixed row height (which I know how to do) but format the status/notes column to display only the most recent updates, i.e, the bottom text within the cell. Can anyone offer a solution, please? Thanks!

**tigeravatar** · 04-30-2013, 01:08 PM

aldmph,

Welcome to the forum!
I think something like this is what you're looking for:

Please Login or Register  to view this content.

**tigeravatar** · 04-30-2013, 01:10 PM

That formula will show the bottom text of whatever is in cell A1.
If you mean you want the bottom text displayed instead of other text within the same cell, I don't think you can do that without VBA

**aldmph** · 04-30-2013, 01:19 PM

Thanks, but I have absolutely no idea what you're telling me to do. Where would I input that formula? And yes, I want the bottom text displayed instead of other text within the same cell. What's VBA?

**tigeravatar** · 04-30-2013, 01:35 PM

aldmph,

Attached is an example workbook based on the criteria you described.
Row 1 is a header row so actual data starts in row 2
Column A is the Project Name
Column B is the Status/Notes
Column C is the formula to show only the bottom text of column B

In cell C2 and copied down is this formula:

Please Login or Register  to view this content.

VBA stands for Visual Basic for Applications. It is the programming language behind MS Office products (like Excel) that governs how it works. You can create custom code to make something specific to your needs happen. If you can't use the formula solution, then VBA may be the only way to go.

However, I would offer an alternative. Why not enter the notes so that the most recent note is on top instead of on bottom? Then there's no need for either the formula or VBA, and the cell will display the most recent note without any additional formatting.

**aldmph** · 04-30-2013, 01:59 PM

Thank you for going to all this trouble. I understand what you're telling me to do. Unfortunately, I can't format the spreadsheet with a separate "last update/bottom text" column. Wouldn't be well accepted. Oh well, your idea of reversing chronological order will work, and I may do that. Thanks for all of your help!

**kogajak** · 10-10-2019, 02:28 AM

Thank you for this post! Event if its old it saved me lots of hours of work.

**Pepe Le Mokko** · 10-10-2019, 02:34 AM

@kogajak
Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "Space" ( country will suffice, no need to be more precise).
Thank you for helping us to help you