Excel how to format the information collected

To format information in columns and remove what is not needed in Excel, these are the supported options:

1. Format the data in columns
   • Select the cells or column.
   • Go to the Home tab.
   • For text display:
     • Use Wrap Text in the Alignment group to show multiple lines in one cell.
     • Use alignment options to reposition text in the cell.
     • Use Increase Indent instead of typing spaces.
   • For numbers, dates, or times:
     • In the Home tab, use the Number Format box to choose the correct format.
     • If needed, select More Number Formats for additional options.
2. Format a range as a table
   • Select any cell in the data range.
   • On the Home tab, select Format as Table.
   • Choose a table style.
   • This helps organize related data and makes sorting and filtering easier.
3. Copy formatting to other columns or cells
   • Use Home > Paste > Paste Special > Paste Formatting.
   • Or use Home > Format Painter.
   • Another option is to right-click-drag the selected cells to a new range and choose Copy Here as Formats Only.
4. Delete information that is not needed
   • If the unwanted content is in a table and both the data and formatting should be removed, select all cells in the table, click Clear, and choose Clear All.
   • If only the table style should be removed, select a cell in the table, then use Home > Format as Table or Table Design > Table Styles, and select Clear.
5. If dates or values are not formatting correctly
   • Select the affected column.
   • Go to Data > Text to Columns.
   • In the wizard, keep Delimited selected, click Next, then Next again.
   • On the last screen, choose the correct data type such as Date and select the correct order, then click Finish.
6. If only manually entered data should be cleared but formulas kept
   • Select the range.
   • Press F5 > Select Special.
   • Choose Constants.
   • Select the data types to remove, click OK, then press Delete.

For cleaner worksheets, use column labels in the first row, use borders instead of blank rows, and avoid leading or trailing spaces.

• Ways to format a worksheet
• Format an Excel table
• Guidelines for organizing and formatting data on a worksheet
• Delete a table
• Enter data manually in worksheet cells
• Changing date format without adding extra columns - Microsoft Q&A
• how do you clear cells of data but not formula's. Rows or colunms or the whole spread sheet? - Microsoft Q&A