Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pagination
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pagination
Resolved · Medium Priority · Version 2007
Reply Fri 28 Aug 2009, 16:14Delegate Simon said...
Simon has attended:
Excel Introduction course
Excel Intermediate course
Pagination
I have an excel workbook of 55 pages. Each mionth the pages remain the same size with no extra rows added. However, as soon as new data is inserted I have to repaginate every page (perhaps only 3 or 4 lines but..... Even saving these changes does not help. Any ideas?
For upcoming training course dates see: Pricing & availability
RE: Pagination
Hi Simon
Thank you for your question and welcome to the forum.
I will need to do a bit of research into this to see if I can find out why this might be happening.
One question I did have though...you say that you aren't inserting any extra rows, but you refer to the data being 'inserted'....is the new data typed into the spreadsheet, or put in some other way?
thanks
Amanda
Reply Tue 1 Sep 2009, 14:09Delegate Simon said...
RE: Pagination
Dear Amana,
The pages are in effect invoices. The rows each mnoth contain the same data, eg Fees, Commission, VAT, Total etc but each month I have to put in the new figures.
The sprwedsheet then calculates the various totals.
Simon
RE: Pagination
Hi Simon
The only suggestion I can make after having a look around on the internet is to make a macro (record yourself) next time you are adjusting the page breaks.
A macro is used to speed up a process that you would normally do manually (in this case, manually adjusting the page break positions each time).
Before you adjust the page breaks next time, go to Tools - Macro - Record New Macro first.
Then give the macro a name - the name can't contain spaces - so for example it could be called page_breaks but not page breaks. Then click OK.
Go through and adjust the page breaks as you would normally.
As soon as you have finished adjusting the page breaks, go to Tools - Macros - Stop Recording.
Next time you open the file, run the macro by going to Tools - Macro - Macros, selecting your macro from the list and clicking Run.
This should 'play' the process of you adjusting the page breaks that you recorded, thus adjusting the page breaks to the same position for you automatically.
I know this sounds a bit complicated, but it's the only way I can think of to resolve this problem.
Kind regards
Amanda
Reply Wed 2 Sep 2009, 12:40Delegate Simon said...
RE: Pagination
Thank you very much Amanda, I will certainly try that on this month's programme.
Simon
|