Printer Friendly
The Free Library
19,607,059 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

Copy print settings in excel worksheets.


Q. Is there a fast way to copy the print settings from one Excel worksheet to another?

A. it's as easy as holding down the Shift or the Ctrl key. Click on the tab of the worksheet you want to copy. Then hold down the Shift or Ctrl key and click on the tab of the worksheet where you want the settings and click on File, Page Setup and OK.

Bonus: It will do more than copy all the basic print settings; it also will copy header (1) In a disk or tape file, a set of data that resides permanently at the beginning. It may be used for identification only (type of file, date of last update, etc.), or it may describe the structural layout of the contents, as is common with many document and database formats.  and footer In a document or report, common text that appears at the bottom of every page. It usually contains the page number.  settings.

STANLEY ZAROWIN is a freelance writer in Zionsville, Indiana Zionsville is a town located in the extreme southeast area of Boone County, Indiana. The population was 8,775 at the 2000 census. Nearby communities include Lebanon, Carmel, Whitestown, Westfield, and the suburbs of Indianapolis. . Mr. Zarowin retired from the JofA in 2003. His e-mail address See Internet address.

e-mail address - electronic mail address
 is zarowin@mindspring.com.
COPYRIGHT 2004 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Apr 1, 2004
Words:114
Previous Article:Tell word where you want it to save files.
Next Article:Enhance your Internet speed.



Related Articles
Spreadsheets: faster, smarter.
The power of spreadsheets.
Show-and-tell in real time: link a spreadsheet to a PowerPoint slide for up-to-the-minute visuals.
Push-button spreadsheets: perform repetitive tasks with one mouse click. (Technology Workshop).
Collaborate on spreadsheets: how to share Excel files with others on your network.
Move (or copy) a batch of Excel worksheets.
Enter data simultaneously on multiple sheets.
Shortcuts.
Prepare a workpaper stamp.
Navigate speedily in excel data: click on a button to get to target information.

Terms of use | Copyright © 2012 Farlex, Inc. | Feedback | For webmasters | Submit articles