Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consistent Formatting in Each Worksheet
Hello--i have a multi-tabbed workbook and am continually batteling with Excel to have consistent formatting i.e. same size rows etc.. how do i do this? i have been doing paste special: formats, however it doesn't always work. also is there a way to "lock" a page in some fashion so that all worksheets have the same margins and spacing? Any info would be greatly appreciated. thanks!! -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=505709 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consistent Formatting in Each Worksheet
Hold down the SHIFT key, click on the tabs for the sheets to include (this
is 'grouping') Make the format changes needed Right click a worksheet tab and select Ungroup best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "nicolebelle" wrote in message ... Hello--i have a multi-tabbed workbook and am continually batteling with Excel to have consistent formatting i.e. same size rows etc.. how do i do this? i have been doing paste special: formats, however it doesn't always work. also is there a way to "lock" a page in some fashion so that all worksheets have the same margins and spacing? Any info would be greatly appreciated. thanks!! -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=505709 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consistent Formatting in Each Worksheet
Great! thanks that really helped, however now i am running into the problem that as i insert pages the page setup from my existing worksheets is not copied to the newly inserted page--is this fixable or do i just have to manually do it? Thanks again--:) -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=505709 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consistent Formatting in Each Worksheet
You can right-click on a tab of an existing worksheet, select Move or Copy,
click the Create Copy check box and select the location of where you want the copy inserted from the list of tab names above the check box. -- Kevin Backmann "nicolebelle" wrote: Great! thanks that really helped, however now i am running into the problem that as i insert pages the page setup from my existing worksheets is not copied to the newly inserted page--is this fixable or do i just have to manually do it? Thanks again--:) -- nicolebelle ------------------------------------------------------------------------ nicolebelle's Profile: http://www.excelforum.com/member.php...o&userid=28847 View this thread: http://www.excelforum.com/showthread...hreadid=505709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |