Excel - page number in background of table that I can\'t edit Thread poster: Alison Schwitzgebel
|
HELP please!
I have a job right now in Excel. On some of the Excel sheets there is the page number (Seite 1, Seite 2, etc) in gray \'behind\' the table. I can\'t click into this page number to edit it - how do I get there?
Thanks!
Alison | | | Mary Worby United Kingdom Local time: 05:36 German to English + ... View - Header and Footer | Feb 7, 2003 |
Hi Alison,
This is just a guess. Is it in the header and footer section. I\'ve had all sorts of grief trying to edit those in the past and I know that, in Word, for example, the wallpaper is within the header.
Just a thought!
HTH
Mary | | | I've looked in the headers/footers | Feb 7, 2003 |
I\'ve looked in the headers/footers and can\'t find anything in there.
| | | tsidkenu Local time: 10:06 English to French
Hi Alison, I guess we\'ve all faced that problem at some time or the other. The page no. will be in the header or the footer. To get rid of it, do the following :
Go to the Top Menu Bar > View > Header and Footer. Choose Header and Footer from the options (Page, Margins, H&F). When it asks what you want, on the scroll down bar click \"none\".
That should pretty much solve your problem. You can use this same method to activate the page nos... See more Hi Alison, I guess we\'ve all faced that problem at some time or the other. The page no. will be in the header or the footer. To get rid of it, do the following :
Go to the Top Menu Bar > View > Header and Footer. Choose Header and Footer from the options (Page, Margins, H&F). When it asks what you want, on the scroll down bar click \"none\".
That should pretty much solve your problem. You can use this same method to activate the page nos. in another document if required.
▲ Collapse | |
|
|
Csaba Ban Hungary Local time: 06:36 Member (2002) English to Hungarian + ...
View -> Header/Footer -> Header/Footer tab - > Custom Header or Custom Footer button -> Left/Center/Right section
This should work 100% | | | Nope, can't find it in the header/footer | Feb 7, 2003 |
I can\'t find it anywhere in the header or footer. Sorry Casa - doesn\'t seem to work here....
Thanks!
ALison | | | Mary Worby United Kingdom Local time: 05:36 German to English + ...
Are you in \'Page break preview mode\'? (Option under \'Normal\' in \'View\' menu). This is the only way I can get \'Page 1\', etc. to display on my screen, effectively behind the text. But this is just as a guidance and is not actually part of the document. Do the page numbers come out on a printed version?
Fairly puzzled!
Mary
| | | Jerzy Czopik Germany Local time: 06:36 Member (2003) Polish to German + ... Change the view in your document | Feb 7, 2003 |
Alison has send me the file - the solution was as simple as that:
The document (or the particular page of it) was shown in \"page break preview\" - then Excel shows gray \"page nn\" under the text - but only on the screen. This \"page nn\" does not print. After changing to normal view you will see no \"Page nn\" ingrey underneath the text.
Kind regards Jerzy | |
|
|
| To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Excel - page number in background of table that I can\'t edit Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |