The Worksheet Tab toolbar provides access to all functions available on the Worksheet Tab.

Some functions have shortcut keys or are available on the Context Menu.

Button/Control	Description	Keyboard Shortcut	What it does/How it is used...
	Show Group by control		Shows the Group By panel
	Hide Group by control		Hides the Group By panel
	Clear All		Active when the Worksheet Tab is Grouped By something - removes all Groupings.
	Expand All	Right Arrow	Expands all row groupings. The Shortcut key only expands the selected section.
	Collapse All	Left Arrow	Collapses all row groupings. The Shortcut key only collapses the current section.
	Default View		Resets the Worksheet Tab to its default view/layout.
	Copy		Copies selected Row(s) for pasting into a different application(such as Excel).
	Duplicate		Duplicates a manually entered result (not associated with a Takeoff Item)
	Delete		Deletes a Result row (does not delete the Takeoff Item or the Results from the Takeoff Item, just removes this Result from the Worksheet Tab).
	Lock Columns	Ctrl + L	When selected (shaded) locks the Takeoff Item Information columns ("No." through "Total") so they remain visible when you scroll to the right to see additional columns.
	Add Takeoff Item Result	Ctrl + R	By default, the Worksheet Tab only displays the first (primary) Result for each Takeoff Item. If you like, you can add one of the other Results you specified instead of, or in addition to, the primary result.
	Add Manual Result	Ctrl + M	Adds a row where you can specify any quantity/UOM you need - not associated with any Takeoff Item.
	Edit Manual Result		Allows you to edit a previously added manual result.
	Export to Excel	Ctrl + E	Exports the current Worksheet View to an Excel spreadsheet.
	Export to Quick Bid™	Ctrl + Q	Exports the current Worksheet View to an *.OST file that can be imported into the Quick Bid Estimating program.
	Refresh Data	F5	The Worksheet Tab does not update automatically when you or another user makes a change that affects Results. This is so the screen isn't constantly refreshing/changing as you're using it. You'll be prompted to refresh (manually) anytime there are changes not reflected in what you are seeing on the screen, just just click the refresh button or hit F5 to recalculate results.

See the articles that follow for details on using basic and advanced functions of the Worksheet Tab.

The Worksheet Tab Context Menu

The Context Menu provides an alternate method to insert Takeoff Item Results, and to insert or edit Manual Results.

Using the Worksheet Tab to Generate a Unit Price Estimate

Adding Takeoff Item Property Columns to the Worksheet Tab