Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I'm a longtime Excel user switching to Numbers, and I must be missing something. I'm mostly functional, but I seem to be unable to draw borders on my Numbers spreadsheets! I select a cell, click on the format button, and then on the right side of the screen I specify the border I want on the cell. Nothing happens. Little help?
--Paul
Paul,
It's a little tricky but not too hard.
1) select the cell(s) you want to format the border on
2) select the border style
3) select the color
4) select the weight
5) apply the selections to the desired borders
Paul,
It's a little tricky but not too hard.
1) select the cell(s) you want to format the border on
2) select the border style
3) select the color
4) select the weight
5) apply the selections to the desired borders
Thanks, Wayne, I really appreciate your reply, and this definitely gets me closer. I can put some borders on.
But not others. I'm able to put top, left and right borders on, but for some reason not the bottom border. Here's what I tried: 1) select the cell; 2) select border style of solid line; 3) select color of black; 4) select 3 pt; 5) click on desired border (last one). Nothing happens. I also tried clicking on the full box outline button (2nd one). It gives me the top, left and right borders but not the bottom!
Also, some cells seem to be completely immune to some borders (even following your directions), but not others. I can't figure out why.
I'm clearly closer, but I guess I'm still missing something? Is there some trick about adding bottom borders? (Have I jinxed things by starting with an Excel sheet that I imported into Numbers?)
--Paul
Hi Paul,
Maybe there is an Excel jinx. Try removing all borders then reapply them. Have a try with a new blank document from Template Chooser in Numbers.
Regards,
Ian.
Try copying the data from your table to a new table in a new document to see if there is any excel garbage that is interfering. Also try making the weight much larger than you need and see if the border will apply, then reduce the border weight
Can you send me the number file? I can look at it . my email is in the "Biography" of my profile.
Hi Paul,
Sometimes when there are hidden rows things go a little wonky. Could this be the case?
Quinn
I tried both of your suggestions and unfortunately had the same problem. But when I created a new Numbers spreadsheet from scratch, the borders work fine. I suspect Excel has left gremlins in this converted sheet. I switch over to Numbers completely, and stop using Excel, the problem may go away.
Do you still want to see the number file?
Good suggestion, but unfortunately there are no hidden rows.
Paul,
You may email me the document to look at it you want. My email is in the "Biography" of my profile.
Drawing Borders in Numbers
