Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells.

Clicking "AutoFit Column Width" forces Excel to adjust the width of the columns you selected so that they are wide enough to display their contents. Every Excel spreadsheet has a "Select All" button.

A Group dialog box will open, displaying the options Columns or Rows. Select the option you want and click OK. On the left of the spreadsheets, you will see buttons that you can use to hide the ...

2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top. 3.

When you support Excel users, one of the most common questions you’ll hear is, “I’ve got a list with a thousand entries in a column, and many of those are duplicates.