Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-03-2007, 11:31 AM   #1
DanG
Newly Registered User
 
DanG's Avatar
 
Join Date: Nov 2004
Posts: 477
Thanks: 1
Thanked 1 Time in 1 Post
DanG is an unknown quantity at this point
Text Too Close To Edge

My text is too close to the cells edge and I'm not sure how to adjust it.
Is there a setting to adjust the "padding" of a cell?

Thank you

__________________
You just pick up a chord, go twang, and you're got music
~ Sid Vicious

I use A03
DanG is online now   Reply With Quote
Old 07-03-2007, 12:13 PM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Have you tried selecting a cell and going to Format>Alignment?
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is online now   Reply With Quote
Old 07-03-2007, 12:44 PM   #3
shades
Registered User
 
Join Date: Mar 2002
Location: Fly-over territory
Posts: 516
Thanks: 0
Thanked 1 Time in 1 Post
shades is on a distinguished road
On the toolbar, there is a button which increases Indent. Try that
________
Dc marijuana dispensary


Last edited by shades; 02-16-2011 at 01:23 AM.
shades is offline   Reply With Quote
Old 07-03-2007, 01:05 PM   #4
DanG
Newly Registered User
 
DanG's Avatar
 
Join Date: Nov 2004
Posts: 477
Thanks: 1
Thanked 1 Time in 1 Post
DanG is an unknown quantity at this point
In the end I would like the text aligned to the right with about .1, .2...from the right edge so it's not so close to the text next to it.

If I do indent increase I have to use left text align to scoot the text over and then it looks funny, that's why I described it as padding. I thought I had done this in the past (on an older version (maybe on MS Office 4.3 you could).

Thanks for the help.
__________________
You just pick up a chord, go twang, and you're got music
~ Sid Vicious

I use A03
DanG is online now   Reply With Quote
Old 07-03-2007, 01:10 PM   #5
Squidinker
Registered User
 
Join Date: Jun 2007
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Squidinker is on a distinguished road
Dan, why not just Right Align the whole column then use indent?
Squidinker is offline   Reply With Quote
Old 07-03-2007, 03:31 PM   #6
shades
Registered User
 
Join Date: Mar 2002
Location: Fly-over territory
Posts: 516
Thanks: 0
Thanked 1 Time in 1 Post
shades is on a distinguished road
Actually, numbers are formatted two different ways. If you want a little extra, then use the comma format button, and you will get the increased space at the right side with proper alignment.
________
Vortec engine

Last edited by shades; 02-16-2011 at 01:23 AM.
shades is offline   Reply With Quote
Old 07-06-2007, 08:41 AM   #7
DanG
Newly Registered User
 
DanG's Avatar
 
Join Date: Nov 2004
Posts: 477
Thanks: 1
Thanked 1 Time in 1 Post
DanG is an unknown quantity at this point
Shades,

Thanks I'll give it a try.

Squidinker,

Right align has pretty big increments and in my case just serves to center the numbers.

And really to tell the truth, I remember having done this before and can't get it out of my head. I am the type of person that when vacuuming, and am unable to suck up a paper clip, will bend down and reposition the paper clip until the vacuum picks it up. Just because I know it should be able to do it.

Thanks guys!


__________________
You just pick up a chord, go twang, and you're got music
~ Sid Vicious

I use A03
DanG is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memo fields: Rich text?? mattcdse Forms 0 07-27-2006 01:48 AM
Inserting text into a memo field Kiwi-Wombat Modules & VBA 2 08-02-2004 03:22 PM
Variable as a text box name Uncle Gizmo Modules & VBA 6 09-28-2003 10:05 AM
Please Help with Normalization! JimboUK Tables 3 07-28-2003 05:04 AM
Grab a list of Text files and Append to a Master Text File. Randomblink Modules & VBA 2 10-12-2001 04:39 AM




All times are GMT -8. The time now is 08:34 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World