I have imported a template from Excel and the header field is not visible but is still printed. I need to get rid of it.
No matter how I go about it, I don't seem to find a way to get to the settings for the document where I can uncheck
the header and footer fields. Please advice....
Ronny Nilsson
MBP 15" mid 2009, 2,66 MHz, 4 GB RAM, 256 GB SSD.
OS X 10.11.3
Numbers 3.6.1
HI Ronny,
There are two types of "Headers" and "Footers" in Numbers.
"Header rows", "Header columns" and "Footer rows" are rows at the top of a table, columns at the left of a table, and rows at the bottom of a table that have been defined as Header rows or columns or as Footer rows. These are controlled in the Table section of the Format inspector, shown in Wayne's post (and in Craig Coffin's later post). The three steppers control the number of rows or columns (up to 5 of each) defined as Header rows, Header columns and Footer rows.
These headers are rows and columns with special properties—Header rows and columns can be frozen in place so that the rest of the table slides behind them when you scroll the table; formulas in header or footer rows or header columns can reference their own column without that reference including the cell containing the formula (allowing calculation of SUM(B) in the cell at the bottom of column B, for example).
If you Hide these rows (using the "Hide selected row(s)" item in the Table menu, they are hidden from view on the screen and do not print when you print the page.
"Page headers" and "Page footers" (also known as 'running' headers and footers) are visible only when printing or in print view. These headers and footers cannot be removed, but their heights can be set to zero using the Print Setup inspector, visible only in Print View:
Default heights for the Page headers and footers is as shown (where inches are the unit chosen in System Preferences). Clicking the v can reduce the two settings to 0.
In the same section, you can also reduce the page margins to less than the default settings shown. Be aware that setting all margins to 0 may reduce print quality, or cause the program to try to print closer to the edge than the printer's capability allows.
Regards,
Barry
HI Ronny,
There are two types of "Headers" and "Footers" in Numbers.
"Header rows", "Header columns" and "Footer rows" are rows at the top of a table, columns at the left of a table, and rows at the bottom of a table that have been defined as Header rows or columns or as Footer rows. These are controlled in the Table section of the Format inspector, shown in Wayne's post (and in Craig Coffin's later post). The three steppers control the number of rows or columns (up to 5 of each) defined as Header rows, Header columns and Footer rows.
These headers are rows and columns with special properties—Header rows and columns can be frozen in place so that the rest of the table slides behind them when you scroll the table; formulas in header or footer rows or header columns can reference their own column without that reference including the cell containing the formula (allowing calculation of SUM(B) in the cell at the bottom of column B, for example).
If you Hide these rows (using the "Hide selected row(s)" item in the Table menu, they are hidden from view on the screen and do not print when you print the page.
"Page headers" and "Page footers" (also known as 'running' headers and footers) are visible only when printing or in print view. These headers and footers cannot be removed, but their heights can be set to zero using the Print Setup inspector, visible only in Print View:
Default heights for the Page headers and footers is as shown (where inches are the unit chosen in System Preferences). Clicking the v can reduce the two settings to 0.
In the same section, you can also reduce the page margins to less than the default settings shown. Be aware that setting all margins to 0 may reduce print quality, or cause the program to try to print closer to the edge than the printer's capability allows.
Regards,
Barry
Headers and footers are set in the Table Formatter:
select the table, then open the Table Formatter and change the selections in the pop-up menus in the "Headers & Footers" section to 0
Ronny Nilsson wrote:
I have imported a template from Excel and the header field is not visible but is still printed. I need to get rid of it.
Do you mean the print header?
If so go File > Print and click the print "preview" image on the left. You will see three editable header fields and footer fields, similar to Excel. Click in them to edit. To remove just delete what is in there.
SG
My Header only shows up when i go to print. As thought it is in the back round. The Title "2013 Reviving Conference"
I have turned off the headers and cant see it on my original document when i am editing it.
When I go to print it shows up in print view - like it is on the back of a "template" or something. I cant figure out how to get rid of it?
Select Numbers' Help and find the tutorial on Headers. It's in there somewhere. I've only been an Apple user for five years after 25 years on PCs. I've had Numbers in my Mac, Pad and Phone but always reverted back to Excel because I've used Excel since it came out. I was an early user of Lotus 1-2-3 then Lotus Symphony in the 1980s. Numbers is kinda tricky yet simple to learn. I'm not giving up. Forward MARCH!!
How to remove headers in Numbers?
