For each platform, understand:

1. Microsoft Excel / Google Sheets

Removing Horizontal Rows:

  1. Select the row(s) you want to remove by clicking the row number on the left.
  2. Right-click and choose Delete.
  3. Alternatively, use the Delete Row option in the menu.

Removing Symbols:

  1. Use Find and Replace:
    • Press Ctrl + H (Windows) or Cmd + H (Mac).
    • Enter the symbol you want to remove in Find.
    • Leave Replace with empty and click Replace All.
  2. Use formulas for bulk cleaning (optional):
    • Example: =SUBSTITUTE(A1, "#", "") removes all # symbols from cell A1.

2. Microsoft Word / Google Docs

Removing Horizontal Lines (Borders):

  1. Place the cursor above the line.
  2. Go to Format > Borders and Shading (Word) or Format > Paragraph styles > Borders (Docs).
  3. Select None to remove the line.

Removing Symbols:

  1. Use Find and Replace (Ctrl + H / Cmd + H) to locate and remove unwanted symbols.
  2. Check Special Characters for symbols like paragraph marks or bullets.

3. Web Design Platforms (HTML / CSS)

Removing Horizontal Rows (Lines):

  • Identify the HTML element <hr> (horizontal rule).
  • Delete the <hr> tag or set CSS style to display: none;.

Removing Symbols:

  • Symbols may appear as text or icons. Remove them directly from the HTML code or CSS content property.
  • For special characters, check the Unicode entity and delete it if unnecessary.

4. Power BI / Tableau

Removing Horizontal Gridlines:

  • Power BI: Go to Format > Gridlines and toggle Off for rows.
  • Tableau: Right-click on the axis, choose Format, then remove Gridlines.

Removing Symbols:

  • Use Calculated Fields or Replace Values to remove unwanted characters from your dataset.

Tips for All Platforms

  • Always make a backup before bulk removing rows or symbols.
  • Use search and replace functions to save time.
  • Understand platform-specific shortcuts to speed up your work.
  • Clean data or documents regularly to maintain clarity and professionalism.
Home » E-COMMERCE FOUNDATIONS (STARTER) > Marketplace Introduction > For each platform, understand: