Insert cut cells
Insert cut cells: Don't waste time inserting a blank row before pasting into it. Give the copy or cut command as usual and then right click to Insert Copied Cells #Excel #Office365
Home and end in Excel
Home and end in Excel: Press the Home key to jump to column A. Press End followed by an arrow key to go to the end in the arrow's direction #Excel #Microsoft
Shift + drag to create the shape from
Shift + drag to create the shape from: Experiment with holding down Shift as you resize a shape - the centre of the shape stays where it is, so the shape isn't moved. #Microsoft #Office365
Shift + drag to make a regular shape
Shift + drag to make a regular shape: Drawing a shape in #Microsoft #Office365? Holding down Shift as you drag will make the shape equal on all sides so it's easy to make a perfect square or a circle.
Insert multiple columns
Insert multiple columns: Want to insert more than one column in Excel? Highlight the number of columns you want. Right-click and choose Insert! Works for rows too, and in #Word & #PowerPoint.
Alt+= does Autosum
Alt+= does Autosum: Would you like a keystroke that inserts the =SUM function. Use Alt+= and it's the same as clicking the button. #Microsoft #Office365
Change case
Change case: Quickly change make your text upper case by highlighting and press Shift+F3. Keep pressing to cycle between UPPER, lower, Sentence and Title Case. #Microsoft #Word
Creating a task from an email
Creating a task from an email: Drag an email in #Outlook to your Tasks to create a Task for the message. A new Task opens with the same subject as the message and all the text from the body. You just have to choose a date and time to do it. #Office365
Remove background from a signature in Powerpoint
Remove background from a signature in Powerpoint: Does your #PowerPoint image have an unwanted white background? Use the Remove Background icon on the Format tab to make it transparent. #Microsoft
Search folders
Search folders: #Outlook's Search Folders list all messages of a type whereever they have been stored. Use to list anything Flagged, Unread or from a person so you can file them in different folders but see them all in one place
Mini toolbar
Mini toolbar: Don't use the ribbon at the top for formatting. Right-click and use the mini-toolbar instead. #Microsoft #Office365
Double-click autofill handle to do whole column
Double-click autofill handle to do whole column: Instead of dragging the Autofill handle to copy down the column, double-click it and it will do the whole column automagically. #Office365 #Excel
Quick Access Toolbar
Quick Access Toolbar: Make sure you make full use of the Quick Access Toolbar in #Microsoft #Office365. Click the drop-down and tick all the options in Word, Excel, PowerPoint, Outlook, OneNote, Access and Project.
F7 spelling
F7 spelling: Run a spell check by pressing F7. Works in all #Microsoft applications.
F4 for absolutes
F4 for absolutes: Quickly include the $ in a cell reference by pressing the F4 key. Changes A1 to $A$1 in one tap. Keep pressing to cycle between A$1 $A1 and back to A1. #Excel #Microsoft
Type fractions
Type fractions: Want to display a proper fraction (eg 1/5) instead of a decimal in #Excel? Type 0 and space before your fraction and Excel will ignore the 0 so you get 1/5 displayed #Microsoft
ESC to cancel
ESC to cancel: Halfway through entering something in #Excel and you realise it's wrong? Press Esc to cancel the entry and start again. #Microsoft
F2 to edit
F2 to edit: Throughout #Windows you can use F2 to get into edit mode. EG highlight a file and press F2 instead of Rename. If a dialog box entry is highlighted, press F2 to show the cursor instead
Alt + shift + arrow to move a row
Alt + shift + arrow to move a row: Swap a table row or paragraph in #Word or #PowerPoint by pressing Alt+Shift+ an arrow key. The selected row/point will swap places.
Attach message first
Attach message first: To avoid sending the email before you've attached everything attach your files, write the message and address it last. #Outlook #Email