Printing Excel
2007 Excel - Have spreadsheet that I ahve hidden numerous columns. I would
like to print columns on screeen now. Columns are A,B,AS thru BA. In pat I ahve been able to do tis with this spreadsheet by using print titles A2-BA50. However now this is causing a title page and each cell to print on a page (48 pages). Any ideas on how to fix |
Printing Excel
On 4/15/2010 8:51 AM, Stu wrote:
2007 Excel - Have spreadsheet that I ahve hidden numerous columns. I would like to print columns on screeen now. Columns are A,B,AS thru BA. In pat I ahve been able to do tis with this spreadsheet by using print titles A2-BA50. However now this is causing a title page and each cell to print on a page (48 pages). Any ideas on how to fix Unhide the columns, print, then hide the columns again. If you do this often, record a macro for the task and save it so that you can use it repeatedly. See "macro recording" in Excel help. Bill |
Printing Excel
You have print titles set to 49 rows.
Usually setting for just one or two rows to repeat at top. Gord Dibben MS Excel MVP On Thu, 15 Apr 2010 08:51:01 -0700, Stu wrote: 2007 Excel - Have spreadsheet that I ahve hidden numerous columns. I would like to print columns on screeen now. Columns are A,B,AS thru BA. In pat I ahve been able to do tis with this spreadsheet by using print titles A2-BA50. However now this is causing a title page and each cell to print on a page (48 pages). Any ideas on how to fix |
All times are GMT +1. The time now is 09:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com