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
Word Tip – Replacing Formatting

Posted:

In this video we’ll show you how to automatically find and replace formatting in your documents.  The same dialog can also be used to find and repl...
Learn more
Excel Tip – Working with Time

Posted:

You may already use date formats and formulas in Excel, but what about working with time? If you’re using small units of time it’s important you u...
Learn more
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
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)