Skip to main content
Logo
Submit a request
  1. Help Center - Hancom Office
  2. Hancom Office 2020
  3. Cell

Cell

  • Create a sparkline chart
  • Create a pie chart
  • Freeze panes in the spreadsheet
  • Create a dropdown list
  • Insert the recommended chart in spreadsheet
  • Save automatically your work to Hancom Space
  • Swap data in rows with the data in columns
  • Applying conditional formatting to cells
  • Fill row or column with a series of data
  • Create a PivotTable
  • Hide or unhide columns
  • Print spreadsheet with visible gridlines
  • Recording a new macro
  • Using freeze panes to lock cells in place
  • Grouping rows or columns
  • Adding autocomplete text for frequently used phrases
  • Sorting your spreadsheet data
  • Allow editing specific ranges within a protected spreadsheet
  • Adding a password to protect a spreadsheet workbook or sheet
  • Spellchecking a spreadsheet
  • Creating a form with form controls
  • Creating a table
  • Creating a PivotTable Group
  • Creating a PivotTable from external data
  • Creating a PivotTable
  • Using Benford Analysis to determine unusual data patterns
  • Using Goal Seek to determine the required value to achieve your goal
  • Using the Scenario Manager to create and analyze a scenario
  • Create a consolidated report
  • Remove duplicate values in spreadsheet range
  • Next ›
  • Last »

© Help Center - Hancom Office