Excel | Word | PowerPoint | Outlook | Milton Keynes | Rugby | Northampton

Word

Word: Cut or Copy to Spike

How to Cut or Copy to Spike in Word

The Spike is a feature I don’t see used very often. When you normally copy and paste the copy goes into the clipboard, but you can only copy one section at a time. The spike allows you to copy several sections one at a time and stacks them together so when you past from the spike all the sections are pasted. This also removes the copied sections from the spike.

Save As

F12 - Save AsF12 Key – Save As

The F12 key is a great way to select the Save As dialog box.

Ctrl + S is the shortcut for Save.

Pressing the F12 function key gets you to the Save As dialog much faster than clicking the File ribbon tab for the backstage view and then clicking Save As.

Customise the Background and Title Bar

How to Customise the Background and Title Bar in Microsoft Office

The customise feature in the Microsoft Office feature has no real practical use other than to be more pleasing to your own eyes. The video shows you how to change background and title bar colours in Office 2010 and Office 2016.

Import Currency Format to Word from Excel

Import Currency Format

Often I get asked how to import the currency format from Excel to Word as a straight forward mail-merge import loses the formatting. The formatting is carried out within Word by formatting the field within the document.

Mail Merge Excel currency format to Word

The three currency fields in this example do not have the £ symbol and do not have two decimal places.

You can display the field codes by clicking the Preview Results command on the Mailing ribbon tab.

Mail Merge Excel currency format to Word

Now right click on the field code you wish to format

Mail Merge Excel currency format to Word

Select Toggle Field Codes

Place your insertion point at the end of the code but before the }

Type \# £##,00    

note the space before and after \#

Achieve for Success – Learning for Success – Progress for Success – Training for Success – Planning for Success – Develop for Success

Milton Keynes Chamber Member

InIT Learning Computer Courses Milton Keynes

0330 32 100 58


 

Simple Pricing Structureslidecbc63a156cc04de8813a463a020004cc1Courses @ Yours
£640.00 per course of 3-8
£428.00 per course of 2
£258.00 One to One
(Plus Travel @ 45p/mile)

Scheduled Courses
@ Ours
£129.00 per delegate

1 to 1 Courses
@ Ours
£258.00 per delegate


InIT Learning
Harben House Business Centre
Tickford Street
Newport Pagnell
MK16 9EY

01908 92 50 58

0330 32 100 58