Currently Being ModeratedSep 11, 2013 5:39 PM (in response to hotwheels 22)
Work through the buttons from left to right:
Choose which border(s) you want to set.
Choose the type of stroke you want (thin, solid, dashed, dotted)
Choose the thickness of the line (not avaiable for 'thin')
Choose the colour of the line.
Thin borders do not show colour well, even though the chosen colour is applied to them.
Formattng the Outside border and formatting the inside borders of a selected group of cells are separate tasks. Formatting of the contents of a cell and the fill coour are also separate from formatting the border(s). see example below.
Note cell B4. This has medium dark green borders, but they are 'thin', and do not show well even in this screen shot of a 200% scale view of the table.
Currently Being ModeratedSep 12, 2013 8:57 AM (in response to Barry)
hi barry. many thanks for this. i am working basically left to right on the bar at the top now. a follow up please.
i am just using black borders and applying thickness to the /outline/ of a selection of cells once in a while. i just do this to outline and sort of highlight a set of cells (for instance 2 rows and 4 columns).
i am seeing that i am /always/ having to go in and set the color from grey (or something like grey) to black even though i never use any colored outlines. is there a way to simply set the default to black? it is a major pain to always have like six clicks to just get a set of boxes outlined.
is there some kind of way to do a preset that will let me - say - outline the selection with 1mm thick black outline and leave it at that?
/also/ i am ALWAYS going in and selecting the 8 cells (2 rows and 4 columns) and then having to select the "none" outline so that i can get rid of the /inside/ lines on the cells. then i have to go back in and do a selet outline, select thickness and select color to get the outline with no lines inbetween.
A. is there some command that will let me say "outline these cells with this thickness and take out any lines inbetween" or is this always a two step process?
B. when i run a commmand to do "thin" lines in-between all the cells (say when i have to replace some lines that i had to take out for some reason) is it supposed to also do the /outlines/ of this selection? i mean, can i do a "outline all the cells and outline the cells selected as well" operation or is this also always a two step process?
Currently Being ModeratedSep 12, 2013 9:08 PM (in response to hotwheels 22)
I don't know that this is any shorter, but if you are frequently formatting a block of eight cells i the same anner, you might try setting up a template in which a block of eight is formatted the way tyou want them.
When using the same format (1 pt blackoutlight, no internal cdll borders) in a new document:
Open the template.
Select the eight cell block.
Press option-command-C to copy the format of the cells.
Switch to the existing document.
Select the eight cell block to be formatted.
Press option-command-V to paste the format.
(Note that ALL borders in the selection will be formatted like the outline in the original—
the pasted format has been applied to eah cell, not to the block.)
With th cells still selected, choose Inside borders from the first button.
Set the Line Type to 'none' with the second button.
As the format paste has the fault mentioned, you could format only a single cell in the template with a full border. Copy the format from that cell, then select the block of cells to get the outline in the existing document, Paste the format (with the same results as above), then continue with the last two steps above to remove the internal borders.
A & B: The selection button does exactly what it says/shows it will do: Select the borders to be formatted. The formatting is applied to the selected borders. No change is made to the borders not selected.
You might take a look at Automator. You may be able to use Automato to assemble the set of actions needed to set the outside borders of a selection to a specified thickness and colour, then set the inside borders of the selection to another thickness and colour (or to 'none'). It's not something I've explored, though.
Or it might be possible to accomplish this using an AppleScript. Again, not something I've explored.
Currently Being ModeratedSep 15, 2013 5:28 PM (in response to Barry)
ooof. thanks barry.
so - automator is going to be way too involved for me and i used the 8 cell thing just as an example. i do this with 2 cells or the whole document a lot for some reason.
so. i mean say something as simple as the default color for an outline. is there a rhyme or reason as to why this defaults to some kind of gray on my mac pro (haven't checked the macbook)?
i have worked in here for awhile now off and on and i am actually sort of wondering if i should go back to office if i am going to do a lot more spreadsheet stuff...
Currently Being ModeratedSep 15, 2013 9:55 PM (in response to hotwheels 22)
The default colour for the grid isn't changeable. The rhyme or reason behind the colour is that it's a design choice, just as the default fill colour of header rown and columns, and the fact the column and row reference tabs are visible only (and always) when the a cell in the table is selected are design choices. Border colours default to the grid colour IF no border colour has been set. IF a border colour has ben set, it overrides the grid colour, and becomes the default border colour for the cells on which it has been set.
You can set a different 'starting' colour for individual, groups of or all cells in a table, set any other parameters you want to always apply to new documents, then save that document as a template. Any document opened from that template will have those starting parameters.
As noted in my earlier post, the format of a cell can be copied independent of its contents, using Copy Style or the keystroke equivalent option-command-C, then pasted into one or more contiguous cells using Paste Style or option-command-V.
As the format is applied to the individual cells within the group, all cell borders will be formatted if the cell's 'outside' borders have been formatted. To convert that to an outline, choose internal borders and 'none' from the border format controls in the format bar.
Note that any size rectangular array of cells can be given an outline border with no inner borders using the same series of steps—you're not restricted to, for example, a four by two array.
Regarding going back to MS Office and Excel for your spreadsheet needs: As I said in your separate question on this topic, your best path is to use the tool that's best for the job. If there are features in Excel that you use and need which are not available in Numbers, that may be enough to tip the balance for your case.