If the cell you are currently in is adjacent to non-empty cells, a region will be selected, but run the shortcut again and the entire sheet will be selected.ĬTRL + F/H To search for a string, use shortcut CTRL + F and keep pressing Enter to move through the results. Select a range or entire sheetĬTRL + A If the cell you are currently in is empty and all cells surrounding it are empty, this command will select the entire sheet. If your row or columnĬontains data, these commands will jump to the next cell containing data. Move quickly around the worksheetĬTRL + ←/↑/→/↓ Move between the start and end of a row or column using these commands. The =SUM formula will pop up, check the cells you'd like totaled are highlighted then press Enter. Auto sum valuesĪLT + = If you'd like to quickly sum a column or row of values, head to the first empty cell at the end of the list, hold down ALTĪnd press =. We've pulled together a list of the best Excel shortcuts that you'll find so useful you won't go be able to go back to your old ways! 1. Here at PDFTables, we're all about saving you time and money and that doesn't stop after converting your PDF to Excel.
0 Comments
Leave a Reply. |