“Most useful” is certainly in the eye of the beholder. The shortcuts Actionįill selected cells with an entry you typed in one cellįill data down or to the right through selected cellsĬtrl] and (semicolon) or Ctrl and : (colon) Note: This article is also available as a PDF download. Ctrl+Shift+Arrow key extends the selection of cells to the last nonblank cell in. Shift+Arrow key extends the selection of cells by one cell. Ctrl+Arrow key moves to the edge of the current data region in a worksheet. Here are 10 timesavers that put the short in shortcut. Other useful shortcut keys Move one cell up, down, left, or right in a worksheet. But on a practical level, mastering 10 genuinely useful shortcuts will get you a lot farther than a vague knowledge of 50 shortcuts you seldom use and can’t remember. It’s great to know the resources are out there. You can tap the Help files, hunt the info down via Google, or download a comprehensive list, like this Excel cheat sheet. Why complicate your spreadsheet life with a bunch of tricks you'll never use? These 10 shortcuts will expedite the Excel tasks you perform every day.Īs we’ve observed before, there’s no shortage of information on Microsoft Office keyboard shortcuts. The 10 most useful Excel keyboard shortcuts
0 Comments
Leave a Reply. |