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