![]() To select a column, move to the first cell in the column and press CONTROL + SHIFT + DOWN ARROW.To select the entire worksheet, press CONTROL + A twice.To select a data range, move the focus inside the range and press CONTROL + A.To select cells, go to the top left cell and with SHIFT held down press the DOWN ARROW and RIGHT ARROW to extend the selection down and right.Here are just some of the ways you can select a range of cells using the keyboard: Tip: If you find the Excel Quick Analysis option taking focus away from the worksheet when you begin selecting cells then go to Excel's Options (ALT + F, T) and in the "General" category deselect the "Show Quick Analysis options on selection" check box. Some ways only use the keyboard, some only use the mouse and some use a combination of both. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |