Currently Being ModeratedOct 23, 2012 6:11 PM (in response to Wayne Contello)
I don't think you understood my question. I have spreadsheets that are formatted with colored Headers, alternate rows, etc. I just want to print a basic spreadsheet grid, with my data, black & white, no colored headers, alternating rows, etc. But I don't want to remove the Styles (colors, formatting, etc.) from my spreadsheets every time I want to print them.
I'm hoping someone can tell me how to accomplish this.
Thanks in advance to anyone that can help.
Currently Being ModeratedOct 24, 2012 5:02 PM (in response to Wayne Contello)
I read the entire manual, and serched the Internet, but found nothing about referencing other tables. I know what you are talking about because I used to do it using Excel; I just can't find out how to do it in Numbers. Any suggestions?
Currently Being ModeratedOct 24, 2012 6:16 PM (in response to aunkb)
to make a table that referes to another,
1) click on a cell in the "new" table.
2) type "=", then click the cell in the original table you want it to refer to
3) hit return to exist cell edit mode
If you simply want to refer to every cell in a table, then select the top-left cell in "new" or destination table, type "=", then click in the corresponding cell in the original table.
Now select the top-left cell, then grab (click and hold) the little circle then drag to the right to fill the references
Now select the cells you just filled as a group and grab the circle at the bottom right of the selection, then drag down to fill as needed
Currently Being ModeratedOct 24, 2012 6:54 PM (in response to aunkb)
I suggest that you Copy the Table with all the fancy formatting and then eliminate the formatting on the copy for printing purposes. For further use of the table you made for printing you may Copy, then Paste and Match Style into the unformatted table.
Currently Being ModeratedOct 24, 2012 9:46 PM (in response to Wayne Contello)
Thank you for the help. It would be a lot nicer if Numbers had the ability to print spreadsheets without Styles rather than having to rely on your suggested method, but your method works, so I'll use it until Numbers 2013 comes out with all the capabilities everyone in the world wants built into it!
I created a document with 2 sheets, put the formatted (Styles) table on the first sheet to use for data entry, and the unformatted table (to print) on the second sheet, referencing the first sheet. That way, I never really have to look at the "print" table unless I need to print it.
Currently Being ModeratedOct 24, 2012 10:01 PM (in response to Jerrold Green1)
That works also, but for some reason, a few random formatted cells are included in the "Paste with matching style" on the "print" table. I'll put a little more effort into this method tomorrow when I can see and think straight!