Cell borders confusion
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I would like to put boundaries or lines around cells in my table. Apparently, I can choose lines between the cells, or around the table, but not both. This is incredible! When I do one, the other is undone. There is no way to get the obvious combination of lines between cells, and a nice boundary around a whole table.
I also keep getting double-lines, when I want simple, single lines. The box for selecting this does not seem to be working.
Help! (Because the Help does not explain how to do this very simple task, and it is too late to drive all the way back to the Apple Store to ask someone.)
14 replies
Sign in or join Beachball Help to reply.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Thank you. The picture makes it easier to explain what I am trying to do.
You have selected cells D1 through E10, and drawn a border around that. Now how do we drawn borders around all the cells in that table? One would think that it would be accomplished by now selecting the left choice in the rightmost double-button in the first row under Cell Borders in the Table palette; but when you do that, your first border disappears.
It is strange. Very strange, indeed. I hate to say this, but it is very simple to do in Excel, because they have an appropriate graphic (a quartered square) conveying excatly the notion of what you want to do. You also can pile on as many variations as you want. In Numbers, you can't even get started.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hi
I found the same issue. I found a way around it.
Select the range of cells, just as you would in Excel. Then use the "Line style", "Line width" and "Line colour" selectors from the menu bar - not the Inspector. I choose a line style below "Thin", a line width of 1px and the colour black.
The cells then have a border just was you would expect. I hope this helps.
(I would upload a picture, but I am not sure how)
Mark
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hopefully this is a link to an image on Flickr
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Thanks, Mark. Now we have something. One goes to the little symbols on the program's menu bar (the fourth collection of buttons reading from the left). (The buttons are all unlabeled, and not even identified in the instruction book which comes with the program!) Select your table, then use the first button to select the outside outline, the next button to select style, the third to select thinkness, and the fourth to select color. Then (important) one must hit Enter in order to apply the selection. (If you don't, nothing will be accomplished.) Then do the same thing for the boundaries of the inner cells of the table.
Maybe this is simple, but unless it is explained somewhere, one must discover on one's own, or by consultation. It is not nice when you are home on Labor Day weekend trying to get something ready for presentation on Tuesday morning.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
This is a bug in the program. Both using the format bar at the top, and the inspector window should work consistently in applying border formatting to cells and tables.
Please report this bug to Apple. On your Number menu, select Provide Number Feedback.
Thank you!
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I agree that its ridiculous that drawing borders is so complicated in Numbers. Its a function I use all the time in Excel and I've spent the last half hour trying to get what should be some simple lines drawn in an invoice I'm creating. In addition to the difficulty placing the borders (and removing the grid lines from printing which for some odd reason is the default), choosing different shades of a color is bizarre. If you set the color for one section of border lines and want to choose the same color for adjoining lines, you have to guess that you're at the same spot on the sliding scale. The color box options in Excel alleviate this problem as well. I'd hate to spend the money for the Apple version of Excel, but it is significantly less complicated than Numbers.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
If your having a problem remembering colors, do what I do. At the bottom of the color picker, is an area that you can drag the selected color from the top of the dialog and drop it in one of those little boxes. If you grab the bottom of the dialog, you can expose many many more empty boxes for storing your favorites.
No more guessing where you were on the slider because you have a color 'swatch' down there with the exact color. And they don't have to go in order, you can even group them together on that grid. One area for school colors and pamphlets, the other for home stuff. whatever. I love that dialog.
Hope that helps you a little bit. (Oh if you don't see the empty boxes down there, just try dragging the bottom edge of he color selection box, it will expand to display them),
Jason - 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
oh, and you're all right, borders takes alot of getting used to. The key is it HAS to be done in the exact right order, or it will not work like you expected. Problem is, nobody is there to tell you the right order. (i'm still figuring it out myself).
Jason
p.s. everyone that has posted here should submit feedback using Numbers menu, let them know we want a better way of doing borders. the more that say something, the more likely they are to change it.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I use the Submit Feedback button all the time. But I always check here to see if I'm the only one with the problem. Hopefully some of the issues posted here will get some attention soon. Thanks for the advice on the colors. I was able to get my borders done, finally, but simply chose a thinner black line and had to select 1 row at a time and then the columns to get the result I wanted.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
The trick is NOT to highlight any of the effects (buttons) if you want lines around all cells. Just select the cells and just add the line type/colour you want. Use the buttons if you want specific line positions.
Thats pretty staightforward. You can use either the inspector or the menubar
Message was edited by: John H
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
The easiest way to select a table is by clicking it in the side bar.
Once the table is selected the buttons to change the pt size and colour of the borders work fine,
Inside grid, Outside border, All the vertical lines etc.Select a group of cells to change all the borders of that selection at once or use the buttons as if it was a normal table.
If you only want to change one line at a time, make sure that you have clicked allow border selection under Table or the border format menu and click on the line to select. Double lines show which lines have been selected.
I have not found any differences between the format bar and the Inspector.
- 0
Apple Support Community member ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Can't link picture.
Message was edited by: Ashka

