Test Page

Create and Manage Worksheets and Workbooks

Create Worksheets and Workbooks

  • Create a workbook
  • Import data from a delimited text file
  • Add a worksheet to an existing workbook
  • Copy and move a worksheet

1.2 Navigate in Worksheets and Workbooks

1.2.1 Search for data within a workbook 1.2.2 Navigate to a named cell, range, or workbook element 1.2.3 Insert and remove hyperlinks

1.3 Format Worksheets and Workbooks

1.3.1 Change worksheet tab color 1.3.2 Rename a worksheet 1.3.3 Change worksheet order 1.3.4 Modify page setup 1.3.5 Insert and delete columns or rows 1.3.6 Change workbook themes 1.3.7 Adjust row height and column width 1.3.8 Insert headers and footers

1.4 Customize Options and Views for Worksheets and Workbooks

1.4.1 Hide or unhide worksheets 1.4.2 Hide or unhide columns and rows 1.4.3 Customize the Quick Access toolbar 1.4.4 Change workbook views 1.4.5 Change window views 1.4.6 Modify document properties 1.4.7 Change magnification by using zoom tools 1.4.8 Display formulas