Skip navigation

moving cells and cell outlines together?

199 Views 4 Replies Latest reply: Nov 1, 2013 12:56 PM by hotwheels 22 RSS
hotwheels 22 Level 1 Level 1 (0 points)
Currently Being Moderated
Oct 31, 2013 11:54 AM

i have a very long spreadsheet and would like to get rid of a DASHED BOLD outline around the cells.

 

is there some method for getting rid of the dashed bold outline as it runs through 800 rows and i don't want to have to redo all the sections to get rid of it.

 

i have tried moving the cell - one single DASHED BOLD line still runs vertically through my spreadsheet.

 

i also tried deleting the remaining DASHED BOLD line but this just deletes the whole line so it looks like two cells are together.

 

i think i am out of luck with this and have to redo all the formatting in all the sections below is that right?

MacBook Pro, OS X Mavericks (10.9)
  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Oct 31, 2013 12:22 PM (in response to hotwheels 22)

    HW.

     

    Select a column, Click the Format tool, Click Cell, Click Border, Click the line type, Select Solid, Set your weight, Click the orientation of the line relative to the column that is selected.

     

    Jerry

    Screen Shot 2013-10-31 at 3.19.46 pm.png

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 1, 2013 12:23 PM (in response to hotwheels 22)

    Formatting will become easier with practice. I find the sequence of the little dance we do to apply borders is slightly different in Version 3, at least it seems so.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.