magnify
Home Software Microsoft Office Archive for category "Microsoft Excel"

Adding and Deleting Rows and Columns

Adding a Column Right click on the column header above the location where the new column is to be inserted. Choose Insert from the menu. The new column will be inserted to the left of the selected column.   Deleting a Column Right click on the column you wish to delete. Choose Delete.   Adding

 

Adjusting Column Width and Row Height

In Excel 2013, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen the columns to make the worksheet less cluttered. You should always widen columns that contain cells with truncated text entries or

 

Insert or Delete a Drop-Down list in Excel

 Inserting a Drop-Down List To make data entry easier in Excel, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere in the workbook. When you create a drop-down list for a cell, it displays an arrow in that cell.