Published at Saturday, September 21st, 2019 - 04:48:49 AM. Kids Worksheet. By Xavierra Langlois.
With a few clicks though you can easily and quickly copy your page set up settings across multiple work sheets as well as impressing your colleagues! First, get your first page exactly as your want it with your headers, footers, orientation and margins perfectly placed to your requirements by using the Page Layout Tab. Activate the first sheet, i.e the sheet that contains your required settings. This becomes your reference or source sheet.Select all of your other work sheets in the work book. The have now become the targets sheets.Use the CTRL+ click to select the sheets your and your targets for the settings.In Excel 2007 onwards use Page Layout Tab - Page Set Up Group. Hit the dialog box launcher. Once opened hit OK to close the dialog box.
You will notice that the sheets now are grouped together, you can see this status on the top of the work book in the title bar, it will be displayed as [Group]. Your sheets now need to to be grouped. Right click on any of the grouped sheets and a short menu will appear. Select the group option to group your work sheets. That is all there is to it. The settings from the original or source sheet will now be copied over to your target work sheets. This really does take the hassle out of formatting individual sheets allowing you to quickly apply uniform page set up and formatting to all of your work book sheets.
Any content, trademark’s, or other material that might be found on the Rafahpundits website that is not Rafahpundits’s property remains the copyright of its respective owner/s. In no way does Rafahpundits claim ownership or responsibility for such items, and you should seek legal consent for any use of such materials from its owner.