Modifying Worksheets

Modifying Worksheets

• Change the width and height of columns and rows
• Adding space between the edge of worksheet and cells makes the workbook's contents less crowded.
• Insert row, column, or cell in a worksheet with the existing format the Insert Options button will appear.
• Format Same as Above is applying the format of the row above the inserted row to the new row
• Format Same as Below is applying the format of the row below the inserted row to the new row
• Format Same as Left is applying the format of the column to the left of the inserted column to the new column
• Format Same as Right is applying the format of the column to the right of the inserted column to the new column
• Clear Formatting is applying the default format to the new row or the new column
• Deleting and hiding and unhiding can be accessed by right clicking
• Insert individual cells
• Move data in a group of cells to another place in the worksheet