Home » Resources » MINT Tips » MINT Tips - Review Nov 09

MINT Tips - Review Nov 09

MINT Tips – 27-11-2009

Microsoft Office

1.        Zoom – hold Ctrl and spin the mouse wheel to zoom in and out of a Document.

2.        In Word, Ctrl+] makes highlighted text bigger and Ctrl+[ makes it smaller.

3.        Alt+Enter = quick print

 

Internet Explorer

1.        Use Ctrl+D to quickly add a website to your favourites

2.        You can scroll down a webpage quickly by pushing the space bar

 

Security

1.        Lock your computer when away from your desk – the Windows Key + L will lock your windows session.

2.        Don’t enter your work email address into non-work related websites – this will reduce the likelihood of receiving SPAM (and keep your computer administrator very, very happy J)

3.        Don’t open attachments on emails unless you are SURE that the attachment is meant for you – if you don’t recognise the sender, and you think the attachment may be legitimate, send the email through to jobs@minttech.co.nz, and we will check it for you and sent it right back.

 

Microsoft Excel

1.        Copy formulas by Clicking on the Cell with the formula, Ctrl+C (copy), then move to the cell you want the formula to go into  and press Enter – now copy a formula, and Highlight a series of cells and push enter, the formula will copy into each cell and keep the relative row/column info.

2.        Click the box above Row 1, and to the left of Column A to select the entire sheet. Entire sheets can be copied to new sheets by selecting the sheet, clicking on the “Sheet 2” tab, and Ctrl+V (paste). This will retain formulas and formatting, very handy if you want to test some changes in a worksheet.

3.        If you want to change a series of cells to the same format (Numbers, currency, text, etc) as another cell, then highlight the original cell and click the Format Painter button (Paint Brush), then select the cells you want to change – you can select a single cell, or a range of cells, an entire column or even the entire worksheet. If you have lots of individual cells to change, then double click the Format Painter button, now every cell, range etc that you click on will change its format to that of the original cell. When you’re finished, you will need to click on Format Painter again to turn off the function.

4.        Use Print Areas to print only part of a worksheet, Highlight the section of the worksheet you want to print (or export to pdf), and click File, Print Area, Set Print Area. Now when you hit print, only that area of the worksheet will print out.

5.        Worksheet just too wide for the printer? Click File, Print Preview – here you can click on the margins button and slide them across to fit more info onto the page.

 

Microsoft Word Keyboard Shortcuts

Document   

   Print                                                CTRL+P

   Save                                                CTRL+S

   Undo                                               CTRL+Z

   Print Preview                               CTRL+F2

   Spell/Grammar Check               F7

Text / format         

   Copy                                               CTRL+C

   Paste                                               CTRL+V

   Bold                                                 CTRL+B

   Italic                                                CTRL+I

   Select All                                        CTRL+A

   Page Break                                    CTRL+ENTER

   Change Case                                 SHIFT+F3

   Underline                                      CTRL+U

   Grow Font One Point                 CTRL+]

   Shrink Font One Point               CTRL+[

Paragraph   

   Left Paragraph                             CTRL+L

   Right Paragraph                          CTRL+R

   Center Paragraph                       CTRL+E

   Justify Paragraph                        CTRL+J