In excel, when I use the shortcut Alt+H+O+I to resize the column, it will also paste what I have copied. What shortcut am I hitting accidentally?

I often use the shortcut Alt+H+O+I when I want to autofit the column. Sometimes when I am going quickly, excel resizes the column and then pastes whatever is on the clipboard. Since I have the entire column selected when I do this, excel will sometimes crash from having to paste in an entire column of data, which is frustrating. I must be hitting another shortcut when I do this. Which one is it? (That way I can be careful not to hit it in the future.)

3

1 Answer

Only you can say for sure!

My money's on Alt H I Enter

(ie. you're going too fast and missing the O)

...which, if you have a column selected, will insert a column with the data on your clipboard in it.

(tested on MS Excel 2007 12.0.4518.1014)

Alt H I Enter is the hotkey for Insert Cells. Alt+H is the Home tab, I pulls out the 'Insert' dropdown, and Enter (or E) hits the first option, which is 'Insert Cells' or, if you have a column in your clipboard, 'Insert Copied Cells'.

7

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy