Did you know that when you copy data in Excel containing hidden columns or rows, Excel will copy the hidden data too? But what if you don’t want to copy the hidden data? Watch on…

To watch without sound, turn captions on by clicking 'CC' then selecting 'English'.

Share:

Other Tips and Tricks

View all
Excel Tip – Formatting Dates

Posted:

If you’re using dates in formulas or in lists and tables, it’s really important to format them correctly. And did you know, using a custom format,...
Learn more
Word Tip – Searching for Text

Posted:

The ‘Navigation Pane’ is a great tool for searching and finding text. It will show all your search results ‘in context’ and the text will auto...
Learn more
Outlook Tip – Quick Steps

Posted:

‘Quick Steps’ is an Outlook tool that lets you apply multiple actions to any selected email message(s). This can be a huge time-saver! Watch our v...
Learn more
PowerPoint Tip – Crop to Shape

Posted:

Using the cropping tools in PowerPoint you can trim and remove unwanted portions of pictures. Better still, ‘crop to shape’ lets you change the ou...
Learn more
Word Tip – Navigation Pane

Posted:

The Navigation Pane allows you to quickly jump to headings in your document. It’s also a real time-saver when it comes to rearranging paragraphs of ...
Learn more
Excel Tip – Wrapping Text

Posted:

Formatting text to fit in cells can sometimes be a bit troublesome. In this video we show you two simple ways you can wrap text around to fit in a cel...
Learn more
Word Tip – Numbered Headings

Posted:

Some of you may already be using styles to format your heading text. One really useful modification is to automatically number your headings. Follow t...
Learn more
Excel Tip – Date Series

Posted:

Using Excel’s ‘fill handle’ it’s simple enough to create a sequence of days. But what if you need to create a different date sequence; months,...
Learn more
Word Tip – Small Capitals

Posted:

When applying ‘small caps’ to text, your lower-case letters appear as small capitals. This format is ideal for signage and emphasis, when normal c...
Learn more
PowerPoint Tip – Saving Images

Posted:

PowerPoint provides options to save either entire slides or individual objects within a slide as separate ‘graphic’ files. Once saved from PowerPo...
Learn more
View all

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)