We know all to well how long it can take you to perform certain tasks using Microsoft Excel as they can be very repetitive. That’s why we have decided to create some useful tips for Microsoft Excel to help you improve the speed you complete tasks at along with helping you to remove some of the repetitive tasks that waste your time.
We have outlined below some useful keyboard shortcuts to help you when you are using Microsoft Excel.
Ctrl & Shift & Arrow Key
This key combination is used to extend a selection to the last cell with content in a row or column (works in 2010 & 2013). It makes selecting text easier when working with large volumes of information in a spreadsheet.
Ctrl & Shift & !
This key combination will change the format of numbers in a cell/cells to decimal format with two decimal places (25 to 25.00).
Ctrl & Shift & %
This key combination will change the format of numbers in a cell/cells to percentage (%) format.
Remember to follow us on Facebook, Linkedin and Twitter to be kept up to date with all of our latest tips as we create them and to see all of our latest news and competitions.