 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / July 2007Split view printing
I have made a data spread sheet with Column A having names inserted being the main Column , then insert a split to allow the left remaining Columns to scroll with weekly info. How can i print so that Column A (first column of split) will print and only the Column or selected Columns will print i.e. the week i wish to highlight, not the whole sheet. Many Thanks brelade Select the data columns that you want to print (do not include column A) and set this as the print area. Go into page setup and on the sheet tab set the columns to repeat on the left which will be column A. Regards, OssieMac > I have made a data spread sheet with Column A having names inserted being the > main Column , then insert a split to allow the left remaining Columns to [quoted text clipped - 6 lines] > Many Thanks > brelade Brilliant. Many thanks for your help  Signaturebrelade > Select the data columns that you want to print (do not include column A) and > set this as the print area. Go into page setup and on the sheet tab set the [quoted text clipped - 14 lines] > > Many Thanks > > brelade
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.