Import data into workbooks

• Import data from .txt files
• Import data from .csv files

Navigate within workbooks

• Search for data within a workbook
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks

Format worksheets and workbooks

• Modify page setup
• Adjust row height and column width
• Customise headers and footers

Customise options and views

• Customise the Quick Access toolbar
• Display and modify workbook content in different views
• Freeze worksheet rows and columns
• Change window views
• Modify basic workbook properties
• Display formulas

Configure content for collaboration

• Set a print area
• Save workbooks in alternative  file formats
• Configure print settings
• Inspect workbooks for issues

Manipulate data in worksheets

• Paste data by using special paste options
• Fill cells by using Auto Fill
• Insert and delete multiple columns or rows
• Insert and delete cells

Format cells and ranges

• Merge and unmerge cells
• Modify cell alignment, orientation, and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats from the
• Format Cells dialog box
• Apply cell styles
• Clear cell formatting

Define and reference named ranges

• Define a named range
• Name a table

Summarise data visually

• Insert Sparklines
• Apply built-in conditional formatting
• Remove conditional formatting