Here at PDFTables, we're all about saving you time and money and that doesn't stop after converting your PDF to Excel.
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. Auto sum values
= 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
=SUM formula will pop up, check the cells you'd like totaled are highlighted then press Enter.
2. Move quickly around the worksheet
←/↑/→/↓ Move between the start and end of a row or column using these commands. If your row or column
contains data, these commands will jump to the next cell containing data.
3. Select a range or entire sheet
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 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.
4. Search and/or replace
F/H To search for a string, use shortcut
F and keep pressing Enter to move through the results. The
search and replace, use
H, fill in the 'Find what:' and Replace with:' boxes to fit your requirements. To replace one at a time,
click 'Replace' and keep hitting enter, or to replace all instances at once click 'Replace All'. Using the Tab button is quick way to move around
this box without using your mouse.
5. Paste special
V Opens up a menu of paste special options. Each option has 1 letter underlined - use these letters to make your
selection quickly. If you are always using one or two of the options, you will soon remember the keyboard sequence and be able to paste special in a matter
6. New line within a cell
Enter When typing within a cell, use this command to start a new line within that cell.
7. Bold, italic, underline or strikethrough
B/I/U/5 These commands will enable you to format one or many cells to bold, italic, underline or strikethrough. If you hold
CTRL and press a sequence of the letters, you can quickly apply multiple formatting options.
8. Number formats
1/5/6/7 These will format the selected cell(s) as number, percentage, standard form or add a cell border respectively.
9. Insert or delete a cell
+ will bring up the insert a cell option box or
- will bring up the delete a cell option box.
10. Select an entire row or column
Spacebar You can select the entire row or column that your current selected cell is in.
Do you need more Excel help?
Contact us and one of our team will be happy to help!
Also, check out our other blog posts here or our FAQ page.