Useful shortcuts for Microsoft Excel

0
153
Useful shortcuts for Microsoft Excel
Image: Excel Intro screen

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.