Excel Tips

Delete Columns | Select and Delete Multiple Rows | Add Column | Sort Data | Freeze Panes | Add up Column | Print Row Numbers | Print Selection

How to Delete Extra Columns in Excel

Alternate Way to Select and Delete Multiple Columns

Here is an easy way to delete several columns at a time. Highlight one column on its letter heading and hold down the left mouse button, dragging as far right as you want. Let go. Right-click in the highlighted section and choose Delete from the menu to delete the whole block at once.

How to delete five columns at a time.

Select and Delete Multiple Rows.

Add a Column

Insert a column

Insert a column

Sort a Column in Excel.

Select the whole Excel spreadsheet by clicking the leftmost, topmost blank cell above the rows 1, 2, 3,... and to left of columns A, B, C...
select leftmost, topmost blank cell

Freeze Panes

To keep titles in sight, divide or split the worksheet by freezing the titles in their own pane. The title pane is then locked in place as you scroll through the rest of the worksheet. /

You freeze panes by making a selection in the worksheet, which you'll learn how to do in the next section, and then clicking Freeze Panes on the Window menu.

There's a secret to success: To freeze titles, do not select the titles themselves. To freeze:

  1. Freeze column titles by selecting the row below.
  2. Freeze row titles by selecting the column to the right.
  3. Freeze both column and row titles by selecting the cell that is just below the column titles and to the right of the row titles.

Sum Column

Print Row Numbers

Print Selection