|
» Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
CATEGORY: Excel Consolidating |
VERSIONS: All Microsoft Excel Versions |
|
To color and/or copy subtotals summary from consolidated Lists: 1. In the Subtotal levels, click level 1. 2. Select a cell in the List and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A). 3. Select visible cells, and press Alt+;. OR Press F5 and in the Go To dialog box, click Special. In the Go To Special dialog box, select Visible cells only and click OK. 4. Copy and paste the subtotals summary into a different sheet or choose a color from the Fill Color icon in the Formatting toolbar. |
| Screenshot // Coloring and/or Copying Subtotals from Consolidated Lists Containing Links |
  |
|
RATING:
4.29
VIEWS: 8776 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
