software

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 quot;lockquot; 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: www.excelforum.com/member.php...oamp;userid=28847
View this thread: www.excelforum.com/showthread...hreadid=505709Hold 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

quot;nicolebellequot; gt;
wrote in message
...
gt;
gt; Hello--i have a multi-tabbed workbook and am continually batteling with
gt; Excel to have consistent formatting i.e. same size rows etc.. how do i
gt; do this? i have been doing paste special: formats, however it doesn't
gt; always work. also is there a way to quot;lockquot; a page in some fashion so
gt; that all worksheets have the same margins and spacing? Any info would
gt; be greatly appreciated. thanks!!
gt;
gt;
gt; --
gt; nicolebelle
gt; ------------------------------------------------------------------------
gt; nicolebelle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28847
gt; View this thread: www.excelforum.com/showthread...hreadid=505709
gt;

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: www.excelforum.com/member.php...oamp;userid=28847
View this thread: www.excelforum.com/showthread...hreadid=505709You 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 Backmannquot;nicolebellequot; wrote:

gt;
gt; Great! thanks that really helped, however now i am running into the
gt; problem that as i insert pages the page setup from my existing
gt; worksheets is not copied to the newly inserted page--is this fixable or
gt; do i just have to manually do it? Thanks again--
gt;
gt;
gt; --
gt; nicolebelle
gt; ------------------------------------------------------------------------
gt; nicolebelle's Profile: www.excelforum.com/member.php...oamp;userid=28847
gt; View this thread: www.excelforum.com/showthread...hreadid=505709
gt;
gt;