Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Data Not Overlapping Next Cell

  1. #1
    Join Date
    4th August 2006
    Posts
    23

    Data Not Overlapping Next Cell

    This is probably a simple fix, but I cannot figure out why some of my data will overlap over the next cell if it is bigger than the cell width and then some will not, I just get ###### error. There is nothing in the next cell. I don't want to increase the cell size because that would mess up the rest of my page format. I've also tried to merge two cells together, but then it causes an error in my macro, even though the cell name is the same.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th February 2006
    Posts
    262

    Re: Data Not Overlapping Next Cell

    Try selecting the cells and setting the Alignment property to CenterAcrossSelection.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    4th August 2006
    Posts
    23

    Re: Data Not Overlapping Next Cell

    CenterAcrossSelection did not work. I found out that numbers do not overlap, but text does. In these particular cells, I put in ID numbers so they usually have some text in them and are not a problem. In the rare event I have just a number I will have to remember to use a ' in front. I guess I will just have to use this solution for now.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Prevent Overlapping Scatter Points In Chart
    By tuesday in forum EXCEL HELP
    Replies: 1
    Last Post: June 7th, 2008, 19:30
  2. Avoid Bar Graph Overlapping Axis
    By sweep in forum EXCEL HELP
    Replies: 4
    Last Post: February 1st, 2008, 22:51
  3. Replies: 3
    Last Post: August 30th, 2006, 05:02
  4. overlapping range query
    By aglenn in forum EXCEL HELP
    Replies: 3
    Last Post: September 13th, 2004, 23:21
  5. Formulas: Overlapping Ranges
    By Neal in forum EXCEL HELP
    Replies: 1
    Last Post: August 29th, 2003, 07:33

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno