Sign in to follow this  
Followers 0
ioliver

Ms Excel Question

2 posts in this topic

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


"Blessed be the name of the Lord" - Job 1:21Check out Search IMF

Share this post


Link to post
Share on other sites



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.


AutoIt3, the MACGYVER Pocket Knife for computers.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0