SysChat

SysChat (http://www.syschat.com/forum.php)
-   Microsoft Office (http://www.syschat.com/tips-n-tricks/microsoft-office/)
-   -   Applying the Same Format to Collective Sheets in MS Excel (http://www.syschat.com/applying-same-format-collective-sheets-ms-2856.html)

eve array 11-25-2007 02:06 AM

Applying the Same Format to Collective Sheets in MS Excel
 
There are easy ways to select several sheets to create a collective sheet selection of Excel Workbook that will save time and constrict the instances for mistakes through carrying the task once but will employ to a group of collective sheets. Here are the tips on how to execute the column widths or utilize special formatting to a range of cells in a group of sheets.

To select adjacent sheets, follow the steps below:
1. Select by clicking a sheet tab.
2. Press Shift and keep it pressed while clicking a second sheet tab.
The Excel will generate both clicked sheets and all the sheets in between.

To select non-adjacent sheets follow the steps below:
 Click CTRL and keep it depressed while clicking sheet tabs.
The Excel will generate all of the clicked sheets.

To select all sheets, follow the steps below:
 Right-click a sheet tab and choose “Select All Sheets”.

To select the active sheet and the previous sheet:
 Click Shift + Ctrl + Page Up.

To select the active sheet and the following sheet:
 Click Shift + Ctrl + Page Down.
Don’t forget that you're working with a multi-sheet selection so be reminded that when you do something to the current sheet, Excel repeats for every sheet in the selection.

If you make changes to a selection of sheets when you meant to change only the active sheet, you may have a lot of damage to repair.
You can avoid confusion by canceling a multi-sheet selection task as soon as you finish your multi-sheet tasks.
To do so:
 Click an unselected sheet or right-click a selected sheet tab and choose Ungroup Sheets.

Mikeg 05-29-2008 05:45 PM

Quote:

Originally Posted by eve array (Post 8845)
There are easy ways to select several sheets to create a collective sheet selection of Excel Workbook that will save time and constrict the instances for mistakes through carrying the task once but will employ to a group of collective sheets. Here are the tips on how to execute the column widths or utilize special formatting to a range of cells in a group of sheets.

To select adjacent sheets, follow the steps below:
1. Select by clicking a sheet tab.
2. Press Shift and keep it pressed while clicking a second sheet tab.
The Excel will generate both clicked sheets and all the sheets in between.

To select non-adjacent sheets follow the steps below:
 Click CTRL and keep it depressed while clicking sheet tabs.
The Excel will generate all of the clicked sheets.

To select all sheets, follow the steps below:
 Right-click a sheet tab and choose “Select All Sheets”.

To select the active sheet and the previous sheet:
 Click Shift + Ctrl + Page Up.

To select the active sheet and the following sheet:
 Click Shift + Ctrl + Page Down.
Don’t forget that you're working with a multi-sheet selection so be reminded that when you do something to the current sheet, Excel repeats for every sheet in the selection.

If you make changes to a selection of sheets when you meant to change only the active sheet, you may have a lot of damage to repair.
You can avoid confusion by canceling a multi-sheet selection task as soon as you finish your multi-sheet tasks.
To do so:
 Click an unselected sheet or right-click a selected sheet tab and choose Ungroup Sheets.

When I select a couple sheets I receive this message when I try typing in the cell. Do you know a work around so I can type in my cell?

"you cannot make changes to a table or XML mapping when multiple sheets are selected"


All times are GMT -4. The time now is 04:22 PM.


Copyright © 2005-2013 SysChat.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54