Tips & Tricks

line2.png#asset:2933

How do I change cells to percentage format in Microsoft Excel?

Use CTRL+SHIFT+5 to change cells to currency format in Microsoft Excel.

How do I apply outline border to cells in Excel?

Use CTRL+SHIFT+7 to apply outline border to your selected cells.

How do I copy the value from the cell above in Excel?

To copy the value from the cell above to the current cell use CTRL+@

How do I move to the last cell in the Row or Column in Excel?

Provided there are no blank cells in your data, press CTRL+DOWN Arrow to move to the last row in the data set. Use CTRL+UP Arrow to move to the first row in the data set.

How do I do Find and Replace in Microsoft Excel?

How do I do Find and Replace in Microsoft Excel? Use CTRL+H to find and replace in Microsoft Excel

How do I select the current region in Excel?

Fed up with dragging a range - this is a great tip. From a laptop without the number pad - Press CTRL+SHIFT+8 (this gets you to the *). The current range is the whole dataset, in all directions from the current cell until Excel hits the edge of the worksheet or a completely blank row and column. On a desktop computer, pressing CTRL+* the a numeric keypad will work also.

How do I move around selected data in Excel?

After you have highlighted a large amount of data - you may want to move around that data - ie back to the top. Pressing CTRL+. (CTRL+ full stop) will allow you to jump to the next corner - repeating this will take you to the top.

How do I select a Row or Column in Excel using the keyboard?

Press SHIFT+SPACEBAR to select an entire row or CTRL+SPACEBAR to select an entire column using the keyboard in Excel

How do I see the shortcut keys for the Ribbon in Office?

Press the ALT key on the keyboard to see the shortcut keys for the ribbon - pressing the letter or number will then take you to that command.

Back to top