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: 11:50 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: 16:20 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: 12:50 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: 11:50 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: 12:50 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 TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
| 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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |