Forum Discussion
Gli7cHyexe
Oct 05, 2024Copper Contributor
Excel page-view keeps fitting tables on "new" page on the first one.
Hi all,
I'm trying to make an invoice in excel. I've been doing this for a while with single pages, but now I am running out of space, so I thought I'd hop over to the new page. But every cell I fill in is fitted into the other sheet, with the cell sizes changed. How do I lock the first page or something to make new information stay on new pages?
Activate the Page Layout tab of the ribbon.
In the 'Scale to Fit' group, make sure that both Width and Height are set to Automatic.