Column & Row line widths
In Numbers 3.0 is there a means to have a dark or heavier line every (5) lines for both the columns across and rows down?
iMac, OS X Mavericks (10.9)
Apple Event: May 7th at 7 am PT
In Numbers 3.0 is there a means to have a dark or heavier line every (5) lines for both the columns across and rows down?
iMac, OS X Mavericks (10.9)
Anybody on this ??????
Hi dtryon,
No automatic way that I know of. Follow quinn's advice using Format Panel > Cell > Border > Outline.
Maybe a quick way (only need to do this once, then Save as Template for future use).
Start with a table that is bigger than you need.
Select a 5 by 5 block of cells, from A1 to E5
Format Panel > Cell > Border > Outline.
To get this:
With that 5 by 5 block of cells still selected,
Menu > Edit > Copy (command c).
Click in cell A6 and Paste (command v).
Now select the 10 by 5 block, Copy and Paste. Repeat for as many rows as you want.
Select the 5 columns and Paste to the right from cell F1.
Repeat for as many columns as you want.
Save as Template
To paste data into the template, Select data from a source table, Copy, click in cell A1 of the 5 by 5 table and Menu > Edit > Paste and Match Style
Delete unneeded rows and columns.
Regards,
Ian.
Why isn't the reply from Yellow Box that I received an email notification on visible here in this discussion. There isn't a way to reply to him.
😕
All of a sudden the reply became visible.
After having gone thru these steps would I be able to enter data into the template directly or would in have to be a cut and past situation.
Boy it seems like Apple could come up with something easy on this desire.
Hi dtryon
Why isn't the reply from Yellow Box that I received an email notification on visible here in this discussion. There isn't a way to reply to him.
That is a recent glitch in the forum software: email notifications arriving before a reply appears in this forum.
That is, "Phantom Replies" not showing until you reply.
I can see your reply now.
My reply about Copy then Paste and Match Style was to allow you to paste existing data into a pre-formatted table (template). Data will paste and will not overwrite the pre-set cell borders of the 5 by 5 cell template.
It will help other Numbers users if you reply with why you need:
dark or heavier line every (5) lines for both the columns across and rows down
it seems like Apple could come up with something easy on this desire.
Don't blame Apple.This is a user-to-user forum. Apple is not here and Apple doesn't know why you need blocks of 5 by 5 cells with heavier cell borders.
More information will lead to a solution 🙂.
Regards,
Ian
I have been having the same problem with the forum. Even my own replies don't show up sometimes. Sometimes I see the previous replies after I make a reply. Sometimes if I log out and refresh the page it will show all the replies but when I log back in again they are gone again. At first I thought I was going crazy. I'd reply to a post with no replies and then all (or more of) the previous replies would show up. I kept thinking "how did I miss those"?
Badunit wrote:
At first I thought I was going crazy. I'd reply to a post with no replies and then all (or more of) the previous replies would show up. I kept thinking "how did I miss those"?
Yes, embarrassing ... especially for Apple. Don't like to complain .... but they just can't seem to get their act together on these forums.😟
SG
After having gone thru these steps would I be able to enter data into the template directly or would in have to be a cut and past situation.
Boy it seems like Apple could come up with something easy on this desire.
Replying to all.....It is impossible to carry on any kind of a conversation with this forum acting the way it is now.
👿👿👿
After having gone thru the steps you outlined earlier would I be able to enter data into the template directly or would it have to be a cut and paste situation?
The reason I want this situation is for no other reason than to break up a schedule that has multiple weeks across the top by the month and a list of 40 people or so going down in the "A" column. I want dark lines every five names down and every month across the top. The row lines and column lines in between would be either a grayed line or a lighter weight line.
Does this make sense? Would you have another way of creating that look?
By the way I do realize this is a user/volunteer forum but I am certain that Apple must follow it. By saying that Apple should have a better way of creating different looks just kind of makes sense to me.
Thanks for your help
If you really want to make a statement to Apple use the menu item "Numbers > Provide Numbers Feedback"
I will. Thanks for point me to the proper place to do so.
Column & Row line widths