pagination

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pagination

Pagination

resolvedResolved · Medium Priority · Version 2007

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?

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

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

RE: Pagination

Thank you very much Amanda, I will certainly try that on this month's programme.

Simon


 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Server loaded in 0.08 secs.