A blog about Excel and its users
Dragging your mouse around to select cells is tedious and can result in some pretty wild failures due to Excel's sometimes erratic scrolling. The preferred method of selecting cells is to do so with the arrow keys, one cell at a time. That way you can be accurate and efficient, without making a mistake.
Select the cell you wish to start your selection from. This is usually one end of the array of data or the other. Starting in the middle will only add unwanted steps to the process.
From here I want to select only the first 5 cells.
To do so, hold the Shift key and tap the Down Arrow until the cells you wish to select are all highlighted.
Now I can copy, cut, change font, or anything else I want to do with these 5 cells and I never had to take my fingers off the keys!
Feel free to comment on any Excel on Mac questions you may have!