Q. I know there are loads of Excel shortcuts that allow me to avoid using the mouse. Maybe you can help me find a shortcut for deleting individual cells and for highlighting a column or row.
A. You’re in luck. There’s help for both. To delete a cell, put your cursor in the cell and press Ctrl+– (that’s Control and the minus key in the numeric keypad). It’ll instantly bring up the delete cell menu.
To highlight a column without the mouse, move the cursor anywhere in the column and press Ctrl+Space Bar and the entire column automatically will be selected. To highlight a whole row, put the cursor anywhere in the row and press Shift+Space Bar.
|Do you have a
technology question for this column? Send it to Senior Editor
Stanley Zarowin via e-mail at firstname.lastname@example.org
or regular mail at the Journal of Accountancy,
Harborside Financial Center, 201 Plaza Three, Jersey City,
NJ 07311-3881. We regret that we cannot answer letters
individually. If a question asked by a reader is deemed to have
sufficiently broad interest, we will answer it in a forthcoming
Technology Q&A column. |