Daily posts of Excel tips…and other stuff
Archive for the ‘Printing’ Category.
In Page of Pages in a Cell, Jan Karel uses defined names and Excel 4 Macro commands to return the current page and total pages in a workbook. The problem is that it doesn’t work properly when the cell is repeated (e.g. File - Page Setup - Sheet - Rows to Repeat at Top). [...]
Making printed pages format correctly from Excel can sometimes be difficult.
The most common printing-related request I receive is: “How do I get Excel to print all of my columns on the same page?”
Take Northwind’s Customers table for example.
I’ve just extracted about 6 columns into my worksheet.
If I Autofit the columns, then do a Print Preview, [...]
Some time ago I was asked whether it was possible to add a Page .. of .. pages in a cell on a worksheet, without use of VBA.
Interesting challenge of course.
But with some defined names this proved possible.
I will show just one situation, where the pages are all below each other on the worksheet.
These names [...]
There was an interesting discussion at the Xtreme Visual Basic forums that I learned about from Andy (Thanks). It seems that that with Excel XP and service pack 3 (SP-3), controls placed on a worksheet will move when printed or previewed. I’ve heard of this problem, but never experienced it myself; probably because [...]
When your Excel table spans more than one printed page, you can repeat the rows or columns (that serve as headings) on the subsequent printed pages. On this table
I’ve added some manual page breaks to simulate a large table. To show the months across the top of every page and the regions across [...]
The ampersand is a special character in Excel’s headers and footers. For instance, if you enter the date or the time, Excel puts an ampersand before the entry.
To show a literal ampersand in the header or footer, use two ampersands together.
This results in a header that looks like this:
If there are certain cells on your worksheet that you don’t want to print, you can hide the rows or columns they’re in before you print. Sometimes, however, there is other information in those rows and columns that you DO want to print.
There is no facility to hide individual cells, but you can change [...]
On the Page tab of File>Page Setup, there is a Scaling option that allows you to print using a percentage or a number of pages (wide or tall). When you use the Fit To option, to specify a number of pages, Excel ignores your manual page breaks. I don’t know about you, but [...]
