As part of our series on LinkedIn, Tuesday Timesavers are quick tips to help make your daily Excel tasks faster and easier.
Tuesday Timesaver #1: Using borders around your Excel tables? Save time when editing or expanding the table. First, make all changes, then highlight the whole table (CTRL + A), remove all existing borders (CTRL + SHIFT + _), and finally, redo the outline border (CTRL + SHIFT + &).
Tuesday Timesaver #2: To copy and paste a cell in Excel a single step, highlight the starting cell and the target cells using SHIFT + Arrow key(s). CTRL+D will copy down; CTRL+R will copy right. But to copy just one cell there is no need to initially highlight. Simply put your cursor one cell below the cell to be copied and hit CTRL+D (or one cell to the right and hit CTRL+R).
Tuesday Timesaver #3: Looking to delete/add rows or columns quickly to your spreadsheet? Highlight a row using SHIFT + SPACEBAR or a column using CTRL + SPACEBAR. To delete the highlighted row or column, use CTRL + “-”. To add a row above the highlighted row or to add a column to the left of the highlighted column, use CTRL + SHIFT + “+”. Note that if you’re using the “+” on the number pad on a full keyboard to add rows or columns, you don’t need to hold SHIFT.
Tuesday Timesaver #4: Looking to jump to a precedent cell quickly in Excel? For instance, if you click on a cell that contains =Sheet1!G20, press “CTRL + [” to jump directly to Sheet1!G20. To return to your original formula cell, hit F5 and then press ENTER.