Useful shortcuts for Microsoft Excel

0
42

Let’s straight into Useful shortcuts for Microsoft Excel. Keyboard shortcuts are great because they help you bypass menus, and allow you to carry out commands immediately learning just a few of them can dramatically speed up your work.

Useful shortcuts for Microsoft Excel
Image: Excel Intro screen

There are a huge amount of shortcuts for Microsoft Excel. So, here are some of the most useful type-

Ctrl + spacebar to select the current column
Type Shift + spacebar to select the current row
If you want to move to the beginning of the worksheet use Ctrl + Home
To move to the last cell of the worksheet use Ctrl + End
To paste a function into a formula type Shift + f3
To select everything when you are not editing or editing a formula type Ctrl + a
To calculate all the sheets in an active worksheet use f9 use Shift + f9
To calculate the active worksheet press f5
To display the go to box to enter the current date into the active cell type Ctrl + semicolon (;)
To enter the current time into the active cell type Ctrl + :
To enter or edit a cell comment in the active cell type Shift + f2
To copy the contents of a cell to the cell directly to the right select the cell in which you want the copy and then press Ctrl + R to copy the contents of a cell to the cell directly below it select the cell you want to receive the copy and type Ctrl + D
If you want to view all the formula in a worksheet press Ctrl + tilde use the shortcut again to switch back to normal view.

About Office Stationery
Office Stationery provides all your office stationery & office supplies requirements at fantastic discounted prices, from pens and paper to office furniture and more.

Orders are sent next day delivery with free shipping on all orders over £40. Office Stationery has over 36,000 lines of office supplies and is regularly adding new products and hugely competitive prices.