UpskillTips
Please note that you will only be able to access articles from the newsletters you are currently subscribed to.
Tip 304 – Quickly insert a hyperlink
DOWNLOAD PDF Next time you need to insert a hyperlink in an email or document, simply press the CTRL and K keys together to open the Hyperlink dialogue box.
Tip 303 – Use a name instead of an address
DOWNLOAD PDF Cells already have addresses, such as A1, but you can assign names to single cells or multiple cells that you can then use in formulas instead of their
Tip 302 – Quickly create a dividing line
DOWNLOAD PDF To quickly create a dividing line in Word or in Outlook, type three hyphens (—) then press Enter. You can also use three tildes (~), underscores (_), asterisks
Tip 301 – Open folder in new Window
DOWNLOAD PDF From the File Explorer view you can open a new folder without leaving the folder you are viewing. Right click the folder you want to open from the
Tip 299 – Find and Replace with formatted text
DOWNLOAD PDF If you wish to change all the references to your businesses name in a Word document so that they are formatted in a particular way (bold, colour, font
Tip 298 – Easily repeat title rows on printed pages
DOWNLOAD PDF If you have a large list of data to print off on multiple pages and want to see the column headings or titles on each page, go to
Tip 297 – Quickly copy animations in PowerPoint
DOWNLOAD PDF In PowerPoint, once you have set up animations on a particular object you can quickly copy it to other objects in the file using the Animation Painter. Click
Tip 296 – Easily analyse data by month
DOWNLOAD PDF If you need to summarize a set of data by month, insert a new column next to the date column and enter this formula: =month(A1) to extract the
Tip 295 – Process email quicker by changing sort order
DOWNLOAD PDF If you have been away from your desk for a couple of days, rather than processing your emails in date order, sort them by the senders name, that
Tip 294 – Quickly convert a range to a table
DOWNLOAD PDF Converting a range to a table gives you instant filters and totals for each column. To do this quickly, select the cells you want to convert to a
Tip 293 – Quickly Delete all Images in a Sheet
DOWNLOAD PDF When you copy and paste information from a brochure or website, you may also paste icons or images you then need to remove. Rather than deleting each one
Tip 292 – View two sheets from the same workbook, side by side
DOWNLOAD PDF If you need to see two sheets from the same workbook side by side, open one of the sheets and click on the View tab. Click the “New
