Excel how to format the information collected

Merry Ann Cutler 0 Reputation points
2026-09-06T19:34:45.39+00:00

how to format info in columns and delete what is not needed

Microsoft 365 and Office | Excel | Other | Windows

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kai-H 26,135 Reputation points Microsoft External Staff Moderator
    2026-09-09T09:43:17.67+00:00

    Hi, Merry Ann Cutler

    It sounds like the worksheet contains collected data that needs to be separated, reviewed, and cleaned up. Before making changes, save a copy of the file so you can restore anything removed by mistake.

    If each type of information already has its own column, turn on Data > Filter. Use the arrow at the top of a column to show only blank, unwanted, or incorrect entries. Select the visible row numbers, right-click, and choose Delete Row. Clear the filter afterward to see the remaining data.

    If an entire column is unnecessary, select its column letter, right-click, and choose Delete. The other columns will shift automatically. You can press Ctrl+Z immediately if the wrong column or row is removed.

    For repeated entries, select the data and use Data > Remove Duplicates. Choose only the columns Excel should compare. This permanently removes duplicates, so reviewing or copying the original data first is recommended.

    If possible, share a small example with personal information removed, since the best cleanup method depends on how the collected data is currently arranged.

    Thank you for your patience in reading, I hope this information has been helpful to you. 

    If the answer is helpful, please click "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-09-06T19:35:03.9966667+00:00

    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.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.