Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2013, 02:11 PM
msheyworth msheyworth is offline Printig cells Windows XP Printig cells Office 2007
Novice
Printig cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default Printig cells


I have a speadsheet and when printing i want to show columns A & B 1 to 32 but also A to G 1 to 5 on every sheet with C to AA 6 to 32 i know how to repeat A & B 1 to 32 but cant repeat the top rows again hope you understand what i am trying to do but hard to explain its a form that i am trying to make.


Reply With Quote
  #2  
Old 03-20-2013, 07:22 AM
OTPM OTPM is offline Printig cells Windows 7 32bit Printig cells Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You could do this using vba but you cannot do it with standard functionality. Why do you need to do this?
Tony
Reply With Quote
  #3  
Old 03-20-2013, 11:39 AM
msheyworth msheyworth is offline Printig cells Windows XP Printig cells Office 2007
Novice
Printig cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default

I need it for printing a register of equipment
Reply With Quote
  #4  
Old 03-23-2013, 10:07 AM
msheyworth msheyworth is offline Printig cells Windows XP Printig cells Office 2007
Novice
Printig cells
 
Join Date: Mar 2012
Posts: 21
msheyworth is on a distinguished road
Default

solved just copied the c to g ,1 to 5 along top of sheet as these dont change so they appear on each print with a to b 1 to 32
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only mag Excel 0 10-28-2012 08:04 PM
Printig cells Un even cells lostsoul62 Excel 5 10-17-2012 08:33 AM
Printig cells How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Printig cells Can Cells have more than one web link DrDOS Excel 2 03-27-2012 02:53 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft