Worksheet has over 40 columns of information. Showing all these columns would take up too much room on the screen and on a printout. As such, some columns are not displayed by default. Use Customize Columns to show certain details of items like Tag or discount information, or to hide details such as the List Price.
Use the Columns information drop-down menu (found on the View ribbon) to define which columns will be displayed in the worksheet. From here, you can also change the column header text and the column order.
-
Click
on the View ribbon.
-
Select Customize Columns.
OR
Right-click on any column header then select Customize Columns.
Note: In the Worksheet Properties dialog, you can view columns using either the Standard or Grouped view. In Grouped View, columns are organized by categories. -
Customize the columns click Apply then Close to return to the Worksheet.
|
To: |
Do this: |
|
Display or hide a column |
Check or clear the check boxes next to the column names. In Grouped View, if you want to check all columns under one group, check the group name. |
|
Modify a column's position in the worksheet (you can do this only in Standard view) |
Select the column and drag it up or down. |
|
Change the column header text |
Change the Text value. This field can be used to add your own customized columns. For example, click on one of the Alias columns, then change the Text value. |
|
Resize the column width |
Beside Width, enter the value in pixels. For a quicker way, see Resize Columns. |
|
Define the justification of text in the column |
Change Justify to Left, Center or Right. |
|
Change the data type accepted by the column |
Beside Type, select the data type. You can only change the data type of certain columns. |
|
Disable a column, make it read-only or set is as readable and writable |
Beside Mode, select: Disabled - user cannot click on the column Read Only - user can click but cannot modify a value Read and Write - user can click and modify a value |