fbpx

How To Hide A Column In Sharepoint List

SharePoint users often need to hide certain columns in their lists to focus on the relevant information. Here’s a guide on how to hide a column in a SharePoint list.

To hide a column in a SharePoint list, you can follow these steps:

  1. Open the list or library for which you want to hide the column.
  2. If you are in a list, open an item to view the item details in the display form. If you are in a document library, select a file.
  3. In the Information Pane, locate the Properties section and click Edit all.
  4. At the top of the form, select Edit form > Edit columns.
  5. In the Edit columns pane, check the checkbox for the column you want to hide.
  6. To rearrange the order of the columns, you can drag-and-drop the column name or use the options menu to move it up or down.
  7. When you’re done, select Save.

You can also hide a column based on another column’s value by specifying a conditional formula. To do this, navigate to the desired column in the Edit columns pane, select the Edit conditional formula option in the options menu, and specify the conditional formula based on the value of another column.

It’s important to note that hiding a column doesn’t affect the column or its data. It provides a way to temporarily remove the column from the form without deleting it.

Steps to Hide a Column in SharePoint List

To hide a column in a SharePoint list, you need to follow a series of simple steps:

  1. Open the list or library for which you want to hide the column.
  2. If you are in a list, open an item to view the item details in the display form. If you are in a document library, select a file.
  3. In the Information Pane, locate the Properties section and click Edit all.
  4. At the top of the form, select Edit form > Edit columns.
  5. In the Edit columns pane, check the checkbox for the column you want to hide.
  6. To rearrange the order of the columns, you can drag-and-drop the column name or use the options menu to move it up or down.
  7. When you’re done, select Save.

You can also hide a column based on another column’s value by specifying a conditional formula. To do this, navigate to the desired column in the Edit columns pane, select the Edit conditional formula option in the options menu, and specify the conditional formula based on the value of another column.

It’s important to note that hiding a column doesn’t affect the column or its data. It provides a way to temporarily remove the column from the form without deleting it.

Summary

In conclusion, to hide a column in a SharePoint list, follow these steps: open the list or library, access the item details or select a file, click Edit all in the Information Pane, choose Edit form > Edit columns at the top of the form, check the checkbox for the column you want to hide, rearrange columns if needed, and finally, save your changes. Additionally, you can hide a column based on another column’s value by using a conditional formula. Remember that hiding a column is a temporary action that does not delete the column or its data.

Rearranging Columns and Specifying Conditional Formulas

In addition to hiding columns, SharePoint also allows users to rearrange the order of columns and specify conditional formulas. This can be beneficial for organizing data and customizing the appearance of the SharePoint list.

To rearrange the columns, simply navigate to the Edit columns pane. From there, you can easily drag-and-drop the column name to the desired position or use the options menu to move it up or down. This feature enables users to prioritize important columns and ensure a seamless flow of information.

Furthermore, SharePoint provides the ability to specify conditional formulas for columns. This means that a column can be hidden based on the value of another column. To utilize this feature, select the desired column in the Edit columns pane and choose the Edit conditional formula option from the options menu. Users can then specify the necessary conditions and criteria for hiding the column based on the value of another column. This allows for greater customization and automation in SharePoint list management.

Example: Conditional Formula for Hiding a Column

If the Status column is equal to “Completed”, hide the Target Date column.

Column Conditional Formula
Status =IF([Status]=”Completed”,TRUE,FALSE)
Target Date =IF([Status]=”Completed”,FALSE,TRUE)

Summary

Rearranging columns and specifying conditional formulas in SharePoint offers users a flexible way to customize their lists and enhance the overall user experience. With the ability to easily adjust column order and hide columns based on conditional criteria, users can effectively manage and organize their data in a way that suits their specific needs.

Can I Use the Same Method to Hide a Column in All Sites in SharePoint?

Yes, you can use the same method to hide a column in view all SharePoint sites. By following a simple procedure, you can ensure that the column remains hidden across all sites within SharePoint. This method allows for consistency and an efficient management of columns throughout your SharePoint environment.

Can I Hide a Column in a SharePoint Knowledge Base?

Yes, you can hide a column in a SharePoint knowledge base. By using the “create knowledge base in SharePoint” option, you can easily customize the columns in your knowledge base to fit your specific requirements. Simply go to the settings menu, select “list settings,” and then click on “column settings.” From there, you can choose to hide any column as needed.

Important Considerations when Hiding a Column

While hiding a column in a SharePoint list can improve the user experience, it’s important to remember that the column and its data remain intact, providing a temporary removal option without permanent deletion.

To hide a column in a SharePoint list, follow these simple steps:

  1. Open the list or library for which you want to hide the column.
  2. If you are in a list, open an item to view the item details in the display form. If you are in a document library, select a file.
  3. In the Information Pane, locate the Properties section and click Edit all.
  4. At the top of the form, select Edit form > Edit columns.
  5. In the Edit columns pane, check the checkbox for the column you want to hide.
  6. To rearrange the order of the columns, you can drag-and-drop the column name or use the options menu to move it up or down.
  7. When you’re done, select Save.

You can also hide a column based on another column’s value by specifying a conditional formula. To do this, navigate to the desired column in the Edit columns pane, select the Edit conditional formula option in the options menu, and specify the conditional formula based on the value of another column.

It’s important to note that hiding a column doesn’t affect the column or its data. It provides a way to temporarily remove the column from the form without deleting it.