Ms Excel Question

[ioliver]

I'm trying make some changes to an Excel file with an AutoIt script. Does anyone know how to select an entire column from the keyboard or menu. I know you can do it if you click on the column letter.

Thanks again,

Ian

[scriptkitty]

Excel has a nice help file

search for keyboard shortcuts.

Keys for selecting data and cells

Select cells, rows and columns, and objects

CTRL+SPACEBAR

Select the entire column.

SHIFT+SPACEBAR

Select the entire row.

CTRL+A

Select the entire worksheet.

SHIFT+BACKSPACE

With multiple cells selected, select only the active cell.

CTRL+SHIFT+SPACEBAR

With an object selected, select all objects on a sheet.

CTRL+6

Alternate between hiding objects, displaying objects, and displaying placeholders for objects.