Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Flush right text ??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Blue Max - 09 Apr 2008 04:09 GMT
How do we right justify a portion of the text entry in an Excel 2007
worksheet cell?  Right and left justify will shift all the text within a
cell to one side or the other.  However, other programs have an option for
'Flush Right' or 'Flush Right with Dot Leaders'.  This allows the user to
enter some left justified text, some dot leaders, and then some right
justified text, all in the same cell.

We would especially like to know if there is a keyboard shortcut for
entering the 'Flush Right' code before typing in the right justified
portion.  Thank you for any help.
Jim Rech - 09 Apr 2008 12:19 GMT
>>How do we right justify a portion of the text entry in an Excel 2007
worksheet cell?

Excel cannot do this.

Signature

Jim

| How do we right justify a portion of the text entry in an Excel 2007
| worksheet cell?  Right and left justify will shift all the text within a
[quoted text clipped - 6 lines]
| entering the 'Flush Right' code before typing in the right justified
| portion.  Thank you for any help.
Blue Max - 11 Apr 2008 01:00 GMT
Thank you, Jim.  I am sorry to hear that!  Other programs have had such a
capability for many, many years.

************
>>>How do we right justify a portion of the text entry in an Excel 2007
> worksheet cell?
[quoted text clipped - 13 lines]
> | entering the 'Flush Right' code before typing in the right justified
> | portion.  Thank you for any help.
Gord Dibben - 11 Apr 2008 20:42 GMT
Just curious.

Which other spreadsheet programs have this feature?

Gord Dibben  MS Excel MVP

>Thank you, Jim.  I am sorry to hear that!  Other programs have had such a
>capability for many, many years.
[quoted text clipped - 17 lines]
>> | entering the 'Flush Right' code before typing in the right justified
>> | portion.  Thank you for any help.
Blue Max - 13 Apr 2008 00:54 GMT
Hello Gord,

I'm sorry, I did not mean to infer that other spreadsheet programs could do
this, just that other types of programs could.  The most releveant examples
are programs that provide this capability with table cells, which behave
similar to spreadsheets.

The best example is WordPerfect which uses CTRL-F7 (or a menu option) to
insert what they call a 'Flush Right' code.  This feature works both in
documents and in tables and does not require any special tabs.  This allows
the user to type left justified text in a table cell (or document) and then
press CTRL-F7 (or the menu option) to right justify the remainder of the
text or CTRL-F7-F7 to right justify with dot leaders.

The next best example is MS Word, but Word requires the creation of a tab
stop at the far right of a cell in order to both left justify and right
justify within the same table cell.  It would have been nicer, however, had
they included a special code or feature that did not require the tab stop.

All said, being able to directly insert a 'Flush Right' or 'Flush right with
dot leaders' is a great feature, both in a word processor and in a table or
worksheet cell.  Perhaps, Microsoft will incorporate this feature at some
point.

Richard

***************
> Just curious.
>
[quoted text clipped - 24 lines]
>>> | entering the 'Flush Right' code before typing in the right justified
>>> | portion.  Thank you for any help.
Gord Dibben - 13 Apr 2008 04:52 GMT
Thanks for the feedback.

Gord

>Hello Gord,
>
[quoted text clipped - 51 lines]
>>>> | entering the 'Flush Right' code before typing in the right justified
>>>> | portion.  Thank you for any help.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.