Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers and margins
I am taking over an existing multi page workbook. How do i add the same
custom header and change column width to some of the columns throughout the entire work book. There are 11 pages. I also need to change the page setup. do i need to this one page at a time as well. This is time sensitive and I know there has got to be an easier way. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers and margins
you should be able to select multiple tabs by pressing the shift key. Select
the farthest left tab, and then shift+click the farthest right tab. At this point any change will affect the entire workbook. Be careful though, if you change the content of a cell it will change that cell for every workbook. When you are finishe, select any tab to deselect the tabs. "blueeydnluvinit" wrote: I am taking over an existing multi page workbook. How do i add the same custom header and change column width to some of the columns throughout the entire work book. There are 11 pages. I also need to change the page setup. do i need to this one page at a time as well. This is time sensitive and I know there has got to be an easier way. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set the side margins for headers and footers in excel | Excel Discussion (Misc queries) | |||
If I change page margins headers don't line up??? | Excel Discussion (Misc queries) | |||
My headers in Excel don't adjust with margin changes. | Excel Discussion (Misc queries) | |||
xl Headers and Footers always use 3/4 inch side margins??? | New Users to Excel | |||
Left/Right Margins in Header/Footer | Excel Discussion (Misc queries) |