Learn more

Changing the size of the spreadsheet columns

Changing the spreadsheet column headings

Eliminating excess column width on the spreadsheet (Best Fit Column)

Making spreadsheet columns non-scrolling

Turning spreadsheet columns on or off

Changing the order of the spreadsheet columns

To change the order of the spreadsheet columns:

  1. Use the mouse to select the headings of the columns you want to move. You can move one column, or multiple, adjacent columns. Columns that have both a quantity and a unit move the two together.

    The cursor changes to a four-way arrow.

  2. Press and hold the mouse button as you drag the selected columns to their new location. Release the mouse button to insert the columns.

Tips:  

  • You can use this feature to customize the appearance of the Spreadsheet report:

    1. Follow the procedure above to move the spreadsheet columns where you want them.
    2. Select the Spreadsheet report from the Estimate Reports group on the Reports tab.

    3. Click [Report Options], and then click [Prefill from Spreadsheet] in the Spreadsheet Report Options window.

      The report settings now match the setup of your estimate spreadsheet.

  • You can also change the order of the spreadsheet columns in the Modify Spreadsheet Layout window.

    1. Click Home tab > Sequence group > [Layout].
    2. Select the column name you want to move, and then click Reposition Column to move the column to a new location.