Difference between revisions of "Excel Formatting for SSMT"
Jump to navigation
Jump to search
(Created page with "Rather than format one sheet at a time, you can save time by formatting your whole workbook at once. Add several sheets to your workbook as needed for SSMT [[File:Screen Shot 1....") |
John.Buckley (talk | contribs) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Category:SSMT]] | ||
Rather than format one sheet at a time, you can save time by formatting your whole workbook at once. | Rather than format one sheet at a time, you can save time by formatting your whole workbook at once. | ||
Add several sheets to your workbook as needed for SSMT | Add several sheets to your workbook as needed for SSMT | ||
| + | |||
[[File:Screen Shot 1.jpg]] | [[File:Screen Shot 1.jpg]] | ||
| + | |||
| + | |||
Left mouse click on the very first sheet, hold down SHIFT & click the very last sheet (Note how all sheets are now selected and appear white) | Left mouse click on the very first sheet, hold down SHIFT & click the very last sheet (Note how all sheets are now selected and appear white) | ||
| − | Screen Shot 2 | + | [[File:Screen Shot 2.jpg]] |
| − | + | ||
Format the sheets as text (as required for SSMT) | Format the sheets as text (as required for SSMT) | ||
| − | + | ||
| + | [[File:Screen Shot 3.jpg]] | ||
| + | |||
| + | |||
| + | Now Right-click on any sheet to “Ungroup sheets” when done. Your WHOLE workbook is now formatted at once. | ||
| + | Please Note: Right-clicking on a worksheet and “selecting all sheets” will NOT format the whole workbook as it may seem. It only formats THAT particular worksheet. | ||
| − | + | [[File:Screen shot 4.jpg]] | |
| − | + | ||
| − | Screen shot 4 | + | |
| + | |||
| + | Back to [[SSMT]] | ||
Latest revision as of 23:39, 26 November 2012
Rather than format one sheet at a time, you can save time by formatting your whole workbook at once. Add several sheets to your workbook as needed for SSMT
Left mouse click on the very first sheet, hold down SHIFT & click the very last sheet (Note how all sheets are now selected and appear white)
Format the sheets as text (as required for SSMT)
Now Right-click on any sheet to “Ungroup sheets” when done. Your WHOLE workbook is now formatted at once.
Please Note: Right-clicking on a worksheet and “selecting all sheets” will NOT format the whole workbook as it may seem. It only formats THAT particular worksheet.
Back to SSMT