Report and Others: Difference between revisions
No edit summary |
Removed Recap |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[File: | [[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]] | ||
= Report and Review = | = Report and Review = | ||
| Line 9: | Line 9: | ||
=== [[Show IND]] === | === [[Show IND]] === | ||
Shows or Hides HD's on the Summary Page | Shows or Hides HD's on the Summary Page | ||
[[Add User Item]] | |||
Adds a New User Added Item | |||
* Only on Summary, Recoverable | |||
=== [[Freeze Top]] === | === [[Freeze Top]] === | ||
| Line 56: | Line 61: | ||
== Breakdown == | == Breakdown == | ||
=== [[View BD]] === | |||
Shows a view of all Breakdown Sheets and their order | |||
===== [[Make B.D.]] ===== | |||
Creates an additional Breakdown sheet to be used in the Workbook | |||
===== [[Push To Target]] ===== | |||
Pushes all Marked data to a Target Excel book | |||
=== [[BD Helper]] === | |||
Enlarges the view of a BD cell on a Div for easier editing | |||
=== [[Enable B.D.]] === | === [[Enable B.D.]] === | ||
Hides and Unhides the Breakdown (Alpha Label) Column on Div's | Hides and Unhides the Breakdown (Alpha Label) Column on Div's | ||
=== [[ | === [[Insert Letter]] === | ||
Inserts a new letter into the Breakdown Sheet | |||
=== [[Insert Space]] === | |||
Inserts a space line into the Breakdown Sheet | |||
=== [[ | === [[Insert SubTotal]] === | ||
Inserts a SubTotal line into the Breakdown Sheet | |||
=== [[ | === [[Delete Any]] === | ||
Deletes Any Line on the Breakdown Sheet | |||
=== [[ | === [[Flip Lock]] === | ||
Flips the Disperse Lock for each Letter | |||
=== [[ | === [[Show Targets]] === | ||
Reveals or Hides the Target Columns on a Div | |||
== More == | == More == | ||
| Line 84: | Line 102: | ||
=== [[PrintToPDF]] === | === [[PrintToPDF]] === | ||
Prints the Workbook to a Pdf | Prints the Workbook to a Pdf | ||
==== Print Client Book ==== | |||
Prints the Book with specfic pre-set settings | |||
==== Print Default ==== | |||
Prints the Book with specfic pre-set settings | |||
=== [[Reformat]] === | === [[Reformat]] === | ||
| Line 91: | Line 115: | ||
==== Reformat Workbook ==== | ==== Reformat Workbook ==== | ||
Reformats the Entire Workbook | Reformats the Entire Workbook | ||
== Budget Summary Options == | == Budget Summary Options == | ||
Latest revision as of 23:51, 5 December 2023
Report and Review
General Settings
Shows or Hides HD's on the Summary Page
Shows or Hides HD's on the Summary Page
Adds a New User Added Item
- Only on Summary, Recoverable
Freezes the Top few lines so they stay with you as you scroll
Changes the Current Workbook Theme
Sets the Page Breaks for the Workbook
Sets the Page Break for the Current Worksheet
Summary Settings
Shows or Hides SD's on the Summary Page
Shows or Hides HD's on the Summary Page
Show or Hides Zeros on the Summary Page
Adds extra lines to the bottom of the Summary Page
Adds extra comments to the bottom of the Summary Page
Will create a blank worksheet that can be used for anything
Worksheet Settings
Enables or Disables the Bond Column
Adds a line at the end of a Div sheet to show that its the end
Changes the Tab Color of the Worksheet to Green/Approved
Breakdown
Shows a view of all Breakdown Sheets and their order
Creates an additional Breakdown sheet to be used in the Workbook
Pushes all Marked data to a Target Excel book
Enlarges the view of a BD cell on a Div for easier editing
Hides and Unhides the Breakdown (Alpha Label) Column on Div's
Inserts a new letter into the Breakdown Sheet
Inserts a space line into the Breakdown Sheet
Inserts a SubTotal line into the Breakdown Sheet
Deletes Any Line on the Breakdown Sheet
Flips the Disperse Lock for each Letter
Reveals or Hides the Target Columns on a Div
More
Re-Calculates the entire Workbook
Prints the Workbook to a Pdf
Print Client Book
Prints the Book with specfic pre-set settings
Print Default
Prints the Book with specfic pre-set settings
Reformats the Page to its Intended State
- Only works for Div's
Reformat Workbook
Reformats the Entire Workbook
Budget Summary Options
Creates a budget sheet between two different workbooks (the current one and another one)
Shows or hides all SD lines on the Budget Sheet
Shows or hides all Zeros lines on the Budget Sheet
Shows or hides all HD lines on the Budget Sheet